In-memory join
Is there any out of box feature where we can perform an in-memory join?
For example:
I have a set of web services which provide raw data and data types back to pega in key-value form, such as <someKey>1234</someKey>. The key value has a UI label in a separate reference data page, such that 1234 = "my field description"
The way for us to display the description is essentially to loop through the reference data page, for each key, to identify the description.
Had the service data been part of the same database, then it would be very easy to perform a join to get this info. However, if two sources are externalized, we have to iterate for each key to get the proper label.
What i'm looking for is the ability to, connect 2 pages based on key.
SourcePage
.pxResults()
.someProperty = 1234
RefPage
.pxResults()
.key = 1234
Is there any out of box feature where we can perform an in-memory join?
For example:
I have a set of web services which provide raw data and data types back to pega in key-value form, such as <someKey>1234</someKey>. The key value has a UI label in a separate reference data page, such that 1234 = "my field description"
The way for us to display the description is essentially to loop through the reference data page, for each key, to identify the description.
Had the service data been part of the same database, then it would be very easy to perform a join to get this info. However, if two sources are externalized, we have to iterate for each key to get the proper label.
What i'm looking for is the ability to, connect 2 pages based on key.
SourcePage
.pxResults()
.someProperty = 1234
RefPage
.pxResults()
.key = 1234
.desc = "my Label"
and have, possibly a resulting page, if 2 pages joined on .someProperty = .key
JoinedPage
.pxResults()
.someProperty = 1234
.key=1234
.desc = "my Label"
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
IN
HI
Kindly let me know the Applies-To class of the SourcePage.pxResults and Applies-To class of the RefPage.pxResults
Pegasystems Inc.
US
Hello,
I don't think there is an out of the box feature to do the join for you. You could probably iterate through once and turn them into double linked lists, where you add a property to each that is the index of the other page. That way, you don't need to walk through each time you want to reference things on both pages.
Of course that assumes the data pages aren't read only. If they are, you could create a third list that contains the keys to both, but that is a little less elegant.
Thanks,
Mike
Pegasystems
US
I have to admit, I don't understand this question. Can you maybe show some short sample contents of the .pxResults list contents and what you are expecting to get as output?
Are you trying to do some kind of merge of two .pxResults list into one?
MSG Systems
DE
From what i could understand from this question i feel we can use Property-Ref
Some Sources
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm