Custom Query - Relation Table in list
Options
myrko
Member ✭
I want to apply a filter to the table, and the field I will filter is a list in table relation, meaning, I want to fetch the items that contain the IDs 1,2,3 from the list, but in all the ways I've attempted, the custom query isn't working. Does anyone know how to do it?
Answers
-
here is mine example u might find a use of -
create addon that reach to whatever related data you needmake output blank in addon settings and only return one key you need - like so:
in final result enjoy it as a native key, with like a "lookup" for any field in any related table:
from here you can filter it as if you would with any other key:value in your record
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback