New field for filters, but only in certain conditions
Starting from a pre-existing app, I need to add a new filter, that only applies when certain conditions are met. The conditions go thorugh different tables.
Which do you consider is the best way to consider this.
A - load a table considering this
B - create de conditions in the app through various Ifs
The correct response would be "it depends". You will have to consider the benefits from simpler expressions against more complexity in the script/data model.
You could also consider a combination where you add some logic in the script using flags and create a lesser complex expression utilizing these flags.
You could also consider if set analysis could be an option.
