False duplicate records

[georgie]

Hello everyone

I notice that in some lists, I have duplicate records, which appear 2 times, while in my table they are only once ...

Can you help me?

Thank you!

 

[cheesegrits]

That usually means you have joined data, i.e. in the List joins section, and you haven't selected "merge rows".

-- hugh

 

[georgie]

No, I have selected this option, but sometimes, after sorting or grouping field, I have this phenomen...

 

[troester]

In a joined merged list you must make sure that the first sort field is in the main list (e.g. id).
"Merge" is merging only records which are displayed side by side, so if you are sorting by an element of the joined list you may get something like

maina - joina
---------------
mainb - joina
..........;- joinb
-----------------
maina - joinc
...........- joind

 

[georgie]

OK but in my list I display only field from the main table, so all sort are done on fields from the main table !

But I notice that the problem appears when I sort on a chekbox field that can contains multiple values. Is it linked ?