6:57 a.m.
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-tp40193...
Sent from the Drools: User forum mailing list archive at Nabble.com.
7:05 a.m.
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
On 23 August 2012 12:57, debchamps <majumdar.debarghya(a)gmail.com> wrote:
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-tp40193...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
7:17 a.m.
Hi, thanks so much for the reply. Can u give some reference/example where new
rules are getting in database.
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
Sent from the Drools: User forum mailing list archive at Nabble.com.
7:33 a.m.
Sorry, for some reason I thought I read you were getting the EmployeeType
and Salary from a database.
Create a new EmployeeTypeSalary object for each EmployeeType\Salary pair
you have.
Where these come from I do not know., you have not said.
On 23 August 2012 13:17, debchamps <majumdar.debarghya(a)gmail.com> wrote:
Hi, thanks so much for the reply. Can u give some reference/example
where
new
rules are getting in database.
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
9:16 a.m.
So the thing is I will have rules like
when
EmployeeTypeSalary( $et : emplyeeType, $s : salary )
$e : Employee( employeeType == $et )
then
modify($e) {
setSalary( $s );
}
end
But by taking the value from db the rules will look like
if(employesalary.color == "manager")
employesalary.salary = 100
if(employesalary.color == "director")
employesalary.salary = 300
There is only one template
But I want to take this rules from db i.e
employee salary
-------------------
manager 100
director 300
For this I need some reference/example specially for connecting Drools with
db and how the things work.
Thanks,
Deb
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
Sent from the Drools: User forum mailing list archive at Nabble.com.
10:08 a.m.
You will need to insert both Employee and EmployeeTypeSalary objects into
WM:-
Employee( "manager" )
Employee( "director" )
EmployeeTypeSalary( "manager", 100 )
EmployeeTypeSalary( "director", 300 )
You won't need any more rules than the one shown. This rule will not need
to be changed.
Just insert your reference data (EmployeeTypeSalary) and employee data
(Employee) into Working Memory.
How you get both the reference data and employee data is up to you. I'm not
about to embark on JDBC\JPA etc lessons.
On 23 August 2012 15:16, debchamps <majumdar.debarghya(a)gmail.com> wrote:
So the thing is I will have rules like
when
EmployeeTypeSalary( $et : emplyeeType, $s : salary )
$e : Employee( employeeType == $et )
then
modify($e) {
setSalary( $s );
}
end
But by taking the value from db the rules will look like
if(employesalary.color == "manager")
employesalary.salary = 100
if(employesalary.color == "director")
employesalary.salary = 300
There is only one template
But I want to take this rules from db i.e
employee salary
-------------------
manager 100
director 300
For this I need some reference/example specially for connecting Drools with
db and how the things work.
Thanks,
Deb
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
10:18 a.m.
Question: for a single lookup like the one shown in the rule you reference,
do you want to add another technology to your stack (or rather code that in
Java)?
Am 23.08.2012 17:09 schrieb "Michael Anstis" <michael.anstis(a)gmail.com>:
You will need to insert both Employee and EmployeeTypeSalary objects
into
WM:-
Employee( "manager" )
Employee( "director" )
EmployeeTypeSalary( "manager", 100 )
EmployeeTypeSalary( "director", 300 )
You won't need any more rules than the one shown. This rule will not need
to be changed.
Just insert your reference data (EmployeeTypeSalary) and employee data
(Employee) into Working Memory.
How you get both the reference data and employee data is up to you. I'm
not about to embark on JDBC\JPA etc lessons.
On 23 August 2012 15:16, debchamps <majumdar.debarghya(a)gmail.com> wrote:
> So the thing is I will have rules like
>
> when
> EmployeeTypeSalary( $et : emplyeeType, $s : salary )
> $e : Employee( employeeType == $et )
> then
> modify($e) {
> setSalary( $s );
> }
> end
>
>
> But by taking the value from db the rules will look like
> if(employesalary.color == "manager")
> employesalary.salary = 100
>
> if(employesalary.color == "director")
> employesalary.salary = 300
>
> There is only one template
>
> But I want to take this rules from db i.e
> employee salary
> -------------------
> manager 100
> director 300
>
>
> For this I need some reference/example specially for connecting Drools
> with
> db and how the things work.
>
> Thanks,
> Deb
>
>
>
>
>
> --
> View this message in context:
>
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
> Sent from the Drools: User forum mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
1:01 p.m.
On 23 August 2012 17:08, Michael Anstis <michael.anstis(a)gmail.com> wrote:
You will need to insert both Employee and EmployeeTypeSalary objects
into
WM:-
Employee( "manager" )
Employee( "director" )
EmployeeTypeSalary( "manager", 100 )
EmployeeTypeSalary( "director", 300 )
You won't need any more rules than the one shown. This rule will not need
to be changed.
Only a little :)
The way it is written it will loop. Either add the rule attribute
no-loop true
or
$e : Employee( employeeType == $et, salary == null )
or
$e : Employee( employeeType == $et, salary == 0 )
depending on the type if Employee.salary.
-W
Just insert your reference data (EmployeeTypeSalary) and employee data
(Employee) into Working Memory.
How you get both the reference data and employee data is up to you. I'm
not about to embark on JDBC\JPA etc lessons.
On 23 August 2012 15:16, debchamps <majumdar.debarghya(a)gmail.com> wrote:
> So the thing is I will have rules like
>
> when
> EmployeeTypeSalary( $et : emplyeeType, $s : salary )
> $e : Employee( employeeType == $et )
> then
> modify($e) {
> setSalary( $s );
> }
> end
>
>
> But by taking the value from db the rules will look like
> if(employesalary.color == "manager")
> employesalary.salary = 100
>
> if(employesalary.color == "director")
> employesalary.salary = 300
>
> There is only one template
>
> But I want to take this rules from db i.e
> employee salary
> -------------------
> manager 100
> director 300
>
>
> For this I need some reference/example specially for connecting Drools
> with
> db and how the things work.
>
> Thanks,
> Deb
>
>
>
>
>
> --
> View this message in context:
>
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
> Sent from the Drools: User forum mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
1:18 p.m.
I knew I was on dangerous ground :)
Thanks Wolfgang for tying up my loose end.
At least you didn't change it to employesalary.color == "director" which
would have confused me ;)
On 23 August 2012 19:01, Wolfgang Laun <wolfgang.laun(a)gmail.com> wrote:
On 23 August 2012 17:08, Michael Anstis <michael.anstis(a)gmail.com> wrote:
> You will need to insert both Employee and EmployeeTypeSalary objects into
> WM:-
>
> Employee( "manager" )
> Employee( "director" )
> EmployeeTypeSalary( "manager", 100 )
> EmployeeTypeSalary( "director", 300 )
>
> You won't need any more rules than the one shown. This rule will not need
> to be changed.
>
Only a little :)
The way it is written it will loop. Either add the rule attribute
no-loop true
or
$e : Employee( employeeType == $et, salary == null )
or
$e : Employee( employeeType == $et, salary == 0 )
depending on the type if Employee.salary.
-W
>
> Just insert your reference data (EmployeeTypeSalary) and employee data
> (Employee) into Working Memory.
>
> How you get both the reference data and employee data is up to you. I'm
> not about to embark on JDBC\JPA etc lessons.
>
>
> On 23 August 2012 15:16, debchamps <majumdar.debarghya(a)gmail.com> wrote:
>
>> So the thing is I will have rules like
>>
>> when
>> EmployeeTypeSalary( $et : emplyeeType, $s : salary )
>> $e : Employee( employeeType == $et )
>> then
>> modify($e) {
>> setSalary( $s );
>> }
>> end
>>
>>
>> But by taking the value from db the rules will look like
>> if(employesalary.color == "manager")
>> employesalary.salary = 100
>>
>> if(employesalary.color == "director")
>> employesalary.salary = 300
>>
>> There is only one template
>>
>> But I want to take this rules from db i.e
>> employee salary
>> -------------------
>> manager 100
>> director 300
>>
>>
>> For this I need some reference/example specially for connecting Drools
>> with
>> db and how the things work.
>>
>> Thanks,
>> Deb
>>
>>
>>
>>
>>
>> --
>> View this message in context:
>>
http://drools.46999.n3.nabble.com/Drools-with-rules-from-database-tp40193...
>> Sent from the Drools: User forum mailing list archive at Nabble.com.
>> _______________________________________________
>> rules-users mailing list
>> rules-users(a)lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
4528
days inactive
4528
days old
8 comments
4 participants
participants (4)
-
Ansgar Konermann -
debchamps -
Michael Anstis -
Wolfgang Laun