I’m working on transforming FireDac based queries to DA.
First I added a TDAMemDataTable “qry_rights_user” and set a filter, with Codesite the result set was tested, all ok.
Another table "qry_right"was added with cloned source set to “qry_rights_user” and a method used this
table to filter by field “df_id”.
It seemed to work but realized that one filter failed although a record exists with the df_id it says qry_right.isEmpty = true.
I am lost … but I try to setup a minimal example for testing.