Data provider filter via a custom query

[Mozix]

Hey,

How can i filter my table that comes from a custom query?

Let's say I have a page1 when I choose an option from the table in page1, I wanna filter the data in page2 based on my choice in page1 how can I approach this with custom queries?

Thanks!

[ConorWebb96]

Hey @Mozix,

It sounds like you want to persist a value through state. Then use this saved value as the binding of your query on the second page. I've linked the documentation above for persisting/state in general.

I'm assuming from what you've written that you already know how to create a binding for a custom query. All thats left is to save the second value to state with persist checked whenever a row is clicked. Then reference the created state in your data provider settings cog, custom query area of the second page and you should be able to see the results of the second query.

If you need an example after this explanation, let me know and I'll do one up for you.

I hope this explanation helps.

[Mozix]

Hey @ConorWebb96

I have managed to create the state but I am stuck at updating the query part I don't seem to get that part so an example would be amazing!

Thank you again!

[ConorWebb96]

Hey @Mozix,

Sorry for the delay on responding to this one. Below are the steps I used to create a few simple exmaple.

1. Created a query in my case called Pet Type.
2. Simple select from the pets table to get the type of animal.

3. Created 2 pages one for the entire pets table and the other for queries results. 4. Added a create state action to a table based on the clicked row. Saved the type to state from the clicked row. 5. Referenced the persisted state inside the query settings area of the data provider within the table block.

End result

I hope this helps.

[cl-provecto]

Would you help me? Using this same example, how would I use a field for Date