Question

2
Replies
1752
Views
MikeMiracle Member since 2015 5 posts
SANTANDER
Posted: August 3, 2018
Last activity: August 10, 2018
Closed

Current Row number of ReportDefinition which is ranked by a column

I am using a report definition to populate a datapage. Within the report definition , I am using top 5 ranking using one of the column (using settings at the bottom of the RD Query Tab). I want to set the current row number as a column in the report definition. Please not that I am only using Report Definition to query DB , It is used with in an activity as a source to a Data page . i don't have a repeating grid UI component , which is the most common use case for RD. So front end solutions don't apply . (screen shot of RD rule and pages & classes tab are attached )

So far I have tried refering pzRank and pyReportContentPage.pxResults().pxListSubscript clipboard properies. But I got error . Most common error is " This record has 1 error(s) in 1 place(s) .Message Label— ** pzUnexpPropinExtTable " . It like I can only using mapped fields in the column name. Also I tried postgresfunction to return the row index . That didn't work either.

Any help will be highly appreciated,

Mike

Env

Pega 7.2.2

FrameWork - Marketing

Pega Platform Data Integration Java and Activities Reporting
Moderation Team has archived post
Share this page LinkedIn