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

Actually, there is, and I believe the fix is already implemented in the latest snapshot, have you tried this already? https://jira.jboss.org/jira/browse/JBRULES-2324 Kris Quoting Vijay K Pandey <VPandey(a)mdes.ms.gov&gt;: > 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 - > Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users