My cb members are required to pick (from a drop-down single select field) their primary practice area (cb_practiceareasb). They also have an option to pick 2nd and 3rd practice areas from identical drop down single select fields , cb_practiceareasb2 and cb_practiceareasb3.
I've created a cb user list for each value in the practice area fields, and using the advanced filter:
`cb_practiceareasb` ='value1' OR `cb_practiceareasb2` ='value1' OR `cb_practiceareasb3` ='value1'
I can get the user list to display all members that have selected value1 in any of the 3 fields.
What I want to do is have the list display members with the primary cb_practiceareasb field matched first, then display matched to cb_practiceareasb2, followed by matches to cb_practiceareasb3. This is more of a grouping thing than a sorting thing...
In other words, I want the list to group members by which of the fields match the value1 in a specific order.
Is this possible?