I have a Report which pulls data from a Portal Report via a!queryProcessAnalytics(). On this report I have a Start Date and End Date filter for which I would like to show Active processes submitted within a certain date range. If I enter a Start Date and an End Date, I am not able to find any processes which are Active as these processes have a Completion Date (process_completion_time) of NULL. For example: I enter 04/13/2016 (Start Date) and 04/20/2016 (End Date). I would expect to see all Active processes submitted in between 04/13/2016 and 04/20/2016. How can I use a!queryFilter() to handle NULL values for process_completion_time?When the process is complete or cancelled, the filters work great. However, its only Active processes which are giving me trouble. Thanks!
OriginalPostID-207715
Discussion posts and replies are publicly visible