Question
Murex
LB
Last activity: 26 Feb 2024 11:23 EST
Column Filters on a table referencing a Data page doesn't update the pxResultCount whever a filter is being set
We've set up a section where we've inserted a table. This table is referencing a data page rule and is designed to display results where the user can filter using columns filters. Above the table, in a separate section, we show the user the total count of results(D_datapage.pxResultCount).
The issue arises when users apply filters to the columns. Despite the table correctly updating to display a reduced number of results, the count displayed to the user remains the same as before. For example, if initially, the table shows 76 results, and a user applies filters resulting in only 3 visible results, the count displayed above the table (pxResultCount) doesn't update to reflect this change.
We've experimented with using a Report Definition rule instead, and it behaves as expected, correctly updating the result count when column filters are applied. Our question is whether it's possible to achieve the same functionality using a Data page, and if so, how can we implement it?
***Edited by Moderator Rupashree to add Capability tags***
Accepted Solution
Updated: 26 Feb 2024 11:23 EST
Maantic Inc
IN
@JosephAzarby default when you use ootb column filter that will not show accurate count as its doing a subset based on your column filter. And it will hold original value. Either remove column filter and have seperate filter which is passing data to the main data page as parameter to load reduced number in first place. Second will be complicated have seperate function or modify ootb filter logic and add counts along with it to show. First one is better to tweak requirement and code a bit.
Maantic Inc
IN
@JosephAzarIf by deafult it is not coming, you can create a page type data page, which sources using a data transform which loads the report def , property map into primary page including the pxresults count. Only if OOTB is not working.
Murex
LB
@Soham_Chanda1107 thanks for replying, however this didn't work as the data page referenced in the table is still not showing the correct result number got when using the column filters.
Any other suggestions ?
Accepted Solution
Updated: 26 Feb 2024 11:23 EST
Maantic Inc
IN
@JosephAzarby default when you use ootb column filter that will not show accurate count as its doing a subset based on your column filter. And it will hold original value. Either remove column filter and have seperate filter which is passing data to the main data page as parameter to load reduced number in first place. Second will be complicated have seperate function or modify ootb filter logic and add counts along with it to show. First one is better to tweak requirement and code a bit.