I have a select list (P147_EVENT_TYPE) with only two values, defined as:
Static: Hurricane;HURRICANE, River;RIVER
The select list filters out a report. User selects 'River', they see all river events in the report. A user selects 'Hurricane', they see all river events in the report.
I wanted to make changes so that there would be an option to see 'All Event Types'. So inside the item, I changed:
Display Null Values --> Yes
Null Display Value --> All Event Types
Null Return Value --> left it blank
The actual report query is along the lines of:
Select name, type
where ( (P147_EVENT_TYPE ='Hurricane' or P147_EVENT_TYPE = 'River')
or P147_EVENT_TYPE is NULL)
Normally upon coming to the page that the report is on, the select list should show 'All Event Types' and the report should be of both hurricane and river events. However, when I get to the report the select list (P147_EVENT_TYPE) is displayed to 'River'. It has the three choices in there (River, Hurricane, & All Event Types), however, if I select 'All Event Types' in the select list, it just reverts back to River. Is there any way to change this? Can I not use a static select list with a default value type? Any help on this would be great. Thanks in advance for your help.
I tried setting up a page as you describe and it's fine. Is your example on apex.oracle.com?
It sounds like something simple. If it's not on apex.oracle.com then as a quick test, I'd suggest copying your page to a new page within the same application, deleting p147_event_type and recreating it with a slightly different name.
No problem, glad it's solved.
Here's a quick tip that might be useful:
I'm no expert but when I began APEX I found it's sometimes quicker to start a page again, or copy it to another page and take bits out until you solve a problem, than to get into a rut fixing a page or looking for the fault.
It can be easy to spend hours trying to find the cause of a problem when the page could be recreated from scratch in much less time. It's worth keeping that option in mind if you think a problem is starting to get out of hand.