Sage X3

Hello I want to write the following SQL Query as 4 GL Link instruction: As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL. In 4 GL I make a left outer join and check with [F:YCFPJOB…

The title says it all. Only happens in some folders, v12 Patch 31. The work around is to take a patch of the graphical query from Problem Folder, integrated it into a Known Good Folder, and after validating, copy the JSON file shown in the error from…

Hi there, Is there any way of passing a list of values (comma separated or equivalent) as a Criteria parameter in the printouts > SQL Query Tool Also, how to remove character limitation from that field... what i'm trying to achieve is something like this…

I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?

when i click on the query cell to change it to yes it just jump for initial state, but for some others columns it's ok

Hi Everyone! Wish you all an great 2021! I'm new to SAGE X3. How can I refresh a query on "landing page"? I've tried with parameters "portview" and "frequency" but no success. Am I using the parameters correctly? Thank you, for your help.…

If my stored procedure contains the statement below. It works. select top 10 ITMREF_0 as ITMREF,ITMDES1_0 as ITMDES from ...ITMMASTER If I change to dynamic sql below, declare @sqlTextAll nvarchar(max) set @sqlTextAll='select top 10 ITMREF_0 as…

Query Tool created in v6.5 and added in the landing page. when i click "Current Fiscal Year Asset Acquisition" from the landing page, we have "Criteria" option to select the ranges. Same Query Tool configured in V12 and added in the landing page…

I'm trying to return data for an array of parent/child items in a custom X3 web service (Version 12). Specifically, I'm trying to get invoice data. Normally, I would just publish the appropriate object as a web service, and I could make a call to get…