• Graphical Query tool - selection criteria based on Expression

    Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…
  • Sagex3 - graphql query with a list filter

    We have the need to query a list of products using the new GraphQL API. The filter in specific is a list of product IDs. We already took the graphql training and this is not addressed anywhere. Could you please help? This is the query that we are trying…
  • After validating the graphical query, it automatically deletes the JSON file used to run the query

    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…
  • How to remove line number from the graphical report created using SQL query

    Dear Sagians, I have graphical report created using view and sql query, but the problem here after adding this into dashboard is instead of date, line number is coming[Below screenshot] Any ideas to display the date here. Note: When running the report…
  • V11 Graphical Query Tool

    Is there a way to export or see the fields used on old Graphical Queries that are no longer visible. Will then use this to create new queries via the old graphical tool
  • Graphical Query Timestamp

    I'm trying to pull in the current date/time as an expression field. Is there a particular data type I should use? Will that function work that way?
  • Graphical Query

    Is there a way to force unique records only?
  • Graphical Query Incorrect Link

    I am attempting to create a simple query showing invoices that have been posted for the day. I'm using SINVOICE, SINVOICEV, SINVOICED, and GACCENTRY all joined via NUM_0, plus a join from SINVOICE.GTE_0 to GACCENTRY.TYP_0. When I attempt to save/validate…
  • Is it possible to calculate the number of days between two fields using the graphical query?

    A client has requested a new query, specifically looking at outbound deliveries. I have created a query that shows all deliveries with a departure date, and the arrival date (for this client, any delivery with a blank arrival date will trigger an action…
  • Graphical Query Tool - Adding Same Table Multiple Times?

    I am trying to create a query under Graphical Query Tool to display product information using the ITMMASTER table. Each product also has multiple analytical dimensions attached to it. I am trying to link ITMMASTER to CACCE to display the dimension description…
  • SQL & Graphical Query

    I have the following Graphical query, the two tables are BPCUST AND SINVOICE. How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018. When I search for this its outputting all the invoices and duplicating…
  • Graphical query tool's formula wizard

    Hi All, I am trying to filter out results that do not have a dash ( - ) in it's ITMREF from a graphical query. Any ideas how I may be able to do that?
  • IF THEN possible with Graphical query tool?

    I've got an existing Graphical query tool report that I'm working on. I'm having trouble with an expression formula (using formula wizard). Basically I want an IF/THEN statement. It says I have an illegal character. Are these kinds of conditional expressions…