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.
Specify this information:
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.
Note: Click
Display SQL Statement
to view the entire SQL statement. The
SQL Statement
field is read-only.