• Menu item - type: query - "where" parameter operators

    Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…
  • Refresh landing page

    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.…
  • Dashboard not returning any data

    Hello, I have an issue where I created a query that returns the data as I want it to return it. When I link the query and create a gadget and then place it into the dashboard, it returns no data. I worked it out as why. There is a custom filed…
  • Add SQL Query to Dashboard vi Menu Item

    I tried to follow KB KB 70139 but it doesn't appear to work for our version or I am missing something. I did create a View and that is working correctly from the USAGE-SQL Query because it is showing results but when I add it to a menu item, I get an…
  • Show record count for a existing query

    Does anyone know if and how you might create a query that shows the record counts for existing queries? Specifically, I'd like to show the record counts for selected queries in a tabular "to do list" format. For example: TO DO 8 Orders…