I think not, because it's only that, I just always add a comment for that query works.<br><br><br><div class="gmail_quote">2009/11/12 Vijay K Pandey <span dir="ltr"><<a href="mailto:VPandey@mdes.ms.gov">VPandey@mdes.ms.gov</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Thanks Mauricio for the quick reply. Is
there any JIRA associated with this?</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Thanks</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Vijay</span></font></p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<a href="mailto:rules-users-bounces@lists.jboss.org" target="_blank">rules-users-bounces@lists.jboss.org</a>
[mailto:<a href="mailto:rules-users-bounces@lists.jboss.org" target="_blank">rules-users-bounces@lists.jboss.org</a>] <b><span style="font-weight: bold;">On
Behalf Of </span></b>Mauricio Salatino<br>
<b><span style="font-weight: bold;">Sent:</span></b> Thursday, November 12, 2009
12:35 PM<br>
<b><span style="font-weight: bold;">To:</span></b> Rules Users List<br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [rules-users] Drools
Flow 5.1.0.M1 - Human Task - Client Operation -
getTasksAssignedAsPotentialOwner - does not return Task if "Comment"
property is not set</span></font></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal" style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Yes.. I report that
before,<br>
but it's not really a problem. The comment makes a relationship with all the
i18n things.<br>
For now you need to set the comment to be able to retrieve the tasks that you
want.<br>
Greetings.</span></font></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">2009/11/12 Vijay K Pandey <<a href="mailto:VPandey@mdes.ms.gov" target="_blank">VPandey@mdes.ms.gov</a>></span></font></p>
<div link="blue" vlink="purple">
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi,</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Looks like there
is some issue in the named query “<b><span style="font-weight: bold;">TasksAssignedAsPotentialOwner</span></b>”
for the (<b><span style="font-weight: bold;">Drools Flow 5.1.0.M1 - Human Task</span></b>
- Client Operation – <b><span style="font-weight: bold;">getTasksAssignedAsPotentialOwner</span></b>).</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">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</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> <span><span style="background: silver none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;">BlockingTaskSummaryResponseHandler</span></span>
responseHandler = </span></font><b><font color="#7f0055" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(127, 0, 85); font-weight: bold;">new</span></font></b><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> <span style="background: silver none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;"><span>BlockingTaskSummaryResponseHandler</span></span>();</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> </span></font><font color="#0000c0" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 192);">client</span></font><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">.getTasksAssignedAsPotentialOwner(</span></font><font color="#2a00ff" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(42, 0, 255);">"Luke Cage"</span></font><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">, </span></font><font color="#2a00ff" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(42, 0, 255);">"en-UK"</span></font><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">, responseHandler);</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">I looked at the
generated SQL (given below) and look like it tries to match the ‘<b><span style="font-weight: bold;">task id</span></b>’ with the “<b><span style="font-weight: bold;">subjects_id</span></b>, <b><span style="font-weight: bold;">names_id</span></b>, <b><span style="font-weight: bold;">descriptions_id</span></b>”
of the table </span></font><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">I18NTEXT --- the
values of the “subjects_id” and “descriptions_id” goes as null because there is
no “comment” associated with the work item ‘<b><span style="font-weight: bold;">Human
Task</span></b>’ and since <b><span style="font-weight: bold;">its not a left
outer join</span></b> on the </span></font><b><span style="font-weight: bold;">descriptions_id
</span></b>– hence no returned result<font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">.</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> select</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> task0_.id
as col_0_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
i18ntext4_.text as col_1_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> subjects3_.text
as col_2_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
i18ntext5_.text as col_3_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.status as col_4_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.priority as col_5_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.skipable as col_6_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.task_data_actual_owner_id as col_7_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.task_data_created_by_id as col_8_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.created_on as col_9_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.activation_time as col_10_0_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.expiration_time as col_11_0_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> from</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> WSHT_TASK
task0_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> left outer join</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
ORGANIZATIONAL_ENTITY user1_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
on task0_.task_data_created_by_id=user1_.id </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> left outer join</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
ORGANIZATIONAL_ENTITY user2_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
on task0_.task_data_actual_owner_id=user2_.id </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> left outer join</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> I18NTEXT
subjects3_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
on task0_.id=subjects3_.task_subjects_id,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> I18NTEXT
i18ntext4_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> I18NTEXT
i18ntext5_,</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
ORGANIZATIONAL_ENTITY organizati6_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> where</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
organizati6_.id=? </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
organizati6_.id in (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
select</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
potentialo9_.entity_id </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
from</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
PEOPLE_ASSIGNMENTS_POTENTIAL_OWNERS potentialo9_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
where</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.id=potentialo9_.task_id</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
)</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> ) </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and
i18ntext4_.language=? </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
i18ntext4_.id in (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
select</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
names10_.id </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
from</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
I18NTEXT names10_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
where</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.id=names10_.task_names_id</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
)</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> ) </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and
subjects3_.language=? </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and
i18ntext5_.language=? </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
i18ntext5_.id in (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
select</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
descriptio11_.id </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
from</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
I18NTEXT descriptio11_ </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
where</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.id=descriptio11_.task_descriptions_id</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
)</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> ) </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.status in (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
'Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended'</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
)</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> ) </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> and (</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">
task0_.expiration_time is null</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> )</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Can someone throw some light on this? Do we have to
have “Comment” property set?</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> </span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Thanks</span></font></p>
<p class="MsoNormal"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Vijay</span></font></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org" target="_blank">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a></span></font></p>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br clear="all">
<br>
-- <br>
- <a href="http://salaboy.wordpress.com" target="_blank">http://salaboy.wordpress.com</a><br>
- <a href="http://www.jbug.com.ar" target="_blank">http://www.jbug.com.ar</a><br>
- Salatino "Salaboy" Mauricio -</span></font></p>
</div></div></div>
</div>
<br>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br> - <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br> - <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> - Salatino "Salaboy" Mauricio -<br>