Process to configure pending task views

Define the query in the Query form. Here is the syntax for a SQL database.

Notice the JOIN statement. IN is not included in the WHERE statement so that more than 1000 tasks can be returned.

Here is the syntax for an Oracle database.