Get sql query from filter search?
|#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|
You must be logged in to reply to this thread.