Question

2
Replies
1824
Views
Close popover
Alpha Rajan (MikeMiracle)
SANTANDER

SANTANDER
GB
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,
Close popover 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.