nice<br><br><div class="gmail_quote">On Fri, Nov 13, 2009 at 2:27 PM, Kris Verlaenen <span dir="ltr"><<a href="mailto:kris.verlaenen@cs.kuleuven.be">kris.verlaenen@cs.kuleuven.be</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Actually, there is, and I believe the fix is already implemented in the<br>
latest snapshot, have you tried this already?<br>
<br>
<a href="https://jira.jboss.org/jira/browse/JBRULES-2324" target="_blank">https://jira.jboss.org/jira/browse/JBRULES-2324</a><br>
<br>
Kris<br>
<div class="im"><br>
Quoting Vijay K Pandey <<a href="mailto:VPandey@mdes.ms.gov">VPandey@mdes.ms.gov</a>>:<br>
<br>
> Thanks Mauricio for the quick reply. Is there any JIRA associated<br>
> with this?<br>
><br>
> Thanks<br>
> Vijay<br>
> ________________________________<br>
> From: <a href="mailto:rules-users-bounces@lists.jboss.org">rules-users-bounces@lists.jboss.org</a><br>
> [mailto:<a href="mailto:rules-users-bounces@lists.jboss.org">rules-users-bounces@lists.jboss.org</a>] On Behalf Of Mauricio<br>
> Salatino<br>
> Sent: Thursday, November 12, 2009 12:35 PM<br>
> To: Rules Users List<br>
> Subject: Re: [rules-users] Drools Flow 5.1.0.M1 - Human Task - Client<br>
> Operation - getTasksAssignedAsPotentialOwner - does not return Task<br>
> if "Comment" property is not set<br>
><br>
> Yes.. I report that before,<br>
> but it's not really a problem. The comment makes a relationship with<br>
> all the i18n things.<br>
> For now you need to set the comment to be able to retrieve the tasks<br>
> that you want.<br>
> Greetings.<br>
> 2009/11/12 Vijay K Pandey<br>
</div>> <<a href="mailto:VPandey@mdes.ms.gov">VPandey@mdes.ms.gov</a><mailto:<a href="mailto:VPandey@mdes.ms.gov">VPandey@mdes.ms.gov</a>>><br>
<div><div></div><div class="h5">> Hi,<br>
><br>
> Looks like there is some issue in the named query<br>
> "TasksAssignedAsPotentialOwner" for the (Drools Flow 5.1.0.M1 - Human<br>
> Task - Client Operation - getTasksAssignedAsPotentialOwner).<br>
><br>
> It does not return the Tasks if we don't specify anything in the<br>
> "Comment" property of the "Human Task". The following code was used<br>
> to retrieve the results<br>
><br>
> BlockingTaskSummaryResponseHandler responseHandler = new<br>
> BlockingTaskSummaryResponseHandler();<br>
> client.getTasksAssignedAsPotentialOwner("Luke Cage", "en-UK",<br>
> responseHandler);<br>
><br>
> I looked at the generated SQL (given below) and look like it tries to<br>
> match the 'task id' with the "subjects_id, names_id, descriptions_id"<br>
> of the table I18NTEXT --- the values of the "subjects_id" and<br>
> "descriptions_id" goes as null because there is no "comment"<br>
> associated with the work item 'Human Task' and since its not a left<br>
> outer join on the descriptions_id - hence no returned result.<br>
><br>
> select<br>
> task0_.id as col_0_0_,<br>
> i18ntext4_.text as col_1_0_,<br>
> subjects3_.text as col_2_0_,<br>
> i18ntext5_.text as col_3_0_,<br>
> task0_.status as col_4_0_,<br>
> task0_.priority as col_5_0_,<br>
> task0_.skipable as col_6_0_,<br>
> task0_.task_data_actual_owner_id as col_7_0_,<br>
> task0_.task_data_created_by_id as col_8_0_,<br>
> task0_.created_on as col_9_0_,<br>
> task0_.activation_time as col_10_0_,<br>
> task0_.expiration_time as col_11_0_<br>
> from<br>
> WSHT_TASK task0_<br>
> left outer join<br>
> ORGANIZATIONAL_ENTITY user1_<br>
> on task0_.task_data_created_by_id=user1_.id<br>
> left outer join<br>
> ORGANIZATIONAL_ENTITY user2_<br>
> on task0_.task_data_actual_owner_id=user2_.id<br>
> left outer join<br>
> I18NTEXT subjects3_<br>
> on task0_.id=subjects3_.task_subjects_id,<br>
> I18NTEXT i18ntext4_,<br>
> I18NTEXT i18ntext5_,<br>
> ORGANIZATIONAL_ENTITY organizati6_<br>
> where<br>
> organizati6_.id=?<br>
> and (<br>
> organizati6_.id in (<br>
> select<br>
> potentialo9_.entity_id<br>
> from<br>
> PEOPLE_ASSIGNMENTS_POTENTIAL_OWNERS potentialo9_<br>
> where<br>
> task0_.id=potentialo9_.task_id<br>
> )<br>
> )<br>
> and i18ntext4_.language=?<br>
> and (<br>
> i18ntext4_.id in (<br>
> select<br>
> names10_.id<br>
> from<br>
> I18NTEXT names10_<br>
> where<br>
> task0_.id=names10_.task_names_id<br>
> )<br>
> )<br>
> and subjects3_.language=?<br>
> and i18ntext5_.language=?<br>
> and (<br>
> i18ntext5_.id in (<br>
> select<br>
> descriptio11_.id<br>
> from<br>
> I18NTEXT descriptio11_<br>
> where<br>
> task0_.id=descriptio11_.task_descriptions_id<br>
> )<br>
> )<br>
> and (<br>
> task0_.status in (<br>
> 'Created' , 'Ready' , 'Reserved' , 'InProgress' ,<br>
> 'Suspended'<br>
> )<br>
> )<br>
> and (<br>
> task0_.expiration_time is null<br>
> )<br>
><br>
> Can someone throw some light on this? Do we have to have "Comment"<br>
> property set?<br>
><br>
> Thanks<br>
> Vijay<br>
><br>
> _______________________________________________<br>
> rules-users mailing list<br>
</div></div>> <a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><mailto:<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a>><br>
<div class="im">> <a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
><br>
><br>
><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 -<br>
><br>
<br>
<br>
<br>
<br>
</div>Disclaimer: <a href="http://www.kuleuven.be/cwis/email_disclaimer.htm" target="_blank">http://www.kuleuven.be/cwis/email_disclaimer.htm</a><br>
<div><div></div><div class="h5">_______________________________________________<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>
</div></div></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>