Generating the Query

When you select a worklist, a search query is automatically generated by the system for each worklist record in the worklist. The query is named PTWL_<worklist record name> and PSWORKLIST, PTWL_PORTAL_VW and the worklist record. The query includes the following:

• All of the fields from the worklist record.

• Last Updated record field. (LASTUPDDTTM)

• Operator ID record field (OPRID)

• Message Node Name (MSGNODENAME)

• URI Text (URI_TEXT)

• Portal Name (PORTAL_NAME).

• Drilling URL.

• Prompt against the Last Updated field.

• Criteria for the Last Updated field.

The system also adds the application records to the access group WORKLIST_FILTER, which is specific to Worklist Search. This access group is used at runtime.

To view the generated query, click the Search Definition button and then select View.