I have an interactive report on page 30. Above it, I have a Page Item: P30_TEXT which a user enters and I use to filter a large table: HARDWARE by using a context search.
select col1, col2
where contains(searchcol,:P30_TEXT) > 0
Users can then filter/customize the page as they see fit using the IR controls.
However, when they save the report, the value of :P30_TEXT does not get saved along with it.
Is there a way to allow for this functionality to happen?
I imagine I would have to change the query to something like: