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 ?