Hi all
At our company - we're working on initial project to implement APEX interactive reports. The rendered reports can be rather large so we've been asked to filter the report first before rendering to the user.
In terms of pre filtering, we might have both required and non required filters. Example of a required filter could be branch or location. Example of non required filter could be product. Likewise, we could also have non required "ranges" such as begin and end dates. Once the result set is returned - the user can then filter, group, sort etc on the result set etc.
Questions- in terms of good design/best practices.
1. For the pre filtering, when dealing with a required field the query could just look like
AND ol.branch = :p1_branch
2. For the pre filtering, when dealing with a NON required field - I'm not sure of the best approach
Could I do a range for ALL filters ???
Note: the user doesnt necessarly seen the range unless a true range is necessary such as date.
Case 1 - user enters a value.
We set :P1_ITEM_NUMBER_BEGIN and :P1_ITEM_NUMBER_END to that value entered.
The query could look like
AND ol.ordered_item BETWEEN :P1_ITEM_NUMBER_BEGIN AND <= :P1_ITEM_NUMBER_END
2A. Case 2 - user DOESNT enter a value.
In Oracle - is there a way to assign "low values" to P1_ITEM_NUMBER_BEGIN AND "high values" to P1_ITEM_NUMBER_END ----THUS indicating ALL.
Any feedback/options/opinions would be greatly appreciated.
Thanks
Mike