Need help in sorting

[vidhya_mouli]

I have a table which has 100s of fields, like competency, language, written and verbal.

I am going to process different competencies and display them. All the competencies are sorted based on different things.
When the competency is language, it should be sorted based on the following:

1. First the language where oral is native should be displayed.

2. Then all the other languages should be sorted based on alphabetical order (and not based on oral.

How do I do this?

[Dr Atul G- LNG]

Hi @vidhya_mouli 

Could you please provide some screenshots showing how you are storing these values in a single field or multiple fields, and how Oral and Native are linked in a parent-child relationship?

If it is in 1 field then no way to multiple sort but more than 1 field, still think and try.

[vidhya_mouli]

competency, language, oral and written are fields.

oral and written are choices with the following values: native, good, fluent, basic and no_knowledge

Sample values:

competency	language	oral	written
language	hindi	native	native
language	german	good	good
language	french	beginner	beginner
language	zulu	fluent	good

For the above, when displaying it should be:

hindi, french, german and zulu

[Dr Atul G- LNG]

Hi @vidhya_mouli 

It’s similar to a pivot table, but the pivot sort in the report isn’t working correctly.

As I understand it: [ These 2 should be in conditions always]

• Competency = Language
• Oral = Native

And sort the language [A-Z], try this way.

[vidhya_mouli]

I think I was not clear when I asked the question. I am not using reports for this purpose. I am displaying this information in the portal through a widget. I am looking for the script for this purpose.