There's no easy option.
One solution is to merge the cell across from your condition column - if someone
duplicates a row they'll still have the value merged and it looks nicer than having a
column of N/A
The other approach I tend to use is just to set the column heading to be "must be
N/A" rather than retract the person.
Thomas
From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On
Behalf Of Bruno Freudensprung
Sent: 07 September 2011 12:19
To: Rules Users List
Subject: [rules-users] Decision table empty action cell
Hi,
I am implementing a decision table that looks like:
CONDITION
ACTION
$p : Person
name == "$1"
retract($p);
Person name
Retract the person
Fred
N/A
Kenny
N/A
The problem is generated rules have an empty RHS unless I put a string (here N/A) on each
line of the Action column, and I'd like to hide this column in my final spreadsheet.
Does anyone know a way to instruct Drools to generate the LHS even if the cell is empty?
If it is not possible, do you know any Excel trick to automatically fill the Action cell
with an arbitrary value (here N/A) when a new line is inserted in my table?
Many thanks in advance for your help,
Best regards,
Bruno.
________________________________
**************************************************************************************
This message is confidential and intended only for the addressee. If you have received
this message in error, please immediately notify the postmaster(a)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.
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
**************************************************************************************