I want to display ‘ALL’ in my list of values so that instead of selecting all values user can directly click on ‘ALL’ and it selects all values in list.
Also,I want to know how does it work,in some posts I read that by typing * or by typing ALL it selects all values.I wanted to know the logic behind this as how it interprets this * or ‘ALL’.
i.e where
Table.Column=@Prompt()
or ‘All’ =@Prompt()
In the above logic if you select any column value the first condition will execute and returns the data based on the selected value. If you select all from the lov’s the second condition will be true and you will get the complete data.