Filtering XANO results

Hi;

Does somebody know how to filter a “GET all” call in a external collection in XANO?

I mean, how to fill the “Query and Value” inputs?

and tried many things and i’m always getting all items in the list.

@xano please help.

Thanks.

Have you already created the external collection database? Once that is done you simply can create a new page with a List Component and use the external Xano Collection for the “list of”.

Let me know if it something else you are trying to do?

Yes, as you can see in the attached image, I’ve selected an external collection, and I need to filter the result filling the query parameter with the property name and value but it is not working, I’m always getting all the records in the collection.

Thanks.

Ah so the best way to do this is create a new API Get Endpoint in Xano with custom Query parameters for what you want to filter.
Then create a new external collection of this new API Get call. Add the Query Parameter(s) you will be using and then you should be able to pull the Magic Text for the values.
In one of my cases it was the UserID.

1 Like

Thank you @rickman I will try it.

Thanks @rickman for helping @Malik out. Malik if you’re still having issues let us know and I’m sure we’ll be able to help you figure it out!

2 Likes