<!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="https://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;">
Re: Problem with Human Task query TasksAssignedAsPotentialOwnerByStatus
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/fdernb">Fred DERNBACH</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/792579#792579">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I confirm the issue. Oracle does not receive proper binding variable for status list. below is the Oracle trace of the hibernate query. See in <strong>bold</strong>.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>SQL_ID  1fnn7qr6kqp5y, child number 1</p><p>-------------------------------------</p><p>select user2_.id as id175_0_, user1_.id as id175_1_, task0_.id as col_0_0_, </p><p>task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_, </p><p>descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_, </p><p>task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as </p><p>col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_, </p><p>task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer </p><p>join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join </p><p>OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText </p><p>subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on </p><p>task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on </p><p>task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0 </p><p>)and((organizati6_.id=:1 )or(organi</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Plan hash value: 2720357931</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>---------------------------------------------------------------------------------------------------------</p><p>| Id  | Operation                 | Name                        | Rows  | Bytes | Cost (%CPU)| Time     |</p><p>---------------------------------------------------------------------------------------------------------</p><p>|   0 | SELECT STATEMENT          |                             |       |       |    40 (100)|          |</p><p>|*  1 |  FILTER                   |                             |       |       |            |          |</p><p>|*  2 |   HASH JOIN OUTER         |                             |     1 |  7594 |    40   (5)| 00:00:04 |</p><p>|*  3 |    HASH JOIN OUTER        |                             |     1 |  5450 |    33   (7)| 00:00:04 |</p><p>|*  4 |     HASH JOIN OUTER       |                             |     1 |  3306 |    25   (4)| 00:00:03 |</p><p>|   5 |      NESTED LOOPS         |                             |     1 |  1162 |    18   (6)| 00:00:02 |</p><p>|*  6 |       HASH JOIN           |                             |     1 |  1033 |    17   (6)| 00:00:02 |</p><p>|   7 |        NESTED LOOPS OUTER |                             |     1 |   891 |     9   (0)| 00:00:01 |</p><p>|   8 |         NESTED LOOPS OUTER|                             |     1 |   762 |     8   (0)| 00:00:01 |</p><p>|*  9 |          TABLE ACCESS FULL| TASK                        |     1 |   633 |     7   (0)| 00:00:01 |</p><p>|* 10 |          INDEX UNIQUE SCAN| SYS_C00144479               |     1 |   129 |     1   (0)| 00:00:01 |</p><p>|* 11 |         INDEX UNIQUE SCAN | SYS_C00144479               |     1 |   129 |     1   (0)| 00:00:01 |</p><p>|  12 |        SORT UNIQUE        |                             |    10 |  1420 |     7   (0)| 00:00:01 |</p><p>|* 13 |         TABLE ACCESS FULL | PEOPLEASSIGNMENTS_POTOWNERS |    10 |  1420 |     7   (0)| 00:00:01 |</p><p>|* 14 |       INDEX UNIQUE SCAN   | SYS_C00144479               |     1 |   129 |     1   (0)| 00:00:01 |</p><p>|  15 |      TABLE ACCESS FULL    | I18NTEXT                    |    30 | 64320 |     7   (0)| 00:00:01 |</p><p>|  16 |     TABLE ACCESS FULL     | I18NTEXT                    |    30 | 64320 |     7   (0)| 00:00:01 |</p><p>|  17 |    TABLE ACCESS FULL      | I18NTEXT                    |    30 | 64320 |     7   (0)| 00:00:01 |</p><p>|  18 |   SORT AGGREGATE          |                             |     1 |    13 |            |          |</p><p>|* 19 |    TABLE ACCESS FULL      | I18NTEXT                    |     1 |    13 |     7   (0)| 00:00:01 |</p><p>|  20 |     SORT AGGREGATE        |                             |     1 |    13 |            |          |</p><p>|* 21 |      TABLE ACCESS FULL    | I18NTEXT                    |     1 |    13 |     7   (0)| 00:00:01 |</p><p>|  22 |       SORT AGGREGATE      |                             |     1 |    13 |            |          |</p><p>|* 23 |        TABLE ACCESS FULL  | I18NTEXT                    |     1 |    13 |     7   (0)| 00:00:01 |</p><p>---------------------------------------------------------------------------------------------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Query Block Name / Object Alias (identified by operation id):</p><p>-------------------------------------------------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   1 - SEL$1B69B172</p><p>   9 - SEL$1B69B172 / TASK0_@SEL$2</p><p>  10 - SEL$1B69B172 / USER2_@SEL$3</p><p>  11 - SEL$1B69B172 / USER1_@SEL$1</p><p>  13 - SEL$1B69B172 / POTENTIALO7_@SEL$12</p><p>  14 - SEL$1B69B172 / ORGANIZATI6_@SEL$11</p><p>  15 - SEL$1B69B172 / NAMES5_@SEL$9</p><p>  16 - SEL$1B69B172 / DESCRIPTIO4_@SEL$7</p><p>  17 - SEL$1B69B172 / SUBJECTS3_@SEL$5</p><p>  18 - SEL$13      </p><p>  19 - SEL$13       / NAMES8_@SEL$13</p><p>  20 - SEL$14      </p><p>  21 - SEL$14       / SUBJECTS9_@SEL$14</p><p>  22 - SEL$15      </p><p>  23 - SEL$15       / DESCRIPTIO10_@SEL$15</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Outline Data</p><p>-------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  /*+</p><p>      BEGIN_OUTLINE_DATA</p><p>      IGNORE_OPTIM_EMBEDDED_HINTS</p><p>      OPTIMIZER_FEATURES_ENABLE('10.2.0.4')</p><p>      OPT_PARAM('_optimizer_connect_by_cost_based' 'false')</p><p>      OPT_PARAM('star_transformation_enabled' 'temp_disable')</p><p>      OPT_PARAM('optimizer_index_caching' 50)</p><p>      ALL_ROWS</p><p>      OUTLINE_LEAF(@"SEL$13")</p><p>      OUTLINE_LEAF(@"SEL$14")</p><p>      OUTLINE_LEAF(@"SEL$15")</p><p>      OUTLINE_LEAF(@"SEL$1B69B172")</p><p>      UNNEST(@"SEL$12")</p><p>      OUTLINE(@"SEL$13")</p><p>      OUTLINE(@"SEL$14")</p><p>      OUTLINE(@"SEL$15")</p><p>      OUTLINE(@"SEL$48266A83")</p><p>      MERGE(@"SEL$B97648DD")</p><p>      OUTLINE(@"SEL$12")</p><p>      OUTLINE(@"SEL$11")</p><p>      OUTLINE(@"SEL$B97648DD")</p><p>      MERGE(@"SEL$096E5AED")</p><p>      MERGE(@"SEL$9")</p><p>      OUTLINE(@"SEL$10")</p><p>      OUTLINE(@"SEL$096E5AED")</p><p>      MERGE(@"SEL$15E987C1")</p><p>      MERGE(@"SEL$7")</p><p>      OUTLINE(@"SEL$9")</p><p>      OUTLINE(@"SEL$8")</p><p>      OUTLINE(@"SEL$15E987C1")</p><p>      MERGE(@"SEL$5")</p><p>      MERGE(@"SEL$7237DA6D")</p><p>      OUTLINE(@"SEL$7")</p><p>      OUTLINE(@"SEL$6")</p><p>      OUTLINE(@"SEL$5")</p><p>      OUTLINE(@"SEL$7237DA6D")</p><p>      MERGE(@"SEL$3")</p><p>      MERGE(@"SEL$58A6D7F6")</p><p>      OUTLINE(@"SEL$4")</p><p>      OUTLINE(@"SEL$3")</p><p>      OUTLINE(@"SEL$58A6D7F6")</p><p>      MERGE(@"SEL$1")</p><p>      OUTLINE(@"SEL$2")</p><p>      OUTLINE(@"SEL$1")</p><p>      FULL(@"SEL$1B69B172" "TASK0_"@"SEL$2")</p><p>      INDEX(@"SEL$1B69B172" "USER2_"@"SEL$3" ("ORGANIZATIONALENTITY"."ID"))</p><p>      INDEX(@"SEL$1B69B172" "USER1_"@"SEL$1" ("ORGANIZATIONALENTITY"."ID"))</p><p>      FULL(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")</p><p>      INDEX(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11" ("ORGANIZATIONALENTITY"."ID"))</p><p>      FULL(@"SEL$1B69B172" "NAMES5_"@"SEL$9")</p><p>      FULL(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")</p><p>      FULL(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")</p><p>      LEADING(@"SEL$1B69B172" "TASK0_"@"SEL$2" "USER2_"@"SEL$3" "USER1_"@"SEL$1" </p><p>              "POTENTIALO7_"@"SEL$12" "ORGANIZATI6_"@"SEL$11" "NAMES5_"@"SEL$9" "DESCRIPTIO4_"@"SEL$7" </p><p>              "SUBJECTS3_"@"SEL$5")</p><p>      USE_NL(@"SEL$1B69B172" "USER2_"@"SEL$3")</p><p>      USE_NL(@"SEL$1B69B172" "USER1_"@"SEL$1")</p><p>      USE_HASH(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")</p><p>      USE_NL(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11")</p><p>      USE_HASH(@"SEL$1B69B172" "NAMES5_"@"SEL$9")</p><p>      USE_HASH(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")</p><p>      USE_HASH(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")</p><p>      FULL(@"SEL$15" "DESCRIPTIO10_"@"SEL$15")</p><p>      FULL(@"SEL$14" "SUBJECTS9_"@"SEL$14")</p><p>      FULL(@"SEL$13" "NAMES8_"@"SEL$13")</p><p>      END_OUTLINE_DATA</p><p>  */</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Peeked Binds (identified by position):</p><p>--------------------------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   1 - :1 (VARCHAR2(30), CSID=46): 'ITCH'</p><p>   2 - :2 (VARCHAR2(30), CSID=46): 'SECURITY_GLOBAL'</p><p>   3 - :3 (VARCHAR2(30), CSID=46): 'SECURITY_AUTHORITY'</p><p><strong>   7 - :7 (RAW(30)): aced00057e7200146f72672e6a62706d2e7461736b2e537461747573000000000000000012000078720</strong></p><p><strong>       00e6a6176612e6c616e672e456e756d000000000000000012000078707400055265616479</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Predicate Information (identified by operation id):</p><p>---------------------------------------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   1 - filter((("NAMES5_"."LANGUAGE"=:4 OR =0) AND ("SUBJECTS3_"."LANGUAGE"=:5 OR =0) AND </p><p>              ("DESCRIPTIO4_"."LANGUAGE"=:6 OR =0)))</p><p>   2 - access("TASK0_"."ID"="SUBJECTS3_"."TASK_SUBJECTS_ID")</p><p>   3 - access("TASK0_"."ID"="DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID")</p><p>   4 - access("TASK0_"."ID"="NAMES5_"."TASK_NAMES_ID")</p><p>   6 - access("TASK0_"."ID"="POTENTIALO7_"."TASK_ID")</p><p>   9 - filter(("TASK0_"."EXPIRATIONTIME" IS NULL AND "TASK0_"."ARCHIVED"=0 AND </p><p>              "TASK0_"."STATUS"=RAWTOHEX(:7)))</p><p>  10 - access("TASK0_"."ACTUALOWNER_ID"="USER2_"."ID")</p><p>  11 - access("TASK0_"."CREATEDBY_ID"="USER1_"."ID")</p><p>  13 - filter(("POTENTIALO7_"."ENTITY_ID"=:1 OR "POTENTIALO7_"."ENTITY_ID"=:2 OR </p><p>              "POTENTIALO7_"."ENTITY_ID"=:3))</p><p>  14 - access("ORGANIZATI6_"."ID"="POTENTIALO7_"."ENTITY_ID")</p><p>       filter(("ORGANIZATI6_"."ID"=:1 OR "ORGANIZATI6_"."ID"=:2 OR "ORGANIZATI6_"."ID"=:3))</p><p>  19 - filter("NAMES8_"."TASK_NAMES_ID"=:B1)</p><p>  21 - filter("SUBJECTS9_"."TASK_SUBJECTS_ID"=:B1)</p><p>  23 - filter("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"=:B1)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Column Projection Information (identified by operation id):</p><p>-----------------------------------------------------------</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   1 - "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000], "NAMES5_"."TEXT"[LOB,4000], </p><p>       "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255], </p><p>       "SUBJECTS3_"."TEXT"[LOB,4000]</p><p>   2 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000], </p><p>       "NAMES5_"."TEXT"[LOB,4000], "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255], </p><p>       "NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255], </p><p>       "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000]</p><p>   3 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22], </p><p>       "NAMES5_"."TEXT"[LOB,4000], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22], </p><p>       "ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22], </p><p>       "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255], </p><p>       "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10], </p><p>       "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10], </p><p>       "NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255], </p><p>       "DESCRIPTIO4_"."TEXT"[LOB,4000]</p><p>   4 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22], </p><p>       "ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22], </p><p>       "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255], </p><p>       "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10], </p><p>       "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10], </p><p>       "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000]</p><p>   5 - "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22], </p><p>       "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255], </p><p>       "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10], </p><p>       "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10], </p><p>       "ORGANIZATI6_"."ID"[VARCHAR2,255]</p><p>   6 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22], </p><p>       "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255], </p><p>       "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10], </p><p>       "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]</p><p>   7 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255], </p><p>       "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10], </p><p>       "USER1_"."ID"[VARCHAR2,255]</p><p>   8 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255], </p><p>       "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]</p><p>   9 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22], </p><p>       "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11], </p><p>       "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255], </p><p>       "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22], </p><p>       "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], </p><p>       "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255]</p><p>  10 - "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]</p><p>  11 - "USER1_".ROWID[ROWID,10], "USER1_"."ID"[VARCHAR2,255]</p><p>  12 - (#keys=2) "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]</p><p>  13 - "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]</p><p>  14 - "ORGANIZATI6_".ROWID[ROWID,10], "ORGANIZATI6_"."ID"[VARCHAR2,255]</p><p>  15 - "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000], </p><p>       "NAMES5_"."TASK_NAMES_ID"[NUMBER,22]</p><p>  16 - "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."TEXT"[LOB,4000], </p><p>       "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]</p><p>  17 - "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000], </p><p>       "SUBJECTS3_"."TASK_SUBJECTS_ID"[NUMBER,22]</p><p>  18 - (#keys=0) COUNT("NAMES8_"."TASK_NAMES_ID")[22]</p><p>  19 - "NAMES8_"."TASK_NAMES_ID"[NUMBER,22]</p><p>  20 - (#keys=0) COUNT("SUBJECTS9_"."TASK_SUBJECTS_ID")[22]</p><p>  21 - "SUBJECTS9_"."TASK_SUBJECTS_ID"[NUMBER,22]</p><p>  22 - (#keys=0) COUNT("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID")[22]</p><p>  23 - "DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Note</p><p>-----</p><p>   - dynamic sampling used for this statement</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    </p><p>    Subject</p><p>    Requete Task</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/792579#792579">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>