add "ALL" to a dynamic LOV?
I want to add "ALL" to a dynamic LOV for users to select all values. I know I can do it by using some SQL SELECT command such as SELECT NAME='ALL' UNION NAME FROM TABLE.
But what should I do to ensure ALL is always up on the top of the LOV? In CR, LOV is alwasy sorted ascendently or descendent so I will have to go and search in the list when I want to select 'ALL'. If 'ALL' cannot be the first in a sorted list, can I at least make 'ALL' as default in a dynamic LOV? Thanks.
1. If you want your LOV on the top of the values you can do one thing
Just add ...All (Just add ...) in front of the All; it will be always on the top.
2. You can't make the Dynamic LOV for some default value.
Hope this helps.