[rules-users] Drools Flow 5.1.0.M1 - Human Task - Client Operation - getTasksAssignedAsPotentialOwner - does not return Task if "Comment" property is not set
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
Attachments:
- attachment.html (text/html — 32.0 KB)