passing null as a condition param

[Qbyte Consulting]

Hi,

Is there a way to pass a null to the conditions param value so the rule isn't encoded like this? $p: PromotionApplication(promotionCode == "null")

Butt like this $p: PromotionApplication(promotionCode == null)

John

[Nicolas Héron]

Hi,

you found the solution yourself :)

$p: PromotionApplication(promotionCode == null)

Nicolas

[Qbyte Consulting]

sorry I forgot to mention the null value is a param from an Excel decision table, that's why it gets quoted

[Toni Rikkola]

If you can't move the == null to the column header, you might have to make a separate column.

if plain "promotionCode == null" in the header does not work try "promotionCode == null?" 

The support for the end ? was added in recent versions so depends what you are using if it works or not.

Toni

--
You received this message because you are subscribed to the Google Groups "Drools Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to drools-usage...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/fbc7a24c-290e-4fc7-868b-9925e5d2714dn%40googlegroups.com.

[Afzal Shaik]

Hi I too have the same requirement where my drools decision table dont have value in a column means it wont be considered in the when condition
But i want to show as null in drl file  for the attribute which is empty in decision table.

if plain "promotionCode == null" in the header does not work try "promotionCode == null?" 

this didnt worked for me while passing in condition over the top of all row data

Kindly need help regarding this

[Toni Rikkola]

With XLS decision tables it is possible to make a new column where the header has no parameters and then when that column needs to be included, just use X in the cell.

Toni

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/f5dc07c2-d320-4491-b382-471893e48f7en%40googlegroups.com.

[Afzal Shaik]

but in my requirement a cell can be empty so i dont want to give any dummy values such as X inside but need to handle it somehow

[Afzal Shaik]

Based on your approach after giving value as X
when
$rule: ServiceRuleRequest(validateHierarchy(hierarchy,"Some value"), validateRegion(region,"Some value"), validateType(Type,"X"))
then
Object $obj = new Object();
$obj.setRequirement("Value to be set");
        $obj.setTask("Task to be set");

But i want to show my rule like this where Type is null by default
when
$rule: ServiceRuleRequest(validateHierarchy(hierarchy,"Some value"), validateRegion(region,"Some value"), validateType(Type,null))
then
Object $obj = new Object();
$obj.setRequirement("Value to be set");
        $obj.setTask("Task to be set");

[Toni Rikkola]

Does typing in null work? If "" quotes are added in the cell this should work. Another option is to make another column for "validateType(Type,null)" where the null is set in the header and Type is set in the column cells.

Toni

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/0ddb73af-38ba-4288-a953-2a074d29d273n%40googlegroups.com.

[Afzal Shaik]

Hi,
Thanks for the reply Toni,
giving null or " " in template cells is not a part of my requirement,
The cells in a condition are blank means drools itself should convert those while compiling into drl file  to null,
Is there any way to do it

[Toni Rikkola]

For this, I think you need to fork the drools-decisiontables and change the behaviour to this.

Toni

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/541d71ae-71a7-4d60-a807-d963de1fb56an%40googlegroups.com.

[Afzal Shaik]

Hi Toni,
Can you please give me brief walk through in the souce stating what are the changes need to be done and in which area to handle null before compiling the xls Drools template
to .drl file and pushing in working memory, so that i can check with the same and work on it.

Regards Afzal Shaik
Thank You.

[Afzal Shaik]

Hi Toni,
I have gone through this code  drools-decisiontables  but the version of this source is 8.45.0 SNAPSHOT,
We are currently using 7.73.0-Final version,
Is there any way can we get the 7.73.0-Final version source. 

Thanks in Advance.
Regards Afzal Shaik,

[Toni Rikkola]

Sure, you should build on top of the 7.73.0-Final tag then.

drools/drools-decisiontables at 7.73.0.Final · kiegroup/drools (github.com)

Toni

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/c7a824bb-b297-40e1-b7f7-778ad5b701f2n%40googlegroups.com.

[Afzal Shaik]

Hi Toni,
Thanks for providing the source,
Let me look into it.

Regards Afzal Shaik.

[Afzal Shaik]

Hi Toni,
I have gone through the above source and made some changes in excel parser.java where
if(cell == null) {
continue;
}
I am altering it and making custom condition and setting some value if cell is null in my rule table 
after imports and rule table condition, Action keywords
I am getting this exception please guide me with this  
Caused by: org.drools.template.parser.DecisionTableParseException: Unexpected content "Null" in cell C6, leave this cell blank
at org.drools.decisiontable.parser.ActionType.addTemplate(ActionType.java:183)
at org.drools.decisiontable.parser.DefaultRuleSheetListener.codeRow(DefaultRuleSheetListener.java:586)
at org.drools.decisiontable.parser.DefaultRuleSheetListener.processRuleCell(DefaultRuleSheetListener.java:495)
at org.drools.decisiontable.parser.DefaultRuleSheetListener.newCell(DefaultRuleSheetListener.java:363)
at org.drools.decisiontable.parser.xls.ExcelParser.newCell(ExcelParser.java:140)
at org.drools.decisiontable.parser.xls.ExcelParser.processSheet(ExcelParser.java:160)
at org.drools.decisiontable.parser.xls.ExcelParser.parseWorkbook(ExcelParser.java:358)
at org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:114)
at org.drools.decisiontable.SpreadsheetCompiler.parseResource(SpreadsheetCompiler.java:133)
at org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:120)
at org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:93)
now getting this