Filters for Relationship Field Items
Created 6 years ago by jcastillotxI have a sponsorship field that is a relationship (sponsors). If I put in the sponsorship_sponsors into the filter I get a dropdown of emails for that filter. I would like to be able to search by last name instead of a dropdown of the emails. How can I do that?
ryanthompson
—
6 years ago
I had this in mind too - definitely doable just and pretty easy too!
In the meanwhile you can easily do this with a generic text filter too. The filters query handler will just join / search with LIKE or something.
ryanthompson
—
6 years ago
@jcastillotx please try and use more descriptive titles from now on too 😊
jcastillotx
—
6 years ago
Sorry suffering from China CRUD as I sit consuming air pollution in Beijing.
ryanthompson
—
6 years ago
@jcastillotx yikes! I feel for ya man - no worries 😊
Seems like a good improvement to the relationship field would be to add the ability to select the column that displays in the UI. I've used it before and the dropdown displayed the ID which wasn't really helpful.