Lectori salutem, Gurus salutem,
I'm using 7.3 sp03. I would like to achieve the following with BRM (bit simplified):
a parameter, ABC, is passed to a ruleSetService, and needs to be evaluated.
The table is as follows:
ABC startDate endDate Value
1 01-01-2011 31-12-2011 A
1 01-01-2012 31-12-2012 B
2 01-01-2011 31-12-2011 X
4 01-01-2012 31-12-2012 Y
When ABC-value '1' is passed to the ruleSetService in the table the first row needs to be selected. CurrentDate (24-11-2011) is in between 01-01-2011 and 31-12-2011, making this the valid row. The value that should be returned is A.
Beginning of next year it should change to B.
How should I set this up in BRM?
Thanks in advance!
Martijn.