OK, you could add the "Date Range" columns to the spreadsheet, but I see your point.<br><br>Your problem still seems more like a version control problem than rules: If your rule author has made 5 versions of the decision table how are you proposing to identify which version needs to be applied to a given Product? Products will still need to have an "effective date" and you are still going to need a mechanism to associate a given Product with a given version of the rules. How are you going to achieve this?<br>
<br>If you are to lookup the appropriate version of the DRL why not lookup the appropriate dtable instead? If you're saying your rule authors want to simply change a single "live" version of a single spreadsheet (ha, sounds like a training issue to me) then when were you going to extract and save the DRL you first asked about?<br>
<br>With kind regards,<br><br>Mike<br><br><div class="gmail_quote">On 18 April 2011 10:41, Riyaz Saiyed <span dir="ltr"><<a href="mailto:Riyaz.saiyed@emirates.com">Riyaz.saiyed@emirates.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
The idea is to store these price rules as xls decision table.<br>
<br>
The admin (non technical guy) will periodically update the xls just to<br>
change the price.<br>
<br>
For example for the same date range - 1-Jan-2011 to 31-Mar-2011, price can<br>
be increased of decrease depending on the volume of requests. So creating<br>
multiple version (more entries in xls) may be time consuming for him. He<br>
will prefer to do "find and replace" to update the price.<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/Drools-Decision-Table-tp2830218p2833685.html" target="_blank">http://drools.46999.n3.nabble.com/Drools-Decision-Table-tp2830218p2833685.html</a><br>
</font><div><div></div><div class="h5">Sent from the Drools: User forum mailing list archive at Nabble.com.<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>
</div></div></blockquote></div><br>