[SOLVED] Sorting of Multi-select fields in CB list

Hi,

I'm using CB to manage participants of an exhibition.
The participants are registered as CB Users and they offer apprenticeships.

On my website there shall be two lists in alphabetical order.
One list shows the participants. This is the easy part.

However, there shall be a second list that shows the apprenticeships and next to it the names of the participants who offer the respective career.
So far, I created a Drop Down Multi-select field for the apprenticeships, to make sure the spelling and denomination is the same in all entries in my database.

My question: Is there a way to display the Multi-select field content in alphabetical order and connect them to the participants?
I know, this sounds quite complicated. So I try to explain in an example:




Hope you see what I mean. There must be a list of Apprenticeships in alphabetical order where I can click an entry to see the contact data of the related company.
Could this be done with a plugin like "CB Query Filed" or "CB Auto Actions"?

Would be great to get some hint how to solve this problem.
I'm really stuck at the moment...

Thank you for your time and attention.

Regards,
Dirk

You basically have a list within a list situation as you want to list the different apprenticeships then list the companies associated with that apprenticeship. The easiest way to do this is just have a userlist that lets you filter by apprenticeship then users can just select 1 or more apprenticeship they're looking for and it'll list the companies associated with the selected apprenticeships. By default it'd just show all apprenticeships. Basically your existing userlist is sufficient for that case.

Your other usage just wouldn't be scale-able. What happens if 100 companies offer apprenticeship to something? It becomes a giant page scroll displaying that. I suppose you could implement it using a custom database query in a CB Query Field, but I don't really recommend that.

Hi Krileon,

thank you very much for your reply!

So, if I get you right, I have to create a separate userlist with a filter for each apprenticeship?
Or is there an option to let the visitor define the filter instead of doing a search?

Best regards,
Dirk

Your users should just be able to search the apprenticeships field as long as the field is configured to be searchable. You could do both I suppose. Have 1 userlist that shows everything like you currently have then have other userlists with 1 apprenticeship per list filtered (see Filters tab of your userlist to filter by your field).

Thanks, we solved it with separate userlists. Works nice.