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 

I am not sure how easy it is on the portal , I am not a coder so the script is something I cant help with. @Sandeep Rajput  @Community Alums  @Medi C  @Mark Manders  any help here.

[Shaqeel]

Hi @vidhya_mouli 

Have you tied using Reports?

If I fully understood the issues you then you can create new Report and use filter competency = language and use grouping to group by oral and then by language.

Regards

Shql

[vidhya_mouli]

I am displaying these values in the portal through a widget.