Question

9
Replies
2795
Views
TSUCK Member since 2010 125 posts
PEGA
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed
Solved

Unable to expose a column in Data-Admin-Operator-ID class (PR_OPERATORS table)

Hi,

Organization has their own Org structure, and most of the times PRPC data structure (Org>Div>Unit) is not sufficient. I assume there are lots of use cases that developer wants to extend Data-Admin-Operator-ID class to have custom organization properties. Let's say, we have a class MyCo-MyApp-Data-Department that have information about the organization.

MyCo-MyApp-Data-Department

- DEPTID (Identifier)

- DEPTNAME

Now I want to have OperatorID instance to possess this data as this is critical element in this organization. Simply I have created a Single Page property which points to this MyCo-MyApp-Data-Department and now I can populate this data in my application. From clipboard this data is available in OperatorID page.

Since this property is very important and I want to use this in many Security implementation (ex. ARO), I need to expose this field. I know this class is out-of-the-box and not advisable to alter much, but I have to. Right-clicking to optimize this property in App explorer fails and PRPC shows an error message as below.

I believe there should be still a way, and this PDN article below also says "Create the columns manually for these properties" as resolution.

https://pdn.pega.com/support-articles/unable-perform-property-optimization

So I have done ALTER TABLE ADD COLUMN from Database directly and exposed this field. Having different names between database and PRPC was ideal, but since External Class Mapping is not possible because this Class is not editable (locked, and Class is not overridable), I guess we can't have different names.

I can give up having different names but can't give up exposing itself. So I have exposed this database column as DEPTID and also made the PRPC property name the same (DEPTID). In my understanding, as long as the property name and database name are exactly identical, PRPC automatically sees them both as the same thing (Correct me if I am wrong here). Now, I have resaved Data-Admin-DB-Table instance of Data-Admin-Operator-ID class and tried saving this Department ID data in OperatorID but it does not populate database column. I tried rebooting application server but the result was the same.

What is the proper way to expose a column for above scenario?

Thanks,

Data Integration
Moderation Team has archived post
Share this page LinkedIn