Get sql query from filter search?

Posted in

#1 by ravosu
2021-09-12 at 12:42
< report >Is there a way to get the SQL query string after setting up a complex filter? The filtering config itself works perfectly 99% of the times, but there's no way to filter out announced but not released releases. The only way is to use raw SQL. And reconstructing a complex query from scratch is a pain. (I currently use release date != tba)Last modified on 2021-09-12 at 12:43
#2 by yorhel
2021-09-12 at 12:48
< report >Converting a search query to SQL is not currently possible. I did have the idea to add it, but there's a few differences between the site database and the public one that need to be taken into account.

Doesn't this do what you want?
#3 by ravosu
2021-09-12 at 12:54
< report >it does! sorry for the dumb question, I can't believe I didn't think of that. and it's the default value for the filter.... thank you. I'm a disgrace to all the sysadmins in the world.Last modified on 2021-09-12 at 13:04

Reply

You must be logged in to reply to this thread.