Databases Reference
In-Depth Information
LIKE
= SQL 'like' operator
•
•
N
= null
NN
= not null
•
C
= contains
•
•
NC
= not contains
IN
= SQL 'in' Operator
•
NIN
= SQL 'not in' Operator
•
When calling a page and passing in a filter, you need to consider that the user may have already
customized the report they are landing on (e.g., they may have filters applied, columns hidden, or be
displaying the third page of results, etc.). If you want them to land on the report and ensure that the data
you want displayed is displayed, you use one or more of the following options in the Clear Cache
segment of the URL:
RP
: Resets pagination
•
•
RIR
: Resets the report to the primary default report or default settings (just like
using Actions > Reset)
CIR
: Keeps the columns that are currently selected and clears all report settings
including filter, highlight, control breaks, etc.
•
If the primary default report contains a filter or other report setting that you want to clear, use both
RIR
and
CIR
, separated by a comma. If there are no special settings in the default or if you want to
maintain the settings (e.g., keep in place displaying just the last seven days of data along with the new
filter you are passing) just use
RIR
. In my example, I am displaying the count of reviews and then linking
to the reviews page. I will use both
RIR
and
CIR
to ensure that the users get the same number of records
in the report as was displayed in the count.
If there are items on the page you are calling that are used within the query, it may also be
appropriate to clear the session state for that page. That would be accomplished by passing the page
number in Clear Cache, along with
RIR,CIR
(depicted in Figure 13-7).
