ordering element join

[roberto.c87]

hi everyone, when I make a left join between two tables and try to sort the element (show in list), the elements of the first table are always shown before the items in the second table. You can display before the elements in the second table?
table A:element 1, element 2
table b:element 3, element4
table A Left Join Table B
the result ordering is Element 1, element 2, element 3, element 4 but i want:
element 4, element 3, element 1, element 3
Thanks

 

[cheesegrits]

I don't think so, no. Elements are always going to be ordered within their group. Same way as on the form. Regardless of how you mix ordering, with group 2 elements before group 1 elements, on the form they are still going to display within their own group. Same on a list.

-- hugh

 

[troester]

Try with the menu item setting Fabrik list options/show in list

 

[roberto.c87]

Thanks , I solved it with menu item setting Fabrik list options/show in list

 

[troester]

You can close solved threads by unchecking "open" in Thread Tools.

 

[roberto.c87]

[QUOTE="roberto.c87, post: 242971, member: 51216"SOLVED]hi everyone, when I make a left join between two tables and try to sort the element (show in list), the elements of the first table are always shown before the items in the second table. You can display before the elements in the second table?
table A:element 1, element 2
table b:element 3, element4
table A Left Join Table B
the result ordering is Element 1, element 2, element 3, element 4 but i want:
element 4, element 3, element 1, element 3
Thanks[/QUOTE]