# Filtering XANO results **URL:** \ **Category:** External Collections, Custom Actions & Collections\ **Created:** [February 2, 2021, 7:21pm UTC](https://forum.adalo.com/t/filtering-xano-results/8688 "2021-02-02T19:21:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Malik](https://avatars.discourse-cdn.com/v4/letter/m/e36b37/32.png) [@Malik](https://forum.adalo.com/u/Malik)\ **Post date:** [February 2, 2021, 7:21pm UTC](https://forum.adalo.com/t/filtering-xano-results/8688/1 "2021-02-02T19:21:54Z")
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. ![list filter xano](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/e/ebb15a13c56e982a9fc66c5364fdcfb06af2467e.png) @xano please help. Thanks. ---
**Author:** ![rickman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rickman/32/555_2.png) [@rickman](https://forum.adalo.com/u/rickman)\ **Post date:** [February 3, 2021, 1:50am UTC](https://forum.adalo.com/t/filtering-xano-results/8688/2 "2021-02-03T01:50:23Z")
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? ---
**Author:** ![Malik](https://avatars.discourse-cdn.com/v4/letter/m/e36b37/32.png) [@Malik](https://forum.adalo.com/u/Malik)\ **Post date:** [February 3, 2021, 2:37am UTC](https://forum.adalo.com/t/filtering-xano-results/8688/3 "2021-02-03T02:37:51Z")
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. ---
**Author:** ![rickman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rickman/32/555_2.png) [@rickman](https://forum.adalo.com/u/rickman)\ **Post date:** [February 3, 2021, 2:55am UTC](https://forum.adalo.com/t/filtering-xano-results/8688/4 "2021-02-03T02:55:41Z")
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. ---
**Author:** ![Malik](https://avatars.discourse-cdn.com/v4/letter/m/e36b37/32.png) [@Malik](https://forum.adalo.com/u/Malik)\ **Post date:** [February 3, 2021, 10:04am UTC](https://forum.adalo.com/t/filtering-xano-results/8688/5 "2021-02-03T10:04:48Z")
Thank you @rickman I will try it. ---
**Author:** ![xano](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/xano/32/6106_2.png) [@xano](https://forum.adalo.com/u/xano)\ **Post date:** [February 3, 2021, 4:29pm UTC](https://forum.adalo.com/t/filtering-xano-results/8688/6 "2021-02-03T16:29:17Z")
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! ---
**Author:** ![kaan](https://avatars.discourse-cdn.com/v4/letter/k/b9bd4f/32.png) [@kaan](https://forum.adalo.com/u/kaan)\ **Post date:** [April 23, 2022, 12:30pm UTC](https://forum.adalo.com/t/filtering-xano-results/8688/7 "2022-04-23T12:30:25Z")
My tip for this to work 🙂 When you define the query parameters in the authorization section in Adalo leave it blank. I mean do not create a query parameter there. You need to select a default value for the query parameter in Xano since without a default value the collection won’t return results and without a result you can not save it in Adalo. ---
**Author:** ![pablob8](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@pablob8](https://forum.adalo.com/u/pablob8)\ **Post date:** [November 14, 2022, 5:52pm UTC](https://forum.adalo.com/t/filtering-xano-results/8688/8 "2022-11-14T17:52:25Z")
But then wouldn’t the external collection wizard also fail if you provide no parameter? I thought you needed to provide a test value so that it can pull up all the attributes on the external table. I am having a ton of issues on this. @xano can you provide more clarity on how to do this? Something as simple as just filtering by user is taking me hours to figure out