Ignore case sort

Classic Servoy
1

Beginners question I am sure.

How does one conduct a sort that ignores case…

I currently has the following statement…

controller.sort(“project_name asc”)

I tried…

controller.sort(“#project_name asc”)
Obviously that didn’t work.

Thanks in advance.

Kind Regards
Jonathon

2

Jonathon,

Currently that is not supported.

You can add a feature request to the Servoy support system with this request.

I guess we could sort on ‘order by lower(project_name) asc’.
This seems to be the way to do this in Hibernate, but I don’t know if this will work on all databases.

Rob

3

Thank you very much for your direction…

Cheers
Jonathon

4

rgansevles:
Jonathon,

Currently that is not supported.

You can add a feature request to the Servoy support system with this request.

I guess we could sort on ‘order by lower(project_name) asc’.
This seems to be the way to do this in Hibernate, but I don’t know if this will work on all databases.

Rob

+1

5

rgansevles:
Jonathon,

Currently that is not supported.

You can add a feature request to the Servoy support system with this request.

I guess we could sort on ‘order by lower(project_name) asc’.
This seems to be the way to do this in Hibernate, but I don’t know if this will work on all databases.

Rob

+1

6

+1

7

Hi Omar

I have raised an issue. >> https://support.servoy.com/browse/SVY-2817

Please could you tell me what is Hibernate?

I was wondering if I could do the sort on a calulated field - something like lower(project_name)?

Kind Regards
Jonathon

8

Hi Jonathon,

I voted for it. Hibernate is a mapping model for Java that allows mapping of objects to their relational database counterpart (Hibernate (framework) - Wikipedia).

It is possible to sort on a calculation but only if it is a stored calculation. A stored calculation has the same name as the table field and a checkmark in the ‘stored’ column checkbox. However there are some disadvantages to this approach. The request you filed would be a better solution.

9

Thanks for voting for it!

At least it isn’t another case of i don’t know what I am doing.

Cheers
Jonathon

10

The only difference between an expert and a beginner is that the expert has made all the mistakes already. :wink:

11

omar:
The only difference between an expert and a beginner is that the expert has made all the mistakes already. :wink:

LOL - good one!