Re: [rules-users] Drools Flow 5.1.0.M1 - Human Task - Client Operation - getTasksAssignedAsPotentialOwner - does not return Task if "Comment" property is not set

Thanks Mauricio for the quick reply. Is there any JIRA associated with this? Thanks Vijay ________________________________ From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Mauricio Salatino Sent: Thursday, November 12, 2009 12:35 PM To: Rules Users List Subject: Re: [rules-users] Drools Flow 5.1.0.M1 - Human Task - Client Operation - getTasksAssignedAsPotentialOwner - does not return Task if "Comment" property is not set Yes.. I report that before, but it's not really a problem. The comment makes a relationship with all the i18n things. For now you need to set the comment to be able to retrieve the tasks that you want. Greetings. 2009/11/12 Vijay K Pandey <VPandey@mdes.ms.gov<mailto:VPandey@mdes.ms.gov>> Hi, Looks like there is some issue in the named query "TasksAssignedAsPotentialOwner" for the (Drools Flow 5.1.0.M1 - Human Task - Client Operation - getTasksAssignedAsPotentialOwner). It does not return the Tasks if we don't specify anything in the "Comment" property of the "Human Task". The following code was used to retrieve the results BlockingTaskSummaryResponseHandler responseHandler = new BlockingTaskSummaryResponseHandler(); client.getTasksAssignedAsPotentialOwner("Luke Cage", "en-UK", responseHandler); I looked at the generated SQL (given below) and look like it tries to match the 'task id' with the "subjects_id, names_id, descriptions_id" of the table I18NTEXT --- the values of the "subjects_id" and "descriptions_id" goes as null because there is no "comment" associated with the work item 'Human Task' and since its not a left outer join on the descriptions_id - hence no returned result. 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_.task_data_actual_owner_id as col_7_0_, task0_.task_data_created_by_id as col_8_0_, task0_.created_on as col_9_0_, task0_.activation_time as col_10_0_, task0_.expiration_time as col_11_0_ from WSHT_TASK task0_ left outer join ORGANIZATIONAL_ENTITY user1_ on task0_.task_data_created_by_id=user1_.id left outer join ORGANIZATIONAL_ENTITY user2_ on task0_.task_data_actual_owner_id=user2_.id left outer join I18NTEXT subjects3_ on task0_.id=subjects3_.task_subjects_id, I18NTEXT i18ntext4_, I18NTEXT i18ntext5_, ORGANIZATIONAL_ENTITY organizati6_ where organizati6_.id=? and ( organizati6_.id in ( select potentialo9_.entity_id from PEOPLE_ASSIGNMENTS_POTENTIAL_OWNERS 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_.expiration_time is null ) Can someone throw some light on this? Do we have to have "Comment" property set? Thanks Vijay _______________________________________________ rules-users mailing list rules-users@lists.jboss.org<mailto:rules-users@lists.jboss.org> https://lists.jboss.org/mailman/listinfo/rules-users -- - http://salaboy.wordpress.com - http://www.jbug.com.ar - Salatino "Salaboy" Mauricio -