Hi James,<br><br>The from keyword doesn&#39;t assert the list returned from lookupDAO.getLookupValues - it asserts each value. So I think you want:<br><br>rule ...<br>when<br> &nbsp; &nbsp;// getting the codes from the table<br> &nbsp; $shCode : String() from 
lookupDAO.getLookupValues(&quot;MILT.CUSTNO&quot; )<br><br> &nbsp; &nbsp;// matching the objects if the code<br> &nbsp; &nbsp;$gateIN : RKEM_Move( CUSTOMER_REFERENCE_NUMBER matches &quot;^HX.*&quot;,<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ACTIVITY_LOCATION matches &quot;^US.*&quot;,
<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SH_CODE == $shCode )<br>then<br> &nbsp; // do something<br>end<br><br>cheers<br>Steve<br><br><div><span class="gmail_quote">On 3/9/07, <b class="gmail_sendername">jdepaul</b> &lt;
<a href="mailto:jjdepaul@us.ibm.com">jjdepaul@us.ibm.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>Let me clarify my intentions:&nbsp;&nbsp;the 
lookupDAO.getLookupValues(..) returns an<br>ArrayList of String values.&nbsp;&nbsp;I need to make sure that SH_CODES attribute<br>(String) of the RKEM_MOVE object&nbsp;&nbsp;exists in that list of Strings.&nbsp;&nbsp;Having<br>trouble with this syntax:
<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;when<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Get a list of Strings in ArrayList form from the DB table<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$lookupList : List() from lookupDAO.getLookupValues( &quot;MILT.CUSTNO&quot; )<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Now do the comparison...
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RKEM_Move (CUSTOMER_REFERENCE_NUMBER matches &quot;^HX.*&quot;,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ACTIVITY_LOCATION matches &quot;^US.*&quot;,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$lookupList contains SH_CODE) // &lt;-- if SH_CODE exists in the
<br>$lookupList from DAO...<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;then...<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(&quot;Found a Match Rule - about to inovke Service...&quot;);<br><br>end<br><br><br>Please help -<br><br>James<br><br><br>Edson Tirelli-3 wrote:
<br>&gt;<br>&gt;&nbsp;&nbsp; I&#39;m not sure I understood what you are trying to do<br><br>--<br>View this message in context: <a href="http://www.nabble.com/Rules-with-Lookup-Tables...-tf3329159.html#a9374192">http://www.nabble.com/Rules-with-Lookup-Tables...-tf3329159.html#a9374192
</a><br>Sent from the drools - user mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br><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">https://lists.jboss.org/mailman/listinfo/rules-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>Steven Williams
<br><br>Supervising Consultant<br><br>Object Consulting<br>Office: 8615 4500 Mob: 0439 898 668 Fax: 8615 4501<br><a href="mailto:stevenw@objectconsulting.com.au">stevenw@objectconsulting.com.au</a><br><a href="http://www.objectconsulting.com.au">
www.objectconsulting.com.au</a><br><br>consulting | development | training | support<br>our experience makes the difference