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.