Obj-Browse method

Parameter

Description

Enter the name of the destination page to contain search results. The system uses Code-Pega-List as the class of this page.

Identify a class to search. You can search one concrete class, or all classes in a class group. Within the PegaRULES database, the class can correspond to a database table or to a database view.

Optional. Enter the maximum number of instances you want returned in the list at runtime. If left blank, the default value is 10,000.

As a best practice, specify a MaxRecords value to reduce the demand for database activity memory. If necessary, your activity can test the property pxMore on the results page to see whether additional rows were not returned because the MaxRecords limit was reached.

Select to include the primary key in the set of property values returned. Clear to exclude the primary key. (Selected by default.)

This field is required if GetRowKey, above, is selected. Otherwise, leave blank unless the class in the ObjClass parameter corresponds to an external table.

Enter the name of a property in the external table, or an expression involving one or more property names, that specifies the unique key of rows of the external table.

Select to have the embedded pages for the selected instances use lightweight lists for better performance. Leave unselected if the activity performs operations unsupported by lightweight lists, like forward chaining declarative processing, messaging, or value vetting. Refer to the PDN article About lightweight lists for more information.

As a best practice, select this checkbox. This can reduce memory requirements during processing.

Having the embedded pages use lightweight lists does not affect your ability to remove an embedded page completely (with the Obj-Filter or Page-Remove method).

Two dynamic system settings control the use of lightweight lists by the Obj-Browse method. There is a setting each for PRPC and application rules:

• clipboard/lightWeightList/enableForCorePRPCRules - this is set to true by default.
• clipboard/lightWeightList/enableForCustomerRules - this is set to false by default.

When true, these dynamic system settings override the Use Lightweight List checkbox setting on the Activity rule form.

Optional. Enter a boolean statement that defines how the rows of the parameter array are to be combined. Identify rows by the Label field. You can use the operators AND and OR in this statement, and parentheses for grouping.

For example, A AND (B OR C OR (E AND F)).

If you leave this blank, the system assumes the AND operation applies to all rows of the array.

Optional. Complete one or more rows of this array to define the selection criteria and the properties to be returned. If you leave this array blank, all rows (and all columns including the pzPVStream column) are selected, up to the MaxRecords limit.

For an external class, complete at least one row of the array.

Enter a unique letter or identifier for this row, referenced in the Logic field.

Select to return the value of this property on each embedded page. In the resulting SQL statement at runtime, this property is listed in the SELECT list (as well as the WHERE condition).

Enter a property reference. You can specify a Single Value property, a list or group property, or individual elements of a list or group property.

You can return any property — exposed as a column or not — in the results by setting the Condition field to Value Only. However, only Single Value properties exposed as database columns can be used as selection criteria.

Click to open the property. Do not use .

To restrict the search to specific values of a property, enter a property reference that is exposed as a database column. You can review the database schema to determine which properties are exposed for a class. Consult your database administrator for information on the current database schema, or use the Modify Schema facility. See How to expose a property as a database column.

Select a comparison, such as Is Equal or Is Less Than.

• Select Value Only if the search results are to include the property value, but the property value is not to be used as a selection criterion.
• Select Is Null to require that the field a have null value.
• Select Is Not Null to require that the field have a value.

Enter a constant value, a property reference or other expression for the comparison. Leave blank if the Condition is Value Only, Is Null, Is Not Null, Is True or Is False.

Click to open a property. Click to start the Expression Builder.

• If you enter an expression involving function rules, Java, and properties on various clipboard pages, then at runtime the expression is evaluated only once.
• If you enter a property (that is exposed as a column) that applies to the ObjClass class, the Value value is evaluated for each row.

For example, if the Field field contains a DateTime property ExpireDateTime, the Condition is IS GREATER THAN, and the Value field contains a function computing the current date and time, the function is evaluated only once, not once per row.

Note that the second value in the comparison refers to a property on the current clipboard page, or a hard-coded value, not to a value in the database record.

Select No Sorting, Ascending, or Descending to control the sorting of results by this field. (Sorting occurs through database software, on the database server.)

If the Condition is Value Only or Is Null, select No Sorting.