index

This term has multiple uses:

• An index is a PegaRULES database feature that provides faster access and improved database performance. Use Declare Index rules to add and delete index objects.
• An index is a value that identifies one element (sometimes called a member) of an aggregate data structure such. Indexes are also sometimes called subscripts.
• An index file is a CFG file type created to support full-text searching in the Designer Studio Search facility and for work item searches in application portals
• The PegaRULES database uses SQL indexes to achieve good performance.

Numeric indexes for lists

For properties of mode Value List or Page List, the index values are numeric and start with 1, not 0 as in Java. For example, you can identify an element of a Value List property Budget() using any of the following formats:

.Budget(7)
.Budget("4")
.Budget (.RowNumber)

(where RowNumber is an integer property).

Identifier subscripts for groups

For properties of mode Value Group or Page Group, subscripts values are strings (that must be a valid Java identifier, starting with a letter). For example, you can identify an element of Value Group properties using:

Population("CA")
Population(.StateCode)
PurchaseOrderRow("Quantity")

and so on. These subscripts have no natural order defined.

Symbolic indexes

In certain situations, you can use keywords such as <CURRENT>. <APPEND>, or <LAST> as index values to identify an element within an aggregate property.

Full-Text Search index files

Files on the server known as index files support the full-text search feature of the Search tool. These have a CFG file type. They are not related to Index- objects or database indexes.

Related terms

Open topic with navigation