I am just an unusual guy, what can I say . (I really need to elaborate more on my end when posting questions on here, sorry).
The fail safe indeed works.
What I am doing is basically the following:
Broken down to an abstract level without context:
- First I want to check if a condition is met. When it is met, the query should explicitly search for certain rows. (Obviously there are several different conditions above the last 'fallback group', but this is only my doing of things. It could also just be any other condition you come up with).
- If no condition is ever met, no query data should be given out -> Thats why it searches for "none" in the last AND Group. None is not existent at all in any table. That is why it cannot give out any data (without this last 'fallback group" the query would just give out every row of the table I have chosen in the 'Columns'-tab of the query builder as stated in this topic: How to ensure Database Query does not return all records if condition is not met?). With this I wanted to prevent creating an own condition step in the server connect editor itself as stated here: How to ensure Database Query does not return all records if condition is not met? - #11 by Teodor, this would've been too much of an eye sore for me creating an own query for every condition I want to be met.
My problem: I basically just want to know if this type of way is safe. Only based on this picture. Is there any thinkable way (IN THIS QUERY) a user still could get access to the rest of the rows or should I rather go the way Teodor mentioned in his post linked above?
Context (if needed):
I have a dropdown menu which is being populated if certain conditions (boolean true/false from a table in the database) are met by the user. If he doesn't match those conditions, I want to just make sure with this last group in the query that the user won't get access to certain options he should not have access to. Hence why it is always being run, there is no condition for it.