Conditional query with a list inside the table.

Jonas Robertsson

I have a table with price_lists, and a list of user_ids on each row in that table to check what price_lists the user have access to.
{
"pricelist_name": "test 1"
"users":[2,3,4]
},
{
"pricelist_name": "test 2"
"users":[2,4]
},
{
"pricelist_name": "test 3"
"users":[4]
}How would i return only the pricelists that a user have access to in Xano.

Using custom query but don't really know how to check inside a list, auth:id == price_list.user_list.id, wont do it.

Ray Deck

If I understand your issue correctly, the key to this is the "in" operator when applying a query filter, and making sure you have the right things on each side. Here's a video walking through the process.  https://www.loom.com/share/63ed7052a42c42c08b03455d30cbbb00 

Jonas Robertsson

 Thanks. 👍