Question
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
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
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:
Hope this helps!
-Kurt
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
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
Hi Mathan,
I found this SA-17364: Sorting and filtering not available on some columns in grid Does this answer your question? If not, let us know!
Thanks!