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 <[email protected]> > 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 > [email protected] > https://lists.jboss.org/mailman/listinfo/rules-users > > -- - http://salaboy.wordpress.com - http://www.jbug.com.ar - Salatino "Salaboy" Mauricio -
_______________________________________________ rules-users mailing list [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
