How do I default a multi-select to have all values selected
MartinFAug 13 2008 — edited Aug 13 2008Hi all,
I have a report (standard, not interactive - for various reasons) and I have a number of 'search' fields that the use can use to fulter the results shown. One of these fields is a multi-select list which allows the users to select multiple values at the same time. This is working fine.
My problem is in setting the default for the multi-select list to have all values selected (either when the page is first opened or when the user clicks a 'reset' button).
The multi-select query is:
select
lv1.description d, lv1.lookup_code r
from
tpa_adm_lookup_types lt1,
tpa_adm_lookup_values lv1
where
lv1.lookup_type_id = lt1.lookup_type_id
and lt1.lookup_type = 'RELEASE_PHASES'
and lv1.delete_flag = 'N'
order by 1
how do I get it to default to everything selected?
Many thanks,
Martin