topic Re: Workflow query on custom props fails with datetime prop datatype in Alfresco Forum

Workflow query on custom props fails with datetime prop datatype

vincent-kali — Sun, 29 Jul 2018 21:45:22 GMT

Hi,I want to query workflow instances using property filter.Query on String datatype are working well, but query on DateTime datatype fails with exception below.Any Idea ?My code: WorkflowInstanceQuery workflowInstanceQuery = new WorkflowInstanceQuery(); Map<QName, Object> filters = new HashMa

Re: Workflow query on custom props fails with datetime prop datatype

afaust — Mon, 30 Jul 2018 08:26:25 GMT

Alfresco has explicit special handling for date properties. Since it is very unlikely someone would be searching on an exact timestamp, Alfresco support a date-based condition to be a map with the following allowed entries:

key: DatePosition.BEFORE, value: date value compared against using less or equals
key: DatePosition.AFTER, value: date value compared against using greater or equals

You can see that by looking at the source of the class referenced by the error stacktrace.

Re: Workflow query on custom props fails with datetime prop datatype

vincent-kali — Mon, 30 Jul 2018 09:46:59 GMT

Yes, Many thanks ! Code below is working fine:

WorkflowInstanceQuery workflowInstanceQuery = new WorkflowInstanceQuery();
Map<QName, Object> filters = new HashMap<QName, Object>;

Map<DatePosition, Date> dateParams = new HashMap<DatePosition, Date>();

dateParams.put(DatePosition.BEFORE, endRangeDate);

dateParams.put(DatePosition.AFTER, startRangeDate);

filters.put(propertyQName, dateParams);
workflowInstanceQuery.setCustomProps(filters);
this.workflowService.getWorkflows(workflowInstanceQuery, maxItems, skipCount);