debug insight query with date (less then)

Hello,

is there an option to debug the insight queries ?

Eg that we see the SQL statements that are generated in the backend ?

We have the problem that we have added a custom attribute at the account level which contains a date (specific expiration date). Now we want to use a insight query where we connect the identities with the accounts and filter based on that account expiration date. But whenever we try to compare the attribute with a date it does not report any results. The attribute is from type date and the values there in are in a correct format, also the filter definitions show a calendar to select a date from. So I think that all should be okay.

Is there anything that is problematic with comparing dates in queries ?

Rainer

 

Parents Reply Children
No Data