Question
PT Bank Mandiri Persero, Tbk
ID
Last activity: 10 Jan 2023 21:08 EST
Select the rows from table/datagrid and count the value from selected row
Hi,
I have a grid that has a report definition as a data source. And in every row, it has a checkbox to select/deselect the rows (for now I'm using the .pySelected). Then, if the checkbox is selected, we will get the PI value and if the user clicks the Count PI button below the table, it will calculate all the PI ONLY from the selected rows. How can I accomplish this approach? How do we know the row is selected and we can get the PI value from that row?
I attach the screenshot below
Please note that this table will be in the CaseInformation section
Thank you
Accepted Solution
Updated: 10 Jan 2023 21:08 EST
Pegasystems Inc.
IN
@AyuAnindita Hi You can achieve this by two ways
1. create a data page which is editable and give Report Definition as the source use the data page as a source for grid. Use pyselected property as a property for checkbox. On click of button run data transform to calculate the final PI. In DT use @Utilities.countInPageList("true",pySelected,D_DataPage.pxResults)
2. Have the same implementation as you have and On click of button run data transform to calculate the final PI. In DT use @Utilities.countInPageList("true",pySelected, ReportPage.pxResults). Please check the clipboard for the exact report definition page.
Updated: 9 Jan 2023 1:34 EST
Accenture
SG
Hi @AyuAnindita, If you just need the count of selected rows from the table you can run a Data transform on click of countpi button and use following function @Utilities.countInPageList("true",pySelected,ReportResults). If you want to sum the PI of selected rows, I would recommend you to use declare expression. Thanks, Vinay
Accepted Solution
Updated: 10 Jan 2023 21:08 EST
Pegasystems Inc.
IN
@AyuAnindita Hi You can achieve this by two ways
1. create a data page which is editable and give Report Definition as the source use the data page as a source for grid. Use pyselected property as a property for checkbox. On click of button run data transform to calculate the final PI. In DT use @Utilities.countInPageList("true",pySelected,D_DataPage.pxResults)
2. Have the same implementation as you have and On click of button run data transform to calculate the final PI. In DT use @Utilities.countInPageList("true",pySelected, ReportPage.pxResults). Please check the clipboard for the exact report definition page.