5 ms·
Have you considered that "filter_region" will itself not be know in advance? So if there are 12 attributes that I can filter with, how do you propose to generat
by brainless 5y ago
Have you considered that "filter_region" will itself not be know in advance? So if there are 12 attributes that I can filter with, how do you propose to generate any combination of them with SQL?
- taffer 5y agoYes, filter_region, filter_supplier and order_column are parameters. The filter parameters are combined using AND, or if they are NULL, they are ignored. For example, you could set filter_region = 'Oceania' and filter_supplier = 'Acme Corporation' or any combination of them.