This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
7 Posts
jfquestiaux
20 days ago
6
Topic

Hi,

I have a list displaying the values of an SQL request (the count of some elements). I can sort by all the other elements in the list but not on this element, whether I set the type in "text" or "numeric" (it's actually numerical values). Is it possible to sort such a type of element?

Get a VIP membership
4196 Posts
Kadministrator
20 days ago
5
Level 1

Hi,

exactly what type of the filed you would like to use? For sorting you can use any normal form field (text, select etc), but ofc you can't use e.g. list field or similar

7 Posts
jfquestiaux
19 days ago
4
Level 2

Thank you for your answer but I'm sorry to not understand what you mean by "ofc you can't use e.g. list field or similar". The field I try to sort is a "SQL request" type: 

I have a list of "things" - each activity has a certain amount of "features". The SQL field counts how many "feature" each "thing" has and returns the result as a number in the list of "things". This works fine.

I can order (asc or desc) this list by the name of "things" but ordering by the amount of "features" does not work, whether I set the type "text" or "numerical".

4196 Posts
Kadministrator
19 days ago
3
Level 3

Hi, there is no SQL request field type, do you use one of this fields? https://www.seblod.com/store/extensions/19162

7 Posts
jfquestiaux
19 days ago
2
Level 4

Yes, it is actually "SQL Query" (part of the "Processing" group in the list of types) and I did buy the "SQL pack" so I assume that's what it is.

7 Posts
jfquestiaux
11 days ago
1
Level 5

Friendly bump.

1114 Posts
Bucklash
10 days ago
0
Level 6

Hi

In all search and list situations i always put debug on.

I don’t know if the search will recognise your sql query field’s value... you will find that out :)

Get a VIP membership