LinkedIn
Copied!

Table of Contents

Creating dedicated indexes

Version:

Only available versions of this content are shown in the dropdown

Dedicated indexes are property type-aware, per-class indexes that return the data type of each returned property. Default indexes are typeless, that is, all properties are of type string. Dedicated indexes let you execute queries with filters, date calculations, and aggregations directly in the query. Dedicated indexes are displayed on the Search landing page in the Dedicated indexes section.

To access the Search landing page, you must have the pxAccessSearchLP privilege, which is included in the PegaRULES:SysAdm4 role.
  1. In the header of Dev Studio, click Configure System Settings Search .

  2. In the Security section, click Customize full text search.

  3. Select the For specified properties check box. You cannot create a dedicated index if this check box is not selected.

  4. In the navigation panel, click Records SysAdmin Custom Search Properties .

  5. Double-click the custom search property instance that you want to use as a dedicated index.

  6. Select the Use dedicated index check box.

    After you create the dedicated index, you cannot clear Use dedicated index. You must delete the index on the Search landing page.
  7. Optional:

    In the Disable data types for dedicated index column, select the check box for any properties that you want to be returned as string. You cannot filter or aggregate these fields based on their actual data type.

  8. Click Save.

  9. Click Create dedicated index to create a dedicated index for this class.

    The message "Currently using index <index>" is displayed under the Use dedicated index field along with the status of the index.
  • Dedicated search indexes

    Dedicated search indexes are property type-aware, per-class indexes that return the data type of each returned property. Default indexes are typeless, that is, all properties are of type string. Dedicated indexes let you execute queries with filters, date calculations, and aggregations directly in the query.

  • Deleting dedicated indexes

    You can delete dedicated indexes when you no longer need them. When you delete a class&rsquo;s dedicated index, the instances of the class are indexed in the relevant typeless index ( Work- or Data- ). When you delete a class&rsquo;s custom properties search instance, the instances of the class are indexed in the parent class&rsquo;s dedicated index.

  • Resolving data type conflicts in dedicated indexes

    A data type conflict occurs when a dedicated index contains two fields with the same name that are of different data types. When a data type conflict occurs the status of the dedicated index changes to CONFLICTS FOUND on the Search landing page and in the Custom Search Properties page for that class. Click on Check Conflicts on the Custom Search Properties page to view the properties that are in conflict.


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.