Problem with query visualization

Hi everybody, I made a complex custom query that uses another custom query repeat as a filter.
First query: I read a value ‘codcatmer’ from a table. (Every user can have one or more ‘codcatmer’ associated with his user code). In this case results are ‘XXX’ and ‘YYY’

Second query: In the next step I use ‘XXX’ and ‘YYY’ for read values from another table, filtering rows who have ‘codcatmer’ with that values

It seems working: if I do the preview in the browser, I see the correct values.
In red the values i’m searching (‘XXX’ and ‘YYY’)

Now that’s the problem:
if I try to put the data in an automatically generated table, I only see the records related to the first value. (I see only rows with ‘XXX’ and not ‘YYY’)



What am I doing wrong ???

Community Page
Last updated: