Filtering record query through json table content

Lukasz Kwiatkowski

It seems like Xano does not "see" json content e.g. a column named Summary storing the following json:
{'type': 'swim','time': 1800}, cannot be filtered by e.g. Summary.type equals swim
Is is a matter of syntax or currently not possible?
An obvious solution is to fetch data for filtering params in a separate column but this does not seems very scalable hence my questions if I can filter with json directly.

Ray Deck

I made this video to answer a similar question - does it help?: https://www.loom.com/share/335e6fe4e5b6438ba5d63b925346c35e

Lukasz Kwiatkowski

thanks Ray yeah that's helpful, however I want to use Xano pagination directly on the frontend and besides I don't wanna front all the data first, it is a huge data set so I actually want to filter it on the query level

Ray Deck

Got it! Maybe  has an idea for you? 

Michael Udinski

 - you should be able to filter directly on the JSON. JSON fields don't have defined schema within it, but you can still use dot notation on it. Make sure to start with selecting DB table name and field name. Then you can add dot notation for the nested field within the JSON data type

Ray Deck

 is absolutely correct. I made a video to demo this particular use case that you might find helpful,  https://www.loom.com/share/945e7387ec70429490dd999452077928