Quoting Vijay K Pandey <
VPandey@mdes.ms.gov>:
> Thanks Mauricio for the quick reply. Is there any JIRA associated
> with this?
>
> Thanks
> Vijay
> ________________________________
> From:
rules-users-bounces@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
> 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