<span style="white-space: pre;"></span>client.getTasksAssignedAsPotentialOwner("Joe",
"en-UK", summaryHandler);<br>This method used the "en-UK" for i18n reasons.. you need to set the field content (and I'm sure right now, because that I don't have the source code here) and the field comment to "en-UK".<br>
<br><div class="gmail_quote">2010/4/22 rudolf michael <span dir="ltr"><<a href="mailto:roudolf@gmail.com">roudolf@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr">and the hibernate hql query<div><div>select </div><div> new org.drools.task.query.TaskSummary(</div><div> <a href="http://t.id" target="_blank">t.id</a>,</div><div> names.text,</div><div> subject.text,</div>
<div> descriptions.text,</div><div> t.taskData.status,</div><div> t.priority,</div><div> t.taskData.skipable,</div><div> t.taskData.actualOwner,</div><div> t.taskData.createdBy,</div><div> t.taskData.createdOn,</div>
<div> t.taskData.activationTime,</div><div> t.taskData.expirationTime)</div><div>from </div><div> Task t</div><div> left join t.taskData.createdBy</div><div> left join t.taskData.actualOwner</div><div> left join t.subjects as subject,</div>
<div> I18NText names,</div><div> I18NText descriptions, </div><div> OrganizationalEntity potentialOwners</div><div>where </div><div> potentialOwners.id = :userId and</div><div> potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and </div>
<div> </div><div> names.language = :language and</div><div> names in elements( t.names) and</div><div> </div><div> subject.language = :language and</div><div> </div><div> descriptions.language = :language and</div>
<div> descriptions in elements( t.descriptions) and</div><div> </div><div> t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and</div><div> </div>
<div> t.taskData.expirationTime is null </div><div><div></div><div class="h5"><br><div class="gmail_quote">On Thu, Apr 22, 2010 at 5:33 PM, rudolf michael <span dir="ltr"><<a href="mailto:roudolf@gmail.com" target="_blank">roudolf@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div dir="ltr">and this is how i am listing the tasks.<div><div>try {</div><div><span style="white-space: pre;">                                </span>MinaTaskClient client = new MinaTaskClient("client 1", new TaskClientHandler(SystemEventListenerFactory.getSystemEventListener()));</div>
<div><span style="white-space: pre;">                                </span>NioSocketConnector connector = new NioSocketConnector();</div><div><span style="white-space: pre;">                                </span>SocketAddress address = new InetSocketAddress("127.0.0.1",9123);</div>
<div><span style="white-space: pre;">                                </span>client.connect(connector, address);</div><div><span style="white-space: pre;">                                </span>BlockingTaskSummaryResponseHandler summaryHandler = new BlockingTaskSummaryResponseHandler();</div>
<div><span style="white-space: pre;">                                </span>client.getTasksAssignedAsPotentialOwner("Joe", "en-UK", summaryHandler);</div><div><span style="white-space: pre;">                                </span>List<TaskSummary> arg0 = summaryHandler.getResults();</div>
<div><span style="white-space: pre;">                                </span>System.out.println("Joe's task list size is "+arg0.size());</div><div><span style="white-space: pre;">                                </span>for(int i=0; i < arg0.size(); i++){</div>
<div><span style="white-space: pre;">                                        </span>System.out.println("Task Listed for Administrator "+arg0.get(i).getId()+", name="+arg0.get(i).getName()+", status="+arg0.get(i).getStatus());</div>
<div><span style="white-space: pre;">                                </span>}</div><div><span style="white-space: pre;">                        </span>}catch(Exception ex){</div><div><span style="white-space: pre;">                                </span></div>
<div><span style="white-space: pre;">                        </span>}</div><div><br></div>are you sure that you're connecting to the same TaskService that the drools flow engine is connected to?</div><div><div></div><div><div><br>
<div class="gmail_quote">
On Thu, Apr 22, 2010 at 5:29 PM, rudolf michael <span dir="ltr"><<a href="mailto:roudolf@gmail.com" target="_blank">roudolf@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr">well i had your problem when i started doing some human task processing then after i have set the Comment for the tasks, the task list worked fine for me.<div>Find below my Test case logs:<br><div><div><br>
</div>
<div>Hibernate: update ProcessInstanceInfo set externalVariables=?, lastModificationDate=?, lastReadDate=?, processId=?, processInstanceByteArray=?, startDate=?, state=?, OPTLOCK=? where processInstanceId=? and OPTLOCK=?</div>
<div>Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?</div><div>Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, skipable, status, workItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</div>
<div>Hibernate: update WorkItemInfo set creationDate=?, name=?, processInstanceId=?, state=?, OPTLOCK=?, workItemByteArray=? where workItemId=? and OPTLOCK=?</div><div>Hibernate: insert into I18NText (language, text) values (?, ?)</div>
<div>Hibernate: update SessionInfo set dirty=?, lastModificationDate=?, rulesByteArray=?, startDate=? where id=?</div><div>Hibernate: insert into I18NText (language, text) values (?, ?)</div><div>Hibernate: insert into I18NText (language, text) values (?, ?)</div>
<div>Hibernate: update I18NText set Task_Descriptions_Id=? where id=?</div><div>Hibernate: update I18NText set Task_Names_Id=? where id=?</div><div>Hibernate: insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id) values (?, ?)</div>
<div>Hibernate: insert into PeopleAssignments_PotentialOwners (task_id, entity_id) values (?, ?)</div><div>Hibernate: update I18NText set Task_Subjects_Id=? where id=?</div><div>INFO: RECEIVED: HeapBuffer[pos=0 lim=199 cap=2048: 00 00 00 C3 AC ED 00 05 73 72 01 00 1F 6F 72 67...]</div>
<div>[2010:04:112 17:04:846:debug] Message receieved on server : QueryTasksAssignedAsPotentialOwner</div><div>[2010:04:112 17:04:846:debug] Arguments : [Joe, en-UK]</div><div>Task Claimed for Joe, Task Name=1</div><div>Apr 22, 2010 5:23:13 PM org.apache.mina.filter.logging.LogLevel$4 log</div>
<div>INFO: SENT: HeapBuffer[pos=0 lim=216 cap=256: 00 00 00 D4 AC ED 00 05 73 72 01 00 1F 6F 72 67...]</div><div>Apr 22, 2010 5:23:13 PM org.apache.mina.filter.logging.LogLevel$4 log</div><div>INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]</div>
<div>[2010:04:112 17:04:886:debug] Message receieved on client : AddTaskResponse</div><div>[2010:04:112 17:04:887:debug] Arguments : [1]</div><div>Hibernate: select task0_.id as col_0_0_, i18ntext4_.text as col_1_0_, subjects3_.text as col_2_0_, i18ntext5_.text as col_3_0_, task0_.status as col_4_0_, task0_.priority as col_5_0_, task0_.skipable as col_6_0_, task0_.actualOwner_id as col_7_0_, task0_.createdBy_id as col_8_0_, task0_.createdOn as col_9_0_, task0_.activationTime as col_10_0_, task0_.expirationTime as col_11_0_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id, I18NText i18ntext4_, I18NText i18ntext5_, OrganizationalEntity organizati6_ where organizati6_.id=? and (organizati6_.id in (select potentialo9_.entity_id from PeopleAssignments_PotentialOwners potentialo9_ where task0_.id=potentialo9_.task_id)) and i18ntext4_.language=? and (i18ntext4_.id in (select names10_.id from I18NText names10_ where task0_.id=names10_.Task_Names_Id)) and subjects3_.language=? and i18ntext5_.language=? and (i18ntext5_.id in (select descriptio11_.id from I18NText descriptio11_ where task0_.id=descriptio11_.Task_Descriptions_Id)) and (task0_.status in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) and (task0_.expirationTime is null)</div>
<div>Apr 22, 2010 5:23:13 PM org.apache.mina.filter.logging.LogLevel$4 log</div><div>INFO: RECEIVED: HeapBuffer[pos=0 lim=1036 cap=2048: 00 00 01 57 AC ED 00 05 73 72 01 00 1F 6F 72 67...]</div><div>Hibernate: select user0_.id as id64_0_ from OrganizationalEntity user0_ where user0_.id=? and user0_.DTYPE='User'</div>
<div>[2010:04:112 17:04:896:debug] Message receieved on server : RegisterForEventRequest</div><div>[2010:04:112 17:04:896:debug] Arguments : [org.drools.task.event.TaskEventKey@c6e7d8b, true, org.drools.process.workitem.wsht.WSHumanTaskHandler]</div>
<div>[2010:04:112 17:04:898:debug] Message receieved on server : RegisterForEventRequest</div><div>[2010:04:112 17:04:898:debug] Arguments : [org.drools.task.event.TaskEventKey@28075cfe, true, org.drools.process.workitem.wsht.WSHumanTaskHandler]</div>
<div>[2010:04:112 17:04:898:debug] Message receieved on server : RegisterForEventRequest</div><div>[2010:04:112 17:04:898:debug] Arguments : [org.drools.task.event.TaskEventKey@28f7c114, true, org.drools.process.workitem.wsht.WSHumanTaskHandler]</div>
<div>[2010:04:112 17:04:901:debug] Message receieved on client : QueryTaskSummaryResponse</div><div>[2010:04:112 17:04:901:debug] Arguments : [[org.drools.task.query.TaskSummary@a467e05f]]</div><div>Joe's task list size is 1</div>
<div>Task Listed for Administrator 1, name=User submits request, status=Reserved</div><div><div></div><div><br><div class="gmail_quote">On Thu, Apr 22, 2010 at 4:16 PM, HMandic <span dir="ltr"><<a href="mailto:trbuhom@net.hr" target="_blank">trbuhom@net.hr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br>
Still no resolution...<br>
<br>
I was reading through gazillion rows of log output (I've put<br>
log4j.logger.org.hibernate=debug and<br>
log4j.logger.org.hibernate.hql.ast.AST=debug in log4j.properties) for the<br>
last few days, and still can't figure it out.<br>
It has nothing to do with my human task item (I populated all the fields).<br>
The problem remains that hibernate generates the wrong SQL from<br>
"TasksAssignedAsPotentialOwner" (named query as found in orm.xml). It<br>
generates inner join on actualOwner which is null before somebody claims<br>
that task, that way I'll never get the list of tasks that I need to claim.<br>
<br>
I'm using hibernate 3.5.1FINAL and orm.xml from drools 5.1.0M1 (but it's the<br>
same as in 5.0.1).<br>
<br>
Could it be that I'm the only one with this problem?<br>
<font color="#888888">--<br>
View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Flow-Another-problem-with-Human-Task-tp724086p742826.html" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Flow-Another-problem-with-Human-Task-tp724086p742826.html</a><br>
</font><div><div></div><div>Sent from the Drools - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org" target="_blank">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div></div></blockquote></div><br></div></div></div></div></div>
</blockquote></div><br></div></div></div></div>
</blockquote></div><br></div></div></div></div>
<br>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br> - <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br> - <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> - Salatino "Salaboy" Mauricio -<br>