Listing All Audit Records Containing an Invalid OPRID

This query is similar to the previous one. In this case, when you edit the criteria properties, you use an expression with the condition "not in list," and define a subquery to compare the OPRID.

This example illustrates an expression on the Edit Criteria Properties page that uses a subquery.

Click the Define/Edit Subquery link and select the OPRID field.

This example illustrates the Fields page when defining a subquery for AUDIT_OPRID.

The subquery selects distinct User ID from PSOPRDEFN.