Sage X3 Ideas Portal

Reference: https://communityhub.sage.com/us/sage_x3/f/general-discussion/259690/x3v12p38-factoryowner-sage-has-been-implemented-on-queries-how-to-wholesale-validate-all-the-query-tools-and-trt-scripts

Sage X3: v12p38

From Sage X3 v12p38 patch document: https://online-help.sagex3.com/x3-release-notes/index.html#/release/en-US/2025-r2-38

```

FactoryOwner SAGE has been implemented on queries

• Query tool (GESALH)

• SQL query tool (GESALQ)

• Graphical query tool (GESALT)

This means that once the update is complete, the standard queries provided can no longer be modified.

If standard queries have been modified previously and you want to keep these modifications, you must duplicate them and rename them before updating.

Once the update is done, you will need to validate each SQL query tool (GESALQ) before running the queries.

For each child folder and for each query, perform the following actions (here for example on MANHLD query from SQL query tool (GESALQ))

Setup > Usage > Reports > SQL query tool (GESALQ)

• Select MANHLD and click the Validate button.

```

Is there a way for a technical consultant to validate all the queries rather than going through each of the query tool's list and validate each query manually?

Last I checked on VALDICO there's no option for Query Tools (all three standard, SQL, and Graphical) validation.