RE: Removed Query Fields not recognized in TraceParser SQL
hi
It's possible that the changes you made to the data sources in the query have not been fully reflected in the Select statement generated by the query. This can happen if the query's cache needs to be cleared or refreshed.
To ensure that your changes to the query's data sources are fully reflected in the Select statement, you can try clearing the query cache and running the trace parser again. Here are the steps to do this:
Open the AOT (Application Object Tree) in Dynamics AX.
Expand the "Queries" node, and then locate the query you modified.
Right-click the query and select "Delete elements in cache" to clear the query cache.
Right-click the query again and select "Generate SQL" to regenerate the Select statement for the query.
Run the trace parser again to see if the changes you made to the query's data sources are now fully reflected in the Select statement.
If the Select statement still includes fields that you removed from the data sources in the query, you may need to review the query's join criteria and ensure that you've included all the necessary fields to support the join conditions. You can also try removing and re-adding the data sources to the query to ensure that they're properly linked.
Daniele
