How to filter data

GavinReid

Hi all,

How can I filter the data that is called from a Xano table to my frontend? Here are three examples/scenarios:

1. Only show upcoming events (not past events) in a feed;
2. Fetch certain data by category (e.g. only vegetaian food, only gluten free etc) to be displayed in a feed;
3. If a user only wants their post to be available to certain people (e.g. they want to invite males only).

If you can explain how to do this in the simplest terms possible, you will have my eternal respect!

Thanks in advance.

Michael Udinski

Hi @GavinReid here's a very basic example of how to filter records in Xano:

https://youtu.be/XNv5bynxdx8

You can apply this framework to all the use cases mentioned above.

1. Upcoming events: You'll want to compare your date/timestamp field with the value of now in Xano. (example: event.start_time > now)
2. Where event.category = input: category
3. Is more of a RBAC/Restricting Access use-case. You'll be able to pull user info with a get record based on the auth token provided. Here's documentation and a tutorial on this type of logic: https://docs.xano.com/building-features/role-based-access

GavinReid

Hi @Michael Udinski, thanks a lot for this!

GavinReid

@Michael Udinski, not really a Xano question, but would you have any idea how I would get the filtered data into a feed in draftbit? E.g. a feed that only shows vegetarian food?

Michael Udinski

@GavinReid this should come from the filtered API in Xano, then you'd display the resulting data in Draftbit