<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’ve no idea why I said xml rather than drl – still too early in the morning.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">It should be there in the documentation, you use $1 and $2 (etc). But in this case why do you want to it’s easier for people to insert the values into two separate
columns.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">You want something like the following<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="688" style="width:516.0pt;margin-left:-1.15pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="387" nowrap="" valign="top" style="width:290.0pt;border:solid windowtext 1.0pt;background:#4F81BD;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:white">NAME<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border:solid windowtext 1.0pt;border-left:none;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">CONDITION<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border:solid windowtext 1.0pt;border-left:none;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">CONDITION<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="387" nowrap="" valign="top" style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;background:#4F81BD;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:white"> <o:p></o:p></span></p>
</td>
<td width="301" nowrap="" colspan="2" valign="top" style="width:226.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">f : Fact<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="387" nowrap="" valign="top" style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;background:#4F81BD;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:white"> <o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">value > $param<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Value <= $param<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="387" nowrap="" valign="top" style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;background:#B8CCE4;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Rule Name<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#B8CCE4;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Payment More than<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#B8CCE4;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Payment max<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="387" nowrap="" valign="top" style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">rule<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">1<o:p></o:p></span></p>
</td>
<td width="151" nowrap="" valign="top" style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">1500<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">This also has the benefit you can add catchall rules for the top and bottom by leaving the appropriate column empty - eg payment <= 0, or payment > 20000<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thomas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org]
<b>On Behalf Of </b>john@oa<br>
<b>Sent:</b> 12 September 2011 11:12<br>
<b>To:</b> rules-users@lists.jboss.org<br>
<b>Subject:</b> Re: [rules-users] Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Ah Okay,<br>
<br>
That kind of makes sense, although I can't seem to find any documentation on how to merge the condition column, i.e. to have to parameters in one column: Tried this to no avail (using the , as the implicit AND)<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="370" style="width:277.5pt">
<tbody>
<tr style="height:15.0pt">
<td width="371" style="width:278.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">Payment<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">value > $param1, value <= $param2<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">Payment In Range<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt"></td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">0, 1500<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">1500, 2000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">2000, 3000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">3000, 4000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">4000, 5000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">5000, 10000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">10000, 15000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">15000, 20000<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal">20000<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Mon, Sep 12, 2011 at 8:21 AM, Swindells, Thomas [via Drools] <<a href="/user/SendEmail.jtp?type=node&node=3329292&i=0" target="_top">[hidden email]</a>> wrote:<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;color:#1F497D">If you dump out the xml it converts the spreadsheet to you can see what the resulting DRL is.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;color:#1F497D">Mantis is right in what the output is – if you don’t merge the condition column you’ll get a drl as below (If there exists a Condition
(c1) such that its payment > $param(1) AND there exists a Condition (c2) such that its payment <= $param(2).</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;color:#1F497D">If you merge the condition column the constraints apply to the same Condition object with the comma being the implicit and (if there
exists a Condition c1 such that its payment > $param(1) AND its payment <= $param(2).</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;color:#1F497D">Thomas</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;color:#1F497D"> </span><o:p></o:p></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt">
<a href="http://user/SendEmail.jtp?type=node&node=3328970&i=0" target="_blank">[hidden email]</a> [mailto:<a href="http://user/SendEmail.jtp?type=node&node=3328970&i=1" target="_blank">[hidden email]</a>]
<b>On Behalf Of </b>john@oa<br>
<b>Sent:</b> 09 September 2011 16:28<br>
<b>To:</b> <a href="http://user/SendEmail.jtp?type=node&node=3328970&i=2" target="_blank">
[hidden email]</a><br>
<b>Subject:</b> Re: [rules-users] Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total</span><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Thanks Manstis<br>
<br>
Actually I found that the issue was caused by me having incorrectly placed the "RuleTable" statement in the spreadsheet, I believe the CONDITION's in the columns are by default: AND joined.<o:p></o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Fri, Sep 9, 2011 at 3:57 PM, manstis [via Drools] <<a href="http://user/SendEmail.jtp?type=node&node=3323194&i=0" target="_blank">[hidden email]</a>> wrote:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Does your "Condition" span the two columns with the payment $param? e.g.<br>
<br>
<span style="font-family:"Courier New"">| Condition | <br>
|-----------------+------------------|<br>
|payment > $param | payment <= $param|<br>
|-----------------+------------------|</span><br>
<br>
Otherwise you are creating rules that check the following:-<br>
<br>
<span style="font-family:"Courier New"">when<br>
Condition(payment > )<br>
then<br>
...<br>
<br>
when<br>
Condition(payment > 1000)<br>
then<br>
...<br>
</span><br>
Whereas you really require:-<br>
<br>
<span style="font-family:"Courier New"">when<br>
Condition(payment >0, payment <= 1000)<br>
then<br>
...</span><br>
<br>
etc<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">2011/9/9 john@oa <<a href="http://user/SendEmail.jtp?type=node&node=3323110&i=0" target="_blank">[hidden email]</a>><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Thanks Iaune<br>
<br>
That is really helpful. Yes, I need the ranges to be mutually exclusive, what is the easiest way to do that? Feel a bit cheeky asking another question, but you seem to know what you are talking about! I have tried adding two conditions to enforce the range,
but that doesn't seem to work - see below. I still get multiple rules firing. Also can you recommend any good resources for learning all of this, apart from the online documentation? Would you know if any of the Drools books are any good?<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="428" style="width:321.0pt">
<tbody>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td width="215" style="width:161.0pt;padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">payment > $param<o:p></o:p></p>
</td>
<td width="215" style="width:161.0pt;padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">payment <= $param<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Payment Greater Than<o:p></o:p></p>
</td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Payment Less Than or Equal To<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0<o:p></o:p></p>
</td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">1500<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">1500<o:p></o:p></p>
</td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">2000<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">2000<o:p></o:p></p>
</td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">3000<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">3000<o:p></o:p></p>
</td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">4000<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"></td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"></td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"></td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"></td>
</tr>
<tr style="min-height:15.0pt;min-height:15.0pt">
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Fri, Sep 9, 2011 at 2:22 PM, laune [via Drools] <<a href="http://user/SendEmail.jtp?type=node&node=3323074&i=0" target="_blank">[hidden email]</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.5pt;padding:0cm 0cm 0cm 12.0pt;margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt">The error you get is due to the second condition (application: Application()) not being included in the generated rules. Empty cell means: the column's snippet is not included in the
rule. <br>
<br>
Since you don't have a constraint for Application() you can employ a trick: remove the column and prefix the text application: Application() to the text in cell C7.<br>
<br>
In Rule 1, do you really want to test whether a payment is not greater than zero?<br>
<br>
Do you realize that Rules 2 and 3 would both fire for certain payment amounts?<br>
<br>
You can update a String field. To concatenate, use<br>
x.setString( x.getString() + "whatever" );<br>
<br>
-W<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On 9 September 2011 14:08, john@oa <<a href="http://user/SendEmail.jtp?type=node&node=3322896&i=0" target="_blank">[hidden email]</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.5pt;padding:0cm 0cm 0cm 12.0pt;margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Guvnor: guvnor-5.2.0.Final-tomcat-6.0<br>
<br>
Hi<br>
<br>
I am a Drools Newbie and I have an integer field called score that I need to<br>
add to when a rule matches in a spreadsheet decision table. i.e. the score<br>
field should hold a running total of all scores that are matched. However,<br>
I can't even update the field in the table. I have attached the spreadsheet<br>
for review. In this spreadsheet I am simply trying to set the score, and<br>
that is failing with:<br>
<br>
DScoringTable] Rule Compilation error application cannot be resolved<br>
<br>
My goal is to have different decision tables that will all need to update<br>
the same score, and keep a running total of the total score.<br>
<br>
Any help very much appreciated! I hope that I am just missing something<br>
obvious.<br>
<a href="http://drools.46999.n3.nabble.com/file/n3322713/demo-score-sheet.xls%0Ademo-score-sheet.xls" target="_blank">http://drools.46999.n3.nabble.com/file/n3322713/demo-score-sheet.xls<br>
demo-score-sheet.xls</a><br>
<br>
In future I may wish to also update a String field and keep concatenating to<br>
that field, is this possible?<br>
<br>
John<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#888888"><br>
<br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322713.html" target="_blank">
http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322713.html</a><br>
Sent from the Drools: User forum mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list</span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#888888"><a href="http://user/SendEmail.jtp?type=node&node=3322896&i=1" target="_blank">[hidden email]</a></span><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#888888"><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a></span><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
<br>
_______________________________________________ <br>
rules-users mailing list <br>
<a href="http://user/SendEmail.jtp?type=node&node=3322896&i=2" target="_blank">[hidden email]</a>
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" noshade="" style="color:#CCCCCC" align="center">
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;color:#444444">If you reply to this email, your message will be added to the discussion below:</span></b><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;color:#444444"><a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322896.html" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322896.html</a>
</span><o:p></o:p></p>
</div>
<div style="margin-top:4.8pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:8.5pt;color:#666666">To unsubscribe from Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total, click here.
</span><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
</div>
</div>
<div>
<div class="MsoNormal">
<hr size="2" width="300" style="width:225.0pt" align="left">
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">View this message in context:
<a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323074.html" target="_blank">
Re: [rules-users] Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total</a><o:p></o:p></p>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html" target="_blank">
Drools: User forum mailing list archive</a> at Nabble.com.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="http://user/SendEmail.jtp?type=node&node=3323110&i=1" target="_blank">[hidden email]</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><br>
<br>
_______________________________________________ <br>
rules-users mailing list <br>
<a href="http://user/SendEmail.jtp?type=node&node=3323110&i=2" target="_blank">[hidden email]</a>
<br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" noshade="" style="color:#CCCCCC" align="center">
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;color:#444444">If you reply to this email, your message will be added to the discussion below:</span></b><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;color:#444444"><a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323110.html" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323110.html</a>
</span><o:p></o:p></p>
</div>
<div>
<div>
<div style="margin-top:4.8pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:8.5pt;color:#666666">To unsubscribe from Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total, click here.
</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
<div>
<div class="MsoNormal">
<hr size="2" width="300" style="width:225.0pt" align="left">
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">View this message in context:
<a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323194.html" target="_blank">
Re: [rules-users] Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total</a><br>
Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html" target="_blank">
Drools: User forum mailing list archive</a> at Nabble.com.<o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:gray"><br>
**************************************************************************************<br>
This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the
<a href="http://user/SendEmail.jtp?type=node&node=3328970&i=3" target="_blank">[hidden email]</a> and delete it from your system as well as any copies. The content of e-mails as well as traffic data may be monitored by NDS for employment and security purposes.
To protect the environment please do not print this e-mail unless necessary.<br>
<br>
NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603 8808 40-00<br>
**************************************************************************************</span><o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________ <br>
rules-users mailing list <br>
<a href="http://user/SendEmail.jtp?type=node&node=3328970&i=4" target="_blank">[hidden email]</a>
<br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br>
<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" noshade="" style="color:#CCCCCC" align="center">
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#444444">If you reply to this email, your message will be added to the discussion below:<o:p></o:p></span></b></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#444444"><a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3328970.html" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3328970.html</a>
<o:p></o:p></span></p>
</div>
<div>
<div>
<div style="margin-top:4.8pt">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Tahoma","sans-serif";color:#666666">To unsubscribe from Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total,
<a href="" target="_blank">click here</a>. <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div class="MsoNormal">
<hr size="2" width="300" style="width:225.0pt" align="left">
</div>
<p class="MsoNormal">View this message in context: <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3329292.html">
Re: [rules-users] Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total</a><br>
Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html">
Drools: User forum mailing list archive</a> at Nabble.com.<o:p></o:p></p>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
**************************************************************************************<br>
This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the postmaster@nds.com and delete it from your system as well as any copies. The content of e-mails as well as traffic data
may be monitored by NDS for employment and security purposes. To protect the environment please do not print this e-mail unless necessary.<br>
<br>
NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603 8808 40-00<br>
**************************************************************************************<br>
</font>
</body>
</html>