[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]

nice

On Fri, Nov 13, 2009 at 2:27 PM, Kris Verlaenen <
kris.verlaenen at cs.kuleuven.be> wrote:

> 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 at mdes.ms.gov>:
>
> > Thanks Mauricio for the quick reply. Is there any JIRA associated
> > with this?
> >
> > Thanks
> > Vijay
> > ________________________________
> > From: rules-users-bounces at lists.jboss.org
> > [mailto:rules-users-bounces at 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 at mdes.ms.gov<mailto: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<mailto: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 -
> >
>
>
>
>
> Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm
> _______________________________________________
> 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/20091113/af80c591/attachment.html