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