feat: Add custom numeric collation - Githubissues

molgenis / molgenis-emx2

MOLGENIS EMX2, the latest version of the MOLGENIS data platform.

GNU Lesser General Public License v3.0

11 stars 16 forks source link

feat: Add custom numeric collation #3820

Closed connoratrug closed 1 month ago

connoratrug commented 1 month ago

What are the main changes you did:

Add new 'numeric' collation to molgenis schema, via migration 19
Use numeric collation on orderby, this ensures 'var_2' comes before 'var_13'

how to test:

Create a column ( add rows unsorted), containing string items that are a combination of alphabetical chars and numbers ( for example var_13, var_3 ), fetch this field and sort by the col containing the described string; 'var_3' should now come before 'var_13'

todo:

[ ] updated docs in case of new feature
[x] added/updated tests
[ ] added/updated testplan to include a test for this fix, including ref to bug using # notation

sonarcloud[bot] commented 1 month ago

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
83.3% Coverage on New Code
2.9% Duplication on New Code

See analysis details on SonarCloud