Hi Stephen,<br><br>You've made my afternoon ;)<br><br>The operation of "otherwise" is rather dumb. It does not have any understanding of what groups of rows it is meant to limit it's search of values to construct the "not in...." part.<br>
<br>As you have discovered, in your case, the Account column has no significance at all (to the web-guided decision table) although it does to the business analyst.<br><br>The immediate workaround would be to move each "group" to a different decision table; i.e. Account=1 and Account=2. I appreciate your example is probably a simplification of the real problem.<br>
<br>A better solution would be to furnish the "otherwise" value with the information it would need to determine it's search range. e.g. define "otherwise" with a key column of "Account". This is however an enhancement :(<br>
<br>Feel free to raise a JIRA (for GUVNOR)... no promises as to when I'll get a chance to do anything about it though :( <br><br>More complex requirements exist, for example given:-<br><br><div style="font-family:courier new,monospace">
Account Qualifier Currency CanTrade</div><div style="font-family:courier new,monospace"> 1 A EUR Y</div><div style="font-family:courier new,monospace"> 1 A USD Y</div><div style="font-family:courier new,monospace">
1 B IDR Y</div><div style="font-family:courier new,monospace"> 1 A Otherwise N</div><div style="font-family:courier new,monospace"> 2 A EUR Y</div><div style="font-family:courier new,monospace">
2 B USD Y</div><div style="font-family:courier new,monospace"> 2 B Otherwise N</div><br style="font-family:courier new,monospace">Account=1, Qualifier=A, Otherwise = not in ("EUR", "USD")<br>
Account=1, Qualifier=B, There is no otherwise<br>
Account=2, Qualifier=A, There is no otherwise<br>Account=2, Qualifier=B, Otherwise = not in ("USD") etc<br><br>So "Otherwise" will need a set of key\group columns.<br>
<br>With kind regards,<br><br>Mike<br><br>On 10 August 2012 15:50, Stephen Masters <span dir="ltr"><<a href="mailto:stephen.masters@me.com" target="_blank">stephen.masters@me.com</a>></span> wrote:<br><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Hi folks,<div><br></div><div>Given a decision table a bit like this (hopefully the monospaced font lays it out ok!):</div>
<div><br></div><div><font face="'Andale Mono'">Account Currency CanTrade</font></div><div><font face="'Andale Mono'"> 1 EUR Y</font></div><div><font face="'Andale Mono'"> 1 USD Y</font></div>
<div><span style="font-family:'Andale Mono'"> 1 IDR Y</span></div><div><font face="'Andale Mono'"> 1 Otherwise N</font></div><div><font face="'Andale Mono'"> 2 EUR Y</font></div>
<div><font face="'Andale Mono'"> 2 USD Y</font></div><div><font face="'Andale Mono'"> 2 Otherwise N</font></div><div><font face="'Andale Mono'"><br></font></div><div>LHS conditions are generated a bit like this:</div>
<div><span style="white-space:pre-wrap"> </span>account == 1, currency == 'EUR'</div><div><span style="white-space:pre-wrap"> </span>account == 1, currency == 'USD'</div><div> account == 1, currency == 'IDR'</div>
<div><span style="white-space:pre-wrap"> </span>account == 1, currency not in ('EUR', 'USD', 'IDR')</div><div><span style="white-space:pre-wrap"> </span>account == 2, currency == 'EUR'</div>
<div><span style="white-space:pre-wrap"> </span>account == 2, currency == 'USD'</div><div><span style="white-space:pre-wrap"> </span>account == 2, currency not in ('EUR', 'USD', 'IDR')</div>
<div><br></div><div>… which has the effect that for account 2, currency IDR, the rule does not fire. For the business analysts building the rules, this does't make a lot of sense, as they're expecting it to mean:</div>
<div><span style="white-space:pre-wrap"> </span>account == 2, currency not in ('EUR', 'USD')</div><div><br></div><div>Unfortunately this means that if a currency is permitted for one account, then a row must be added for every other account, indicating that the currency is not permitted.</div>
<div><br></div><div>I'm trying to achieve a sensible default (fire the rule to reject the trade) unless the currency is explicitly permitted.</div><div><br></div><div>Is there a decent mechanism for achieving this in a decision table?</div>
<div><br></div><div>One alternative I can think of is to create a technical rule which logically inserts a rejection which exists as long as this rule hash't fired. But I would really prefer to avoid doing anything like that, as I reckon it would be something of a maintenance nightmare.</div>
<div><br></div><div>Any thoughts?</div><div><br></div><div>Cheers,</div><div><br></div><div>Steve</div><div><br></div></div><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" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br></blockquote></div><br>