So I'm almost done with building a J4 verson of a component I built 7 years ago. I've figured out almost everything, except how to filter and sort a dropdown list in the admin component edit page.
I have 3 tables. Council, Club, Board. A club has Board Members and belongs in a single council.
When you go to edit a Board Member, the dropdown list of Clubs that the Board member might belong to is 1.) sorting by ID and 2.) displaying entries that are not published any more. I need to filter that list by just the published clubs and sort it by club name.
I was trying to find an SQL statement somewhere, like how the filter dropdown does it. But after a few hours of poking in the code, I just can't figure it out.
We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.