Convert X-Path constraint into SQL Query
What type of join can be used while converting a X-Path constraint into an SQL query, so that we get the same data in both the cases? Note: Consider about multiple tables associated with each other.
Soumya Ranjan Bindhani
If you want to see the exact SQL generated by your XPath constraints, set the log level for Query Parser to trace, as shown below in the Modeler:
Then you'll get detailed SQL for each query in your log, for example:
Hope that helps,