How to apply a prefilter on a repeat group ?

[Borox]

Hi,

I use a repeated group on which I want to mask some record.
The prefilter on the repeated group itself doesn't seem to work, only the prefilter on the master list works.

So, is there a way to exclude some records of the repeated group based on elements of this repeated group?

Example: I don't want the records of the repeated group where a particular field ' has the value '1'

Thanks

 

[troester]

You must add the prefilter to the master list, the prefilter should show the childlist's elements in the "Field" dropdown
WHERE your-childlist.your-element ...

 

[Borox]

Hi @troester

I've tried that, but my master record disapear if the repeated group has no record. Is there a way to avoid that? that's the reason why I tried first to apply the prefilter on the repeated group and not on the master.
Thanks

 

[troester]

hmm, yes, confirmed.
It's ok with Display mode = each row separatly

Something is going wrong while merging.

 

[Borox]

thanks @troester , I checked, I'm using 'Merge row and reduce data', I'll test with 'each row separatly'

 

[mmmag]

I apologize for raising such an old topic. I have the same problem. But I need the main table to be visible to everyone, and inside the repetition group, the recording should be visible only to the user who creates this record.
It doesn't suit me when "'Each Row Separatly'"
I came across such a problem on several of my projects, is there really no solution?