<!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;">
HQL activity - parameters with EL evaluated values
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/jimmyb82">James Baker</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/561825#561825">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I've been searching around the documentation, tutorials and forums (for two days) to try to understand how I specify parameters to the HQL activity where the value is defined in the execution context.</p><p>I'm using jBPM 4.4 and JBoss EAP 5.0.</p><p>I've tried to specify my HQL node in various fashions bearing in mind there is a executionContext var called invoiceId and it is a Long: -</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml">
   <span class="jive-xml-tag"><hql name="Check invoice" g="258,162,117,52" var="invoice" unique="true"></span>
      <span class="jive-xml-tag"><query></span>from Invoice i where i.invoiceId = :invoiceId<span class="jive-xml-tag"></query></span>
          <span class="jive-xml-tag"><parameters></span>
             <span class="jive-xml-tag"><string name="invoiceId" value="#{invoiceId}" /></span>
         <span class="jive-xml-tag"></parameters></span>
      <span class="jive-xml-tag"><transition name="Check paid" to="Paid?" g="-62,-4"/></span>
   <span class="jive-xml-tag"></hql></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>This tries to pass the text as a String with the value "#{invoiceId}"</p><p>If i try to do this with a <long /> then it won't even deploy my process.</p><p>It seemed like i should use a reference as follows: -</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml">
   <span class="jive-xml-tag"><hql name="Check invoice" g="258,162,117,52" var="invoice" unique="true"></span>      <span class="jive-xml-tag"><query></span>from Invoice i where i.invoiceId = :invoiceId<span class="jive-xml-tag"></query></span>          <span class="jive-xml-tag"><parameters></span>
             <span class="jive-xml-tag"><ref object="invoiceId" /></span>
          <span class="jive-xml-tag"></parameters></span>
      <span class="jive-xml-tag"><transition name="Check paid" to="Paid?" g="-62,-4"/></span>
   <span class="jive-xml-tag"></hql></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="margin-top: 0pt; margin-right: 0pt; margin-bottom: 0pt; margin-left: 0pt; padding-top: 0pt; padding-right: 0pt; padding-bottom: 0pt; padding-left: 0pt; ">but this fails because org.jbpm.jpdl.internal.activity.HQLActivity uses the set named parameter methods and there is no way to pass anonymous parameters. It is an anonymous parameter because the ReferenceDescriptor class returns null for getName() and there is no way to specify a name for <ref /> under the <a class="jive-link-external-small" href="http://jbpm.org/4.4/jpdl">http://jbpm.org/4.4/jpdl</a> namespace.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="margin-top: 0pt; margin-right: 0pt; margin-bottom: 0pt; margin-left: 0pt; padding-top: 0pt; padding-right: 0pt; padding-bottom: 0pt; padding-left: 0pt; ">According to this feature request <a class="jive-link-external-small" href="https://jira.jboss.org/browse/JBPM-2279">https://jira.jboss.org/browse/JBPM-2279</a> we should be able to use EL but there is no reference in the documentation as to how.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="margin-top: 0pt; margin-right: 0pt; margin-bottom: 0pt; margin-left: 0pt; padding-top: 0pt; padding-right: 0pt; padding-bottom: 0pt; padding-left: 0pt; ">Can anyone help?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="margin-top: 0pt; margin-right: 0pt; margin-bottom: 0pt; margin-left: 0pt; padding-top: 0pt; padding-right: 0pt; padding-bottom: 0pt; padding-left: 0pt; ">P.S sorry if this comes out badly formatted, it's my first post.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="margin-top: 0pt; margin-right: 0pt; margin-bottom: 0pt; margin-left: 0pt; padding-top: 0pt; padding-right: 0pt; padding-bottom: 0pt; padding-left: 0pt; ">James</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/561825#561825">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://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>