APEX

Hi

I would be grateful for any help/advice for implementing the following please.

I am trying to build a skills database e.g. John Smith knows these skills at such and such a level.

Ideally I would like faceted search so you can look for people who, for example, know oracle at expert level and excel at intermediate level.

I tried initially having a shuttle to select skills but having a single column with values separated by a colon is not easy to use or search.

I am able to still use the shuttle but, with custom code, store the values as rows in a separate (detail) table for each user.

Now, if I join the tables I get as many rows as skills. I can create a facet search page and it works as expected but my report shows multiple rows for the same user.

If I were to store the projects that each user is associated with, I may even have more rows per user - I only want each user shown once.

Is it possible to have the report display one row per user but still be able to search, in this example, for skills?

I have seen a similar request here - https://stackoverflow.com/questions/58537905/creating-facet-with-source-of-multiple-value-column but, unfortunately, no solution.

Thank you very much in advance for any help

Trevor