I'm facing exactly the same problem as described in Filtering table with search term passed via urlparams not working - but with MySQL query. I've tried the accepted advice there, but it doesn't work for me at all. Are there any recommendations how to approach this? Thank you!
Great question and I believe I've found a better way about this that ought to work without issue for you.
First, you will want to create a temporary state variable set to null. You will then want to go to 'Settings'>'Page Settings'>'Connect properties on the page to values in the URL' and then set your temporary state variable to the URL hash value that you've defined: