Hi Vlad,<br><br>With the new decision table handling you could use the following template to do it:<br><br>Given a table as follows:<br><br><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"></span>
</font>
<table style="border: medium none ; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">exists, 21, 25</span></font></p>
</td>
<td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">, comprehensive</span></font></p>
</td>
</tr>
<tr>
<td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">not, 64, 100</span></font></p>
</td>
<td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">exists, comprehensive</span></font></p>
</td>
</tr>
</tbody></table>
<p>the following template does what you want:<br></p><p>template header<br>driver[]<br>policy[]<br><br>package This_is_a_ruleset;<br>#generated from Decision Table<br>import example.model.Driver;<br>import example.model.Policy
;<br><br>template "Driver policy"<br>driver<br>policy<br><br>rule "driver policy $row.rowNumber$"<br> when<br> $driver0$<br> Driver(age >= $driver1$, age <= $driver2$)<br> $policy0$
<br> Policy(type = "$policy1$")<br>then<br> //do smth<br>end<br>end template</p>the code to call it was:<br> public void testColumnKeywords() {<br> final ExternalSpreadsheetCompiler converter = new ExternalSpreadsheetCompiler();
<br> final String drl = converter.compile( "/data/TestWorkbook.xls", "/templates/test_keywords.drl",<br> InputType.XLS, 1, 1 ); // DT starts at Row 1, Column 1
<br> System.out.println(drl);<br> }<br><br>cheers<br>Steve<br><br><div><span class="gmail_quote">On 2/17/07, <b class="gmail_sendername">Olenin, Vladimir (MOH)</b> <<a href="mailto:Vladimir.Olenin@moh.gov.on.ca">
Vladimir.Olenin@moh.gov.on.ca</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hi,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I wonder if it's possible to pass some Column keywords
as parameters from template values, eg:</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<table style="border: medium none ; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0">
<tbody><tr>
<td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Condition</span></font></p>
</td>
<td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Condition</span></font></p>
</td>
</tr>
<tr>
<td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">$1 Driver</span></font></p>
</td>
<td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">$1 Policy</span></font></p>
</td>
</tr>
<tr>
<td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">age >= $2, age <= $3</span></font></p>
</td>
<td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">type</span></font></p>
</td>
</tr>
<tr>
<td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">exists, 21, 25</span></font></p>
</td>
<td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">, comprehensive</span></font></p>
</td>
</tr>
<tr>
<td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">not, 64, 100</span></font></p>
</td>
<td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 221.4pt;" valign="top" width="295">
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">exists, comprehensive</span></font></p>
</td>
</tr>
</tbody></table>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I'd expect the above table would generate two rules
like:</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Rule 1</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">When</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> exists
Driver (age >= 21, age <= 25)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Policy(type
== "comprehensive")</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Then</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> //
do smth</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">End</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Rule 2</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">When</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> not
Driver (age >= 64, age <= 100)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> exists
Policy (type == "comprehensive")</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">then</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> //
do smth</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">End</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">The above example is just a mock up derived from one of the
examples in the documentation to demonstrate the point (meaning, the rules
themselves might not make sense from business point of view or can be
implemented differently for this particular case).</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">So, any way to achieve this? Whether in current version
(3.0.x) or the upcoming release (3.2)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Vlad<strong><b><font face="Arial"><span style="font-family: Arial; font-weight: normal;"></span></font></b></strong></span></font></p>
</div>
</div>
<br>_______________________________________________<br>rules-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" 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><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