Jacky Yap (yapj1)
Sr. System Architect
Pegasystems Inc.
yapj1 Member since 2015 32 posts
Posted: November 22, 2018
Last activity: November 30, 2018
Posted: 22 Nov 2018 7:40 EST
Last activity: 30 Nov 2018 8:19 EST

Using Declared Index Table for a different class or as a class join

I need to be able to use the records in a Declared-Index table as either an index join or class join, obviously, Pega is preventing such usage.

The scenario is as follows:
I have a Pagelist within a Work- class that indicate who have access to this case, this is dynamic and selected and changed anytime the user desired.

A DI is created to flatten this into a corresponding table.

In the Assign-Worklist, I want to get a list of workitems that the current user have access to, based on the assignment as well as the Pagelist info (output thru a DI).

However, I am not allowed to do a Index Join to the Assign-Worklist because this is an index belonging to the Work-, not Assign-.

I am also not allowed to use this DI table as a class join to Assign-Worklist, as Pega does not allow me to map the corresponding keys from both tables.

Could anyone advise how I could use the RD to get a list of relevant workitems that a given user has access to based on the Pagelist defined above?

Using row Visibility is an option, but I hope to get the list from RD directly.

I am also trying to avoid RDB related stuff too.

Thanks and looking forward to any advice.


Pega Platform Low-Code App Development Case Management Data Integration
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.