How to Show /group data only once in a repeating group

Need help Database
1

Hi, I need some help.

I have a database like this:

LOT    Article
Z11326	79MPGE1
Z09596	79MPGE1
Z08350	79MPGE1
U32249	39MSS10060
U30747	39MSS10100
U29745	39MSS10080

I want to show in a repeating group every article only once. I used the “unique elemts” but I doesn’t work and shows me all entries of the databse:

This is what i did in the repeating group

image
image710×514 42.7 KB

But the result looks like this:

image
image700×502 27.3 KB

2

Hi, you would have to filter the datasource of the repeating group. Can you show us you querry?

3

Try using the ‘group by’ operator instead of unique elements.

4

Thank you all, I did it by using a TEXT type and the yiu the value seleceted from the repating group in a popup for a new do a search for.