Sort not working for while displaying in Table
Hi,
I am passing Report Definition as source for a Table in section (Screenshot_1). I am facing 2 issues there:
1. I want to limit the number of records displayed as 30 but it is not working with the option 'Maximum number of rows to retrieve' available in Data Access tab of RD. If I execute the RD, I can see that it is displaying only 30 records but in Table it displays the whole records in the system.
2. So I am restricting it as mentioned in Screenshot_2 but the sorting doesn’t work in table with this change.
Can anyone please help to resolve this as soon as possible. PRPC version : 7.3.1
***Moderator Edit: Vidyaranjan | Updated Categories***
Pegasystems Inc.
US
Commonwealth Bank of Australia
AU
Hi RonLee,
Thanks for your response. Yes, it works if I do the changes according to what you have said. But we need pagination as well in the grid as per business requirement. Is there any solution to satisfy both?
Pegasystems Inc.
US
I don't know of a way to get everything you want working together.
The way sorting is accomplished is that we re-issue the query with an "ORDER BY" clause for the column that was sorted. The reason it does not work when you enable the "Display Top Ranked..." option is that it already adds an "ORDER BY" clause for the "based on" property you specify in that option. We can't add 2 "ORDER BY"s, and just adding the sort column to the single "ORDER BY" may not give the desired results, so I believe the sort column is just ignored.
Do you have paging on in your grid? If so, please disable it. Also revert the change to limit the number of results in the report definition (screenshot 2). Set the "Maximum number of rows to retrieve" to 30 as you had originally done (on the "Data Access" tab). This should display 30 rows in the grid, with sorting still enabled.
When paging is enabled on the grid, I believe that the value set for "Maximum number of rows to retrieve" is ignored.