[rules-users] Rules with Lookup Tables...

[jdepaul]

I need to evaluate a set of Rules with some of the operators comparing values
from Facts against a changing Lookup Table - for instance:

Some Partners may have several lookup tables defined like this:

NISSAN has partner_ids = {2222, 4444, 5555, 66666} and port_locations =
{ABC, EFG, GEE, FDD...}  - these values are stored in the database and need
to be evaluated at run-time.

I suppose one way I could do this is to write a rule like this (sorry,
syntax probably off a bit)...:

rule "partner and port match"
  when
    $shipment: Shipment(customerName== "NISSAN", partnerID== "2222"
                                 || customerName=="NISSAN",
partnerID=="3333"
                                 || customerName=="NISSAN",
parternID=="4444")

                                 || customerName=="NISSAN",
portLocation=="ABC"
                                 || customerName=="NISSAN",
portLocation=="EFG"
                                 || customerName=="NISSAN",
partLocation=="FDD")
  then
    System.out.println("Found the right one!");
end

Trouble is that the values in these lookup tables change frequently, so I
would like to create a rule that references a lookup table that does a DB
lookup to evaluate the values at run-time - something like this:

rule "partner and port with lookup-table" 
  when
    $shipment: Shipment(customerName== "NISSAN", partnerID in $(partner_ids
) )  <-- db lookup here

                                 || customerName=="NISSAN", portLocation in
$(port_locations))  <-- db lookup here
  then
    System.out.println("Found the right one!");
end


I know this is probably a stretch in this case - just wondering if anyone
else was able to solve such a problem?!  If so, how - 

Thanks,
James

-- 
View this message in context: http://www.nabble.com/Rules-with-Lookup-Tables...-tf3329159.html#a9256825
Sent from the drools - user mailing list archive at Nabble.com.