Dynamic SQL in query BI

Summary:

I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE condition on my report. However, the query is being returned as static text instead of an executable query.

That is, i want to retrieve the assignment IDs from the custom criteria and use those assignment IDs in my actual query's WHERE condition

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):