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

[Vijay K Pandey]

Thanks, I guess "Comment" will not harm so for now will set the same as the "Task Name"

________________________________
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 1:48 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

I think not, because it's only that, I just always add a comment for that query works.

2009/11/12 Vijay K Pandey <VPandey at mdes.ms.gov<mailto: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> [mailto: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 -

_______________________________________________
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 -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20091112/7de6b260/attachment.html