Convert QueryOptions to SQL Query

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Version 8.X

I have a QueryOptions, at the moment I run context.search(Identity.class, qo); its generated a SQL Query, I want to get the exact same Query that is going to be generated.

Hope there is a way to convert it.

2

you have to enable database log . are you looking for any specific QueryOptions?

3

Hi Moisés Estevão,
Enable database log once done your can see all the activity or query

4

I think I wasn’t clear enough. What I want to do is something like this:

QueryOptions qo;

//Fill the qo.

String sqlQuery = qo.toSqlQuery(Identity.class);

// I’ll use this sqlQuery String as a suquery for another process, so I need to get this at runtime…

5

Is this requirement only on one particular Object like identity or are you looking for a Composite Filter kind where joining multiple tables?