Utilizing a "Like" or "Not Like" function in Sage Graphical Query Tool

Hello, 

Could someone point me in the direction of a function cheat sheet of sorts for graphical query tool? I SQL experience but I have been successful in completing some queries using the graphical query tool. 

For example, I have been unsuccessful with filtering all products that start with a given string:

 [F:ITM]ITMREF LIKE 'XXXX%'

  • 0

    hello, I am not aware of any cheat sheet with what works and what doesn't. The only documentation I know about is from a class on Sage University.

    X3 - Sage X3 - Introduction to Requesters/Queries

    https://sageu.csod.com/ui/lms-learning-details/app/event/eaf40bbb-f4c3-4dc3-9698-9d8a00884c1b

    Here is what is covered and what type of documentation you receive:

    By attending this course, you will learn:

    • How to create and modify Classic Requesters/Queries including reviewing and modifying joins between tables of data
    • How to create simple requesters/queries using Graphical Requester/Query including creating complex links and adding new Keys to existing tables
    • How to create simple requesters/queries using SQL Requester/Query including using an alias on a table, defining conditions, and joining tables without Keys
    • How to create a View with a Key as well as how to create a view to display summary information.
    • How to present information on the Home page using menu items, exporting data to a spreadsheet, and using a Dashboard View.