3 years ago
4
Topic

Hi

How could we sort a seblod list of users on the groups they belong ?

If I put the user groups field in the ORDER tab I get an error "Unknown column 't3.groups' in 'order clause'" even if I also put the user groups field in the search tab.


thanks


cyril

Get a VIP membership
4229 Posts
Kadministrator
3 years ago
0
Level 1

Seems this field is similar to tags field where Seblod does some additional queries in background to get the info. You will need to add some joins and order part manually by using search join and search query fields.

3 years ago
1
Level 1

Hello Klas

yes but what is strange is the fact that in the SEARCH tab the user_groups field is correctly understood the and jointure is done. if you activate the debug you can clearly see that the Query makes a JOIN with #__user_usergroup_map 

however in the ORDER tab the same field is not recognized. 

Actually what we are trying to do is to SORT the users according to their groups and make a kind of GROUP BY 

list of the users from group1

list of the users from group2

list of the users from group3

Maybe this cannot be achieved without a free query ?

Cyril

4229 Posts
Kadministrator
3 years ago
0
Level 2

Missing feature I guess, see my previous answer.

3 years ago
0
Level 1

Hi

since in our case we can't use a free query I hope this issue will be fixed soon or at least someone could send a patch. Anyway here is the issue on the seblod git

thanks

cyril

Get a VIP membership