I would like to ask if there are any implications or issues if I have 2 Database Query of the same name in an Action File, please see below for an example:
The reason why I have created 2 queries of the same name is because I have a filter on my page using a select input that will allow users to filter the table using a Boolean table field. We can query SQL with that field for only 2 values, true or false (or 1 or 0). I would like to allow the users to filter the table to get all records with true or false or both.
I have created one database query initially and tied that up with a bootstrap table. After I copied the same table I checked again the bootstrap table generator and it can still see only 1 query. It is working so far.
Both Database Query have the same query except for the Conditions.
Is it okay to do it this way?
Will it not create an issue in the future?
Are there any other workarounds (on which I can query a Boolean field for a true or false or both)?
Attached is the json file for my Acton File.
employees.zip (1.7 KB)
Thank you in advance.