On any list view page, select the Dataspy to edit from the
drop-down list on the filter bar, and then click
Edit.
Click
Advanced from the
left-hand column of the Dataspy editor.
Where Clause—Enter an
additional Where clause as necessary. The Where clause is appended to the Where
clause generated by the Dataspy Filter. The Where clause will be appended with
an "AND" statement if a Filter has been specified.
Click
Test Where Clause. If
the SQL statement compiles without error, the system displays a confirmation
message.
Note: Click
Display SQL Statement
to view the entire SQL statement. The
SQL Statement
field is read-only.