Apply row-level constraints to JPQL band queries

[alexbudarov]

forum topic: https://forum.cuba-platform.com/t/are-accessgroup-constraints-used-in-reports-addon/13195

If we can write a Groovy band with the same query with DataManager, and row-level constraints are applied.

Then why we can't apply constraints to queries in JPQL bands in a report?

Are there any technical implementation problems?

[alexbudarov]

Example of query generated by Report Wizard:

select
e.question as "question",
e.answer as "answer",
e.lang as "lang"
from playground_Card e where e.deck.id = ${deck1}

(loads only fields)

[gorbunkov]

It seems that we cannot implement the "values" query that guarantees that row-level security is applied to all entities that participate in the query