[rules-users] Drools Flow 5.1.0.M1 - Human Task - Client Operation - getTasksAssignedAsPotentialOwner - does not return Task if "Comment" property is not set
Mauricio Salatino
salaboy at gmail.com
Thu Nov 12 13:34:31 EST 2009
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 at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
--
- http://salaboy.wordpress.com
- http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20091112/229568c7/attachment.html
More information about the rules-users
mailing list