Posted: 5 May 2020 6:47 EDT Last activity: 18 May 2020 12:16 EDT
Remove the timestamp filter on table/grid
We have multiple dynamic table/grids that display Receipt Date of type Date. Not sure why some Receipt Date filters on the tables/grids include timestamp while others do not. My requirement need the timestamp to be removed and only be filtered by date instead of date and time.
Please see attached pics to see what I mean. The highlighted yellow is what need to be removed/disabled.
Any help is much appreciated.
***Edited by Moderator Marissa to update Type from General to Product***
If the column type of the date field is only DATE, then we see only Date to be selected in the date popover and it does NOT include timestamp field.
If the column type of the date field is DATETIME, then we see Date and time to be selected in the date popover and it does include timestamp field,
To confirm this theory, the implementation is present in section that belongs class CL:Pega-ColumnFilterCriteria with name pyGridFilterRangeFields in the ruleset Pega-Gadgets:08-01-01
If we open the visibility of the From and To fields in the section, it confirms the same as shown below.
For Date :
For Date Time :
So, this is the reason you would see for timestamp for some columns and dont see timestamp for some fields
If you would like to not to see timestamp for your grid on datetime fields too, then the section (CL:Pega-ColumnFilterCriteria with name pyGridFilterRangeFields in the ruleset Pega-Gadgets:08-01-01) is available, you can save as into the specific application ruleset and do the customization on visibility condition or change the datetime field configuration. I did it and that does not include timestamp.
Thank you for replying. After the implementation, the filter functionality does not work. Date and DateTime properties are both assigned to pyStartDate/pyEndDate and caused the filter to not work. Is there away around this?
Not sure if this is what you mean but in pyGridFilterRangeFields section I changed the presentation to Date and that seems to do the trick for both Date/DateTime properties. This is now resolved. Thank you for your time.