You have one too many semi-colons in your link, and no data specified
And try avoid using &VALUE. in SQL. Application ID not so bad, but never for session ID - you'll flood your sql pool (is there a pun there?).
I use a mnemonic to help me remember
Thanks for the response. I made the modification however still had the issue. I was linking to a general report with a structure such as:
- select col1, col2 from tab
when I added the "where" clause that resolved the issue.
My app still has a need for the general report on "tab" (ie select col1, col2 from tab). Is the Apex practice in this case to create 2 pages - one general and one for the drill down report?
Is there a way to have one report/page and have the "where" clause not used if entering via a drill down chart? Hope that make sense...
Passing information via the parameter is only half the job, as you discovered you need to add a where clause to limit the rows.
If you want to return full results if the value is not provided, one option is to use a where clause like:
where mycol = coalesce(:P1_PARAM, mycol)
That line saved quite a bit of work, thanks worked well. Although it seems the hidden value P1_PARAM is active in my session state, how can I set it up so that the variable is not persistent for more than the one page event?
Clicking through the chart to the report (reportA) works as expected - data is filtered based on where clause.
Then I access another random page (Home)
Then go back to the reportA page directly, but not via the chart, and the data is still filtered via my last hidden value.
I probably wasn't clear enough in my description. I'd like to clear the value cache after linking to the page. I found the following similar example with a complex solution. Are their better ways to do this as this post is ~4 years old?
Sounds ok - you may also consider a dynamic action on page load, depending on the timing you're after.
What's your drive for clearing the session state so early?
The reasoning is that I only want the data filtered if the user clicks though the chart. If they access via another link the data should not be filtered.
Each time I access the page it shows only data based on the hidden_value. That value is present for my session. If I close the session and reopen the browser and the value is null access the page works as expected.
Ideally I'd like to clear the hidden_value as I leave the page.
I noticed in some of the packaged applications Oracle added a "Reset Report" button. Is that their solution to the problem?