Question

5
Replies
974
Views
 Mathan Santhosh Kumar (Mathan)
ASB Limited
Pega Consultant
ASB Limited
NZ
Mathan Member since 2014 12 posts
ASB Limited
Posted: January 9, 2016
Last activity: January 22, 2016
Posted: 9 Jan 2016 2:00 EST
Last activity: 22 Jan 2016 15:58 EST
Closed

Filtering on .pxcreatedatetime property

Hi Team, filtering on .pxcreatedatetime property in listview is not working.

we have paging enabled and sort mode is set to all pages. (it was viewed pages and sorting working fine)

cant we use sorting on date properties or it is only available for Viewed Pages alone.

it is 6.3SP1

could you please let us know how to resolve and let us know if any fix available?

Thanks,

Mathan

Data Integration Reporting
Moderation Team has archived post, 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.
Posted: 5 years ago
Posted: 19 Jan 2016 0:15 EST
Mathan Santhosh Kumar (Mathan)
ASB Limited
Pega Consultant
ASB Limited
NZ

Hi Team, still I need help on this, and for your more information.

we are using the custom activity to populate the source.

kindly let me know if we can use sort data from all pages when we are using custom activities.

Thanks,

Mathan
Posted: 5 years ago
Posted: 19 Jan 2016 16:04 EST
Kurt Waltz (KurtW_GCS)
PEGA
Principal GCS Solutions Engineer
Pegasystems Inc.
US

Hi Mathan,

Can you please clarify if it is Sorting or Filtering that is not working in your list view?  I see you've mentioned both in your descriptions, and these two functionalities can change differently in response to the configuration of the list view.

When using a custom activity for the report source of a list view, sometimes referred to as a "custom getContent activity", some list view functionality is disabled by default.  This is done because that functionality cannot be guaranteed to work properly if the OOTB getContent activity is not used.  Filtering is included in the subset of list view functionality that is disabled when a custom activity is used in place of getContent (in my testing, the "Enable Filtering" option on the ruleform was actually disabled as soon as I changed the activity).  The following help article has some additional information:

https://pdn.pega.com/sites/pdn.pega.com/files/help_v63sp1/Default.htm#rule-/rule-obj-/rule-obj-listview/content.htm

Hope this helps!

-Kurt
Posted: 5 years ago
Posted: 21 Jan 2016 0:20 EST
Mathan Santhosh Kumar (Mathan)
ASB Limited
Pega Consultant
ASB Limited
NZ

Hi Kurt, we are using custom activity to get report source in a listview and where as paging is enabled, with page size 200 and sort mode All Pages.

Actual issue is on Sorting while listview loads records more than 200, and the all pages are not getting sorted but only the current page (viewed page).

is it possible to sort the data from all the pages when we are using custom activity.. can i please get know how it can be done?

thanks,

Mathan
Posted: 5 years ago
Posted: 22 Jan 2016 15:58 EST
Kurt Waltz (KurtW_GCS)
PEGA
Principal GCS Solutions Engineer
Pegasystems Inc.
US

Hi Mathan,

I just ran a quick test in my local system with a listview similar to that which you described (Paging enabled, page size of 200, sort mode set to all pages, and a "custom" getContent activity), and attempted to sort on .pxCreateDateTime.  I was able to see the sorting persist when I moved from one page to another so it looks like this functionality doesn't get disabled automatically when you use a custom getContent activity.  My "custom" getContent activity is just a Save-As of the OOTB getContent activity, so its possible that something in the OOTB version is necessary for the sorting to work.

What happens if you test the your listview using a getContent activity that is close to the OOTB one (similar to the test I ran)?  Do you still see only the viewed page being sorted?  This test may confirm on whether or not the configuration of your custom getContent activity plays into the behavior.

-Kurt