Question
Accenture Solutions Private Limited
IN
Last activity: 24 Apr 2020 15:49 EDT
Display all the portals of an access group
pyUserPortals is page list property and this holds pyPortalLayout property which displays portal names.
Report is created in Data-Admin-Operator-AccessGroup class
Report should display all the portals of an Access Group.
Used Declare index to achieve this.
I have created a index class Index-AccessGroupPortals.
Index-AccessGroupPortals points to pr_index_accessgroupportals table and the column pyPortalLayout has been added to this table.
I am not able to create pyPortalLayout property in Index-AccessGroupPortals since the property name starts with py.
Please help me with your thoughts.
Thanks in advance.
***Edited by Moderator: Pallavi to update platform capability tags***
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
You can create another property say "PortalLayout" in Index-AccessGroupPortals and use it in Declare Index and expose that property.
Updated: 22 Apr 2020 12:24 EDT
P3Fusion
IN
Hi @kanap2,
I had the same requirement, Thanks for the idea. Unfortunately, i was using Pega 7.1.X version where i can't find the property optimization option.
Can you please elaborate steps to expose a column in a table without using proeprtyoptimization.
Ideas are welcomed :)
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Could you please try using Modify schema wizard.
Please find the below article which might be helpful.
Updated: 23 Apr 2020 3:14 EDT
P3Fusion
IN
Hi @kanap2,
I had the same requirement, Thanks for the idea. Unfortunately, i was using Pega 7.1.X version where i can't find the property optimization option.
Can you please elaborate steps to expose a column in a table without using proeprtyoptimization.
Ideas are welcomed :)
Pegasystems Inc.
US
You should be able to do property optimization in 7.1.x. is a link to 7.1.6 help file:
Pegasystems Inc.
US
Also, there may be a dynamic system setting that governs whether the property optimization tool is available. In 8.x it is:
database/AutoDBSchemaChanges (set to true)
I suspect it is the same in 7.x releases.