c# - Query filter design for string field -
In my table, a field can have unchecked strings on the UI,
All, Value1, Value2
have drop down and the results were filtered by the selected option values. So far it is easy and adding new filters to the UI is not a problem. No changes are required in my stored procedure. Now I have to create an "other" option, which does not hold values as value 1 or value 2.
Apparently this will require a "not in" operator in my query, and will make maintenance difficult, because the list of prices is likely to change
Any suggestions, Design Tips?
If your option table can contain a different column called IsOther, then your query will Instead of using one no, WHOEOOther = 1 may be.
Comments
Post a Comment