Creation of a Two-dimensional Grid
Hello,
Is there a way to create a Two-dimensional Grid ? In fact, I need to simulate a matrix in Pega having two dimensions: Rows and Columns as per attached.
How to do that?
Thanks in advance,
Rosy
Accepted Solution
Tata Consultancy Services Limited
GB
Step 1 - Create a section, drag a row repeating layout and Map a page list which contains the dynamic rows. (have only 1 column in this grid)
Step 2 - Create another section, drag a repeating column layout and map a page list which contains the dynamic columns. Place this section in the cell mentioned in step 1.
Updated: 1 Dec 2015 6:11 EST
Tata Consultancy Services Limited
GB
Both rows and columns are dynamic?
Please tell which is dynamic and which is static. We have similar table in our application where rows are dynamic and columns are static like below image.
Thanks!
Guhan
Updated: 1 Dec 2015 7:06 EST
Salame
Hello Guhan,
Both should be dynamic not static. I will have 2 other pages where those dimensions are configured and according to that, this matrix should be displayed.
Thanks a lot for your reactivity,
Rosy
Accepted Solution
Tata Consultancy Services Limited
GB
Step 1 - Create a section, drag a row repeating layout and Map a page list which contains the dynamic rows. (have only 1 column in this grid)
Step 2 - Create another section, drag a repeating column layout and map a page list which contains the dynamic columns. Place this section in the cell mentioned in step 1.
Tata Consultancy Services Limited
GB
i was referring row repeat as Repeating Grid and column repeat as Column Repeat. please see below snap shot.
Salame
Hello Guhan,
i just tried ur suggested solution and I was able to display my matrix... I will work a bit on its look and feel as it is ugly for the moment...
Thanks a million, you made my day!
Rosy
Salame
Hello Guhan,
I just applied above suggested method, but, now, I have misalignment of sections (see below screenshot where section 1 and section 2 are misaligned ) . I tried to fix the size, but, in vain, plus, contents are dynamic; so, I can't expect what it will be filled. I just need a way for the alignment, can you please help ?
Thanks,
Rosy
Tata Consultancy Services Limited
GB
Could you please provide the clipboard structure you used and snapshot of the wrapper section and child sections ??
Salame
Hello Guhan,
I have attached the clipboard xml structure of pyWorkPage used and 2 snapshots of cells (section 2) and column headers (section 1).
I guess if I fixed the width for both (section 1 and 2), it will help, but, I'm having trouble fixing the width of column headers inside column repeat (they are dynamic depending on the content although width = pixels (fixed). )
<?xml version="1.0"?>
<pagedata>
<pxInsName>123456789</pxInsName>
<pyID>S-Dummy</pyID>
<pyRuleHarness>RuleFormLegacy</pyRuleHarness>
<SystemLandscapeID>123456789</SystemLandscapeID>
<AccountID>123456</AccountID>
<pyLabelOld>Dummy Data</pyLabelOld>
<InstanceID>blablabla</InstanceID>
<pxUpdateOpName>Joe Abi Sleiman</pxUpdateOpName>
Hello Guhan,
I have attached the clipboard xml structure of pyWorkPage used and 2 snapshots of cells (section 2) and column headers (section 1).
I guess if I fixed the width for both (section 1 and 2), it will help, but, I'm having trouble fixing the width of column headers inside column repeat (they are dynamic depending on the content although width = pixels (fixed). )
<?xml version="1.0"?>
<pagedata>
<pxInsName>123456789</pxInsName>
<pyID>S-Dummy</pyID>
<pyRuleHarness>RuleFormLegacy</pyRuleHarness>
<SystemLandscapeID>123456789</SystemLandscapeID>
<AccountID>123456</AccountID>
<pyLabelOld>Dummy Data</pyLabelOld>
<InstanceID>blablabla</InstanceID>
<pxUpdateOpName>Joe Abi Sleiman</pxUpdateOpName>
<pxCommitDateTime>20160106T125453.000 GMT</pxCommitDateTime>
<pyLabel>Dummy Data</pyLabel>
<pzIndexCount>52</pzIndexCount>
<pzInsKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzInsKey>
<pxCreateOpName>JABISLEIMAN</pxCreateOpName>
<pxObjClass>MX-MXSFA-Work-SystemLandscape</pxObjClass>
<UpdatedBy>JABISLEIMAN</UpdatedBy>
<pzStatus>valid</pzStatus>
<MRow REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<RID>1</RID>
<pxObjClass>MX-MXSFA-Data-MRow</pxObjClass>
<SubProc>Blotter</SubProc>
<Proc>Order Management</Proc>
<pxTrackingIndex>1</pxTrackingIndex>
<Funct>Front-Office</Funct>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow">36</rowdata>
</pzIndexes>
<MCol REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Prdct>MXG2000</Prdct>
<Cmpt>Calypso</Cmpt>
<Act>CRD</Act>
<BLine>Global Markets</BLine>
<RID>1</RID>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<pxTrackingIndex>1</pxTrackingIndex>
<Dsk>London</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow_MCol">31</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Prdct>MX.3</Prdct>
<Cmpt>Calypso</Cmpt>
<Act>Commodities</Act>
<BLine>Global Markets</BLine>
<RID>1</RID>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<pxTrackingIndex>2</pxTrackingIndex>
<Dsk>New-York</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow_MCol">29</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Prdct>MXG2000</Prdct>
<Cmpt>Calypso</Cmpt>
<Act>Treasury</Act>
<BLine>Treasury</BLine>
<RID>1</RID>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<pxTrackingIndex>3</pxTrackingIndex>
<Dsk>Paris</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow_MCol">30</rowdata>
</pzIndexes>
</rowdata>
</MCol>
</rowdata>
<rowdata REPEATINGINDEX="2">
<RID>2</RID>
<pxObjClass>MX-MXSFA-Data-MRow</pxObjClass>
<SubProc>Cash</SubProc>
<Proc>Settlements</Proc>
<pxTrackingIndex>2</pxTrackingIndex>
<Funct>Operations</Funct>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow">35</rowdata>
</pzIndexes>
<MCol REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Prdct>Product 1</Prdct>
<Cmpt>Competitor 1</Cmpt>
<Act>CRD</Act>
<BLine>Global Markets</BLine>
<RID>2</RID>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<pxTrackingIndex>1</pxTrackingIndex>
<Dsk>London</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow_MCol">33</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Prdct>Product 2</Prdct>
<Cmpt>Competitor 2</Cmpt>
<Act>Commodities</Act>
<BLine>Global Markets</BLine>
<RID>2</RID>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<pxTrackingIndex>2</pxTrackingIndex>
<Dsk>New-York</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow_MCol">34</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Prdct>Product 3</Prdct>
<Cmpt>Competitor 3</Cmpt>
<Act>Treasury</Act>
<BLine>Treasury</BLine>
<RID>2</RID>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<pxTrackingIndex>3</pxTrackingIndex>
<Dsk>Paris</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRow_MCol">32</rowdata>
</pzIndexes>
</rowdata>
</MCol>
</rowdata>
</MRow>
<BLineVL REPEATINGTYPE="PropertyList">
<rowdata REPEATINGINDEX="1">Global Markets</rowdata>
<rowdata REPEATINGINDEX="2">Global Markets</rowdata>
<rowdata REPEATINGINDEX="3">Treasury</rowdata>
<rowdata REPEATINGINDEX="4">Global Markets</rowdata>
<rowdata REPEATINGINDEX="5">Treasury</rowdata>
</BLineVL>
<pyPreviousValues>
<SystemLandscapeID>123456789</SystemLandscapeID>
<AccountID>123456</AccountID>
<InstanceID>blablabla</InstanceID>
<pxObjClass>MX-MXSFA-Work-SystemLandscape</pxObjClass>
<UpdatedBy>JABISLEIMAN</UpdatedBy>
<MRCol REPEATINGTYPE="PageList"/>
<MRow REPEATINGTYPE="PageList"/>
<MCol REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Activity>CRD</Activity>
<Desk>London</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>1</pxTrackingIndex>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Activity>Commodities</Activity>
<Desk>New-York</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>2</pxTrackingIndex>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Activity>Treasury</Activity>
<Desk>Paris</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Treasury</BusinessLine>
<pxTrackingIndex>3</pxTrackingIndex>
</rowdata>
</MCol>
<MatrixRows REPEATINGTYPE="PageList"/>
</pyPreviousValues>
<MRCol REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Prdct>MXG2000</Prdct>
<Cmpt>Calypso</Cmpt>
<Act>CRD</Act>
<BLine>Global Markets</BLine>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<RCID>1</RCID>
<pxTrackingIndex>1</pxTrackingIndex>
<Dsk>London</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRCol">48</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Prdct>MX.3</Prdct>
<Cmpt>Calypso</Cmpt>
<Act>Commodities</Act>
<BLine>Global Markets</BLine>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<RCID>1</RCID>
<pxTrackingIndex>2</pxTrackingIndex>
<Dsk>New-York</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRCol">44</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Prdct>MXG2000</Prdct>
<Cmpt>Calypso</Cmpt>
<Act>Treasury</Act>
<BLine>Treasury</BLine>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<RCID>1</RCID>
<pxTrackingIndex>3</pxTrackingIndex>
<Dsk>Paris</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRCol">47</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="4">
<Prdct>Product 1</Prdct>
<Cmpt>Competitor 1</Cmpt>
<Act>CRD</Act>
<BLine>Global Markets</BLine>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<RCID>2</RCID>
<pxTrackingIndex>4</pxTrackingIndex>
<Dsk>London</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRCol">46</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="5">
<Prdct>Product 2</Prdct>
<Cmpt>Competitor 2</Cmpt>
<Act>Commodities</Act>
<BLine>Global Markets</BLine>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<RCID>2</RCID>
<pxTrackingIndex>5</pxTrackingIndex>
<Dsk>New-York</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRCol">45</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="6">
<Prdct>Product 3</Prdct>
<Cmpt>Competitor 3</Cmpt>
<Act>Treasury</Act>
<BLine>Treasury</BLine>
<pxObjClass>MX-MXSFA-Data-MCol</pxObjClass>
<RCID>2</RCID>
<pxTrackingIndex>6</pxTrackingIndex>
<Dsk>Paris</Dsk>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MRCol">43</rowdata>
</pzIndexes>
</rowdata>
</MRCol>
<MCol REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Activity>CRD</Activity>
<Desk>London</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>1</pxTrackingIndex>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MCol">50</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Activity>Commodities</Activity>
<Desk>New-York</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>2</pxTrackingIndex>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MCol">51</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Activity>Treasury</Activity>
<Desk>Paris</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Treasury</BusinessLine>
<pxTrackingIndex>3</pxTrackingIndex>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MCol">49</rowdata>
</pzIndexes>
</rowdata>
</MCol>
<MatrixRows REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<SubProcess>Blotter</SubProcess>
<MatrixRowID>1234</MatrixRowID>
<SLRowID>1234</SLRowID>
<Function>Front Office</Function>
<Process>Order Management</Process>
<pxObjClass>MX-MXSFA-Data-MatrixRow</pxObjClass>
<pxTrackingIndex>1</pxTrackingIndex>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows">0</rowdata>
</pzIndexes>
<MatrixColumnList REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Competitor>Calypso</Competitor>
<Activity>CRD</Activity>
<Product>MXG2000</Product>
<Desk>London</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>1</pxTrackingIndex>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows_MatrixColumnList">7</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Competitor>Calypso</Competitor>
<Activity>Commodities</Activity>
<Product>MX.3</Product>
<Desk>New-York</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>2</pxTrackingIndex>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows_MatrixColumnList">8</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Competitor>Calypso</Competitor>
<Activity>Treasury</Activity>
<Product>MXG2000</Product>
<Desk>Paris</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Treasury</BusinessLine>
<pxTrackingIndex>3</pxTrackingIndex>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows_MatrixColumnList">9</rowdata>
</pzIndexes>
</rowdata>
</MatrixColumnList>
</rowdata>
<rowdata REPEATINGINDEX="2">
<SubProcess>Cash</SubProcess>
<MatrixRowID>1235</MatrixRowID>
<SLRowID>1235</SLRowID>
<Function>Operations</Function>
<Process>Settlements</Process>
<pxObjClass>MX-MXSFA-Data-MatrixRow</pxObjClass>
<pxTrackingIndex>2</pxTrackingIndex>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows">1</rowdata>
</pzIndexes>
<MatrixColumnList REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<Competitor>Competitor 1</Competitor>
<Activity>CRD</Activity>
<Product>Product 1</Product>
<Desk>London</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>1</pxTrackingIndex>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows_MatrixColumnList">10</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="2">
<Competitor>Competitor 2</Competitor>
<Activity>Commodities</Activity>
<Product>Product 2</Product>
<Desk>New-York</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Global Markets</BusinessLine>
<pxTrackingIndex>2</pxTrackingIndex>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows_MatrixColumnList">11</rowdata>
</pzIndexes>
</rowdata>
<rowdata REPEATINGINDEX="3">
<Competitor>Competitor 3</Competitor>
<Activity>Treasury</Activity>
<Product>Product 3</Product>
<Desk>Paris</Desk>
<pxObjClass>MX-MXSFA-Data-MatrixColumn</pxObjClass>
<BusinessLine>Treasury</BusinessLine>
<pxTrackingIndex>3</pxTrackingIndex>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows_MatrixColumnList">12</rowdata>
</pzIndexes>
</rowdata>
</MatrixColumnList>
</rowdata>
<rowdata REPEATINGINDEX="3">
<MatrixRowID>1236</MatrixRowID>
<SLRowID>1236</SLRowID>
<pxObjClass>MX-MXSFA-Data-MatrixRow</pxObjClass>
<pxTrackingIndex>3</pxTrackingIndex>
<pzIndexOwnerKey>MX-MXSFA-WORK-SYSTEMLANDSCAPE 123456789</pzIndexOwnerKey>
<pzIndexes REPEATINGTYPE="PropertyGroup">
<rowdata REPEATINGINDEX="Index_MatrixRows">2</rowdata>
</pzIndexes>
<MatrixColumnList REPEATINGTYPE="PageList"/>
</rowdata>
</MatrixRows>
</pagedata>
Let me know please if you need further information.
Thanks,
Rosy
Salame
Hello Guhan,
Just to inform you that I was able to fix the size by adding a dynamic layout and putting my sections inside it, so, please, ignore above.
Thanks a lot for your help,
Rosy