Allow to sort concepts ids by colour at field value level

[erummas]

Is there an existing issue for this?

• I have searched the existing issues

Is your proposal related to a problem or functionality gap?

currently we can not sort the concept_ids, it would be helpful to have this feature so we could see the mapping of different types of mappings along with missing mappings.

Describe your proposal

Sort on colour

• White - No mapping
• Blue - Manual mapping
• Lilac - Automated mapping

Describe alternatives you've considered

No response

I'm part of a Project Team

No response

Anything else?

No response

Are you willing to contribute to developing this feature?

None

[spco]

2 questions:

1. Sort on name or ID?
2. What should happen when a single value has multiple concepts associated, given we have one row per value, not one per concept?

[erummas]

1. Sorting on name may be helpful but IDs isn't helpful, as we do not achieve anything looking at sorted concept_ids. However sorting on colour or mapping status (not mapped, manual mapping, automated) will help us review these mappings in a better way (as mentioned in proposal).
2. In case of multiple mappings there may be one of the given three scenarios
   a) Multiple automated mappings
   b) Multiple manual mappings
   c) Multiple manual + automated mappings
   in all the above cases irrespective of which filter fits I think it would be sensible to show all mappings (and I think sorting on ID numbers or names may be tricky in this case then thus the status)

[AndyRae]

Yes I think clearly we need an improved way to navigate mappings at scale, similar to #725

Our existing data model will make it difficult to filter/sort for Concepts mapped, so we'll investigate a different approach technically.
I'd be interested to know more about the "review" process, given the number of pages that a report now can have - maybe we could help with an improved experience there?