topic Re: Query by Date & NodeRef As String does not working properly in Alfresco Archive

Query by Date & NodeRef As String does not working properly

mohammed_amr — Sun, 19 Feb 2012 07:37:39 GMT

Dear Team,I have set of workflows instances and tasks, and i used WorkflowTaskQuery for query about tasks with custom task properties, even though when i set a (Date, NodeRef As String) values in the custom properties ( & i ensure that this values exists in some of tasks) and pass it for the que

Re: Query by Date & NodeRef As String does not working properly

mitpatoliya — Mon, 20 Feb 2012 11:16:07 GMT

can you post the query which you are using for this?
It will give more idea.

Re: Query by Date & NodeRef As String does not working properly

mohammed_amr — Tue, 28 Feb 2012 14:03:46 GMT

lets i use the following code

WorkflowTaskQuery query = new WorkflowTaskQuery();

Map<QName,Serializable> properties = new HashMap<QName,Serializable>();
properties.set(QName.createQName("sec","creationDate"),new Date());
query.setCustomTaskProps(properties);

workflowService.query(query); // No Results returned although there is a tasks in the console has this value

another example about nodeRef

WorkflowTaskQuery query = new WorkflowTaskQuery();

Map<QName,Serializable> properties = new HashMap<QName,Serializable>();
properties.set(QName.createQName("sec","sender"),nodeRef.getNodeRefAsString());
query.setCustomTaskProps(properties);

workflowService.query(query); // No Results returned although there is a tasks in the console has this value

Re: Query by Date & NodeRef As String does not working properly

yogeshpj — Fri, 27 Apr 2012 08:08:34 GMT

Hi mohammed.amr,

Can you please try processCustomProps. Please try query.setProcessCustomProps(properties).

Re: Query by Date & NodeRef As String does not working properly

mohammed_amr — Mon, 30 Apr 2012 06:19:25 GMT

already tried.

Re: Query by Date & NodeRef As String does not working properly

yogeshpj — Thu, 03 May 2012 06:04:50 GMT

Can you please show me the query you are executing and the property entry in workflow model which you are adding in taskcustomprops ?

Re: Query by Date & NodeRef As String does not working properly

mohammed_amr — Thu, 03 May 2012 06:14:37 GMT

Good,

Listen, i have two way of search upon workflow, one of them by task and another by process.

neither task or process takes a date as a parameter. you can try to search by by date using workflow console and you will reach for this conclusion.

Thanks.

Re: Query by Date & NodeRef As String does not working properly

yogeshpj — Thu, 03 May 2012 06:25:15 GMT

Yes,You are right. Taskcustomprops and processcustomprops are not accepting date as parameter.

Re: Query by Date & NodeRef As String does not working properly

mohammed_amr — Thu, 03 May 2012 06:40:47 GMT

That what i'm trying to do, search by date. However all workflow properties must be string. Try to search by nodeRef you cannot.

That miss-functionality in workflow search.

Thanks

Re: Query by Date & NodeRef As String does not working properly

swemon — Thu, 03 May 2012 08:34:48 GMT

I have the same problem.. I can't find workflow tasks by completion date.

Re: Query by Date & NodeRef As String does not working properly

mohammed_amr — Thu, 03 May 2012 09:58:17 GMT

:lol:

Look man, you cannot solve it, however you can wrap the result of search with a custom filter gives you the desired result.

At all cases, still this functionality is missed by Workflow engine providers.

I hope this help you.

Welcome.

Mohammed Amr
Senior System Developer.