Central and ActiveVOS Screenflow

9.2.4.6
- 9.2.5

Back Next

Show List: Advanced Query

Selecting Advanced Query
lets you finely tune the information retrieved for the list.

After the query executes, the default action is to return a list whose values are object IDs; the list also has the name field for display.

The source for each of the query's four parameters can be Content, Field, Formula, or Screen. In almost all cases, the source is Content. The items that you can set are follows:

Object Type
: The object type upon which the query executes.

Where Clause
: Enter an SQL WHERE clause. The text you enter here does not include the WHERE keyword. Here, Content means you will write the WHERE clause, Field means that the field contains the WHERE clause, etc.

Display Field:
Set a value here to return a field other than the current one. Process Designer will retrieve this data, and then display it within a picklist. If you do not specify a field, Process Designer uses the namefield
(the first one, if there is more than one).

Value Field
: Returns a different value than what Process Designer would use by default. If you do not set a value field, the ID of the returned object is used.

Advanced Technique
: You could use an advanced query to create a step that displays the query's results within a step. You might want to do this in a different "testing" guide.

Rename Saved Search

Table of Contents

Central and ActiveVOS Screenflow

Central and ActiveVOS Screenflow

Show List: Advanced Query

Show List: Advanced Query