Is there any way to get the SQL text of a servoy search? I’m adding a little something to my solution where you can generate a list of contacts for the purposes of bulk emails / letter printing and so on.
What I want to be able to do is have the resultset generated by either 1. a find query on the contacts table (done by regular users cause its easy) or 2. if a much more complex query is needed (multiple tables deep etc) an sql query that can be manually entered by someone with technical knowledge.
It would be nice if I can somehow get the sql query that was used in a find, so that I can have one field ‘sql_query’ regardless of how it is generated.
Cheers
Willie