HCAP-1341 Remove additional unneeded sorting

[arranfw]

https://freshworks.atlassian.net/browse/HCAP-1341

I guess lodash and postgres treat spaces differently in their sorting algorithms

• removed extra sort on FE for sitenames

[arranfw]

@alva-fresh

We also use it in SelectProspectingSiteForm.js and src/pages/private/UserView.js. Do you think it's a good idea to remove it in there as well?

Great call! thank you!

[taraepp]

I think this will deal with some of the sorting behaviour, but postgres's sort is also case-sensitive so I'm thinking there may still be some issues. In the raw query you can do lower()/upper() on the order by field but not sure if massive will cooperate.

[arranfw]

I think this will deal with some of the sorting behaviour, but postgres's sort is also case-sensitive so I'm thinking there may still be some issues. In the raw query you can do lower()/upper() on the order by field but not sure if massive will cooperate. !

It should at least get the sorting to be consistent between the two components which was my understanding of what this ticket was describing

[sonarcloud[bot]]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
0.0% Duplication