Why not add EmployeeTypeSalary objects to Working Memory, then you only need one static rule:-
when
EmployeeTypeSalary( $et : emplyeeType, $s : salary )
$e : Employee( employeeType == $et )
then
modify($e) {
setSalary( $s );
}
end
EmployeeTypeSalary represents individual rows in your database.
With kind regards,
Mike
Hi
I have the following requirement
The rule is like if(employeeType == $1) set salary = $1
emloyeeType salary
--------------- ---------------
MANAGER 100
SR Manager 200
Director 300
Now new employeeType gets added every day. So the requirement is to update
the knowledgebase without again activating the service.
So how to achieve that with Drools. I am using Drools with a Decision table
for a different requirement in the same project. So if it can be achieved
with decision table it would be great(So new rows will get added to the
decision table dynamically but no column in this case).
--
View this message in context: http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp4019357.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users