Ratan Balaji (Ratan)
Associate Architect
Ratan Member since 2015 60 posts
Posted: May 29, 2017
Last activity: June 19, 2017
Posted: 29 May 2017 3:20 EDT
Last activity: 19 Jun 2017 8:06 EDT

Search using custom fields

Assume that we have a test activity in which we have created a custom field property, say "Defect ID" and the value is given as 1001. Once the activity is created, we will get an entry in the pr_index_customfields table. But on running the search with custom fields wizard,

Designer Studio --> Process & Rules --> tools --> Search rule using custom fields

In the "Set filters" screen initially i was not getting "Defect ID" property. I was not able to expose the property since Index-CustomFields is a rule in Pega-Rules ruleset which us locked. I had to expose the column manually in the DB. I altered the table pr_index_customfields to include a column "defectID" varchar(n).

After manually exposing the column, i created a when rule. This time i got an entry in pr_index_customfields table. I was also getting the property in the "Set filters" section. But the column "defectid" is not having any value because of which the final auto generated list view is not giving any result.

1) Is there a simple / conventional way to expose the properties that we use as custom fields?

2) Am sure that the data is in the blob in pr_index_customfields table. How to make sure pega inserts the value in the exposed column as well?

Thanks in advance.

Low-Code App Development Data Integration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.