Table of Contents

Search

  1. Preface
  2. Understanding Data Types and Field Properties
  3. Designing Processes
  4. Using and Displaying Data
  5. Designing Guides
  6. Designing Process Objects
  7. Designing Service Connectors
  8. Using Connectors
  9. System Services, Listeners and Connectors

2. Design

2. Design

Show List: Advanced Query

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.


Updated February 11, 2021