<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Potential wrong query for QueryTasksAssignedAsPotentialOwner
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/sasir">Sasi R</a> in <i>jBPM Development</i> - <a href="http://community.jboss.org/message/595132#595132">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Did any one notice that the human task query is returning wrong results when Comment and Skippable properties are left blank. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have a work flow with two human tasks one after another and for the first task user, am getting proper results however when the task is assigned to different user for second task, its pulling wrong data.I noticed that it created left join with the data in I18NTEXT table and is returning as many rows as the total count of rows in that table. In my case it is returning 38 rows(total count of I18NTEXT table)  instead of 1 row. If Comment and Skippable properties are blank, we have only 1 row in I18NTEXT instead of three rows and the below line in the query is creating havoc because there wont be rows with Task_Descriptions_Id and Task_Subjects_Id</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>and (i18ntext5_.language='en-UK' and (i18ntext5_.id in (select descriptio12_.id from I18NText descriptio12_ where task0_.id=descriptio12_.Task_Descriptions_Id)) </strong></p><p><strong><span style="color: #ff0000;">or (select count(descriptio13_.Task_Descriptions_Id) from I18NText descriptio13_ where task0_.id=descriptio13_.Task_Descriptions_Id)=0</span>) </strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Is this a known issue or is comemnt/Skippable properties are mandatory?</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/595132#595132">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2035">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>