I also need to make a rule with a lookup tables, and I have found that the new version of rules support 'from'. The syntaxe it's something like: 'from' * http://jira.jboss.com/jira/browse/JBRULES-341 'from' allows the engine to reason over data not inside the engine, this can be used with global variables to interact with data providing services, such as hibernate. MVEL provides the scripting language capabilities for this, any previously bound variable can be used in the MVEL expression. The following example shows a hibernate named query with some dummy properties that returns a list of Restaurants. Restaurant() is a standard pattern, and can have its own field constraint and bindings like any other pattern. $r : Restaurant( $postCode ) from hbSession.getNamedQuery( "some query" ).setProperties( [ key1 : value2, key2 : value ] ).list() I haven't tried it yet, and I have some questions also. But go ahead! :-) __________________________________ Francisco Brum - francisco.brum(a)link.pt Link Consulting - http://www.link.pt/ Tel.: 213 100 031 Av. Duque D'Ávila, 23 4º Esq. 1000-138 Lisboa -----Original Message----- From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Anstis, Michael (M.) Sent: sexta-feira, 2 de Março de 2007 9:16 To: Rules Users List Subject: RE: [rules-users] Rules with Lookup Tables... I don't have the syntax at hand but Edson has previously posted about using "from" in similar circumstances. This would allow you to access a lookup table on a database as part of the LHS of a rule. -----Original Message----- From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of jdepaul Sent: 01 March 2007 19:35 To: rules-users(a)lists.jboss.org Subject: [rules-users] Rules with Lookup Tables... 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#a925682 5 Sent from the drools - user 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

Hi, I am exposing a rule via an Axis2 1.0 web service. I have seen that the Drools jar files need to be in the axis2/WEB-INF/lib because for some reason they are not loaded from the deployed service archive. The problem I am having is that I get the following error message: Rule Compilation error Unknown variable or type "person" Class "java.lang.Object" has no method named "getName" Expression "person" is not an rvalue Expression "person" is not an rvalue Expression "person" is not an rvalue Unknown variable or type "person" Unknown variable or type "person" Class "java.lang.Object" has no method named "setCreditGranted" Expression "person" is not an rvalue Expression "person" is not an rvalue Expression "person" is not an rvalue Unknown variable or type "person" Exception:12 errors while compiling unit "com/finance/rules/webservice/Rule_Credit_Denied_0.java" After some research on the web, I have seen that the object model or compiled class file for the Person object (the object that the .drl file imports/works with) needs to be in the axis2/WEB-INF/lib as well, so I jar it up and toss it in there, all by itself. Now when I test the service, Axis2 throws the following: - Servlet.service() for servlet AxisServlet threw exception java.lang.ExceptionInInitializerError at com.finance.rules.webservice.grantcredit.types.PersonDocument$Factory.pa rse(PersonDocument.java:173) All my objects are generated as xml beans via Axis2 gen tools, the Person construct is actually wrapped inside a PersonDocument objct, from the code gen process. I have tested the .drl file locally (inside eclipse) by having a test app hit the .drl file directly and all works properly with the xml bean objects. How do I get jboss rules engine to load my Person/PersonDocument objects correctly? aj -------------------------------------------- Alan R Jones

I have configured 3.1.0M1 on my local machine with the corresponding IDE... now I need help with the rule syntax. I have configured a DAO which will return an ArrayList of values representing a list of values from the lookup table - I tried this, but I'm having problems...: rule "GATE-IN Match" // This rule should match IF: // CUSTOMER_REFERENCE_NUMBER starts with 'HX', and // ACTIVITY_LOCATION starts with "US" // SH_CODE exists in lookup table idenfied by key "MILT.CUSTNO" when $GateIN : RKEM_Move (CUSTOMER_REFERENCE_NUMBER matches "^HX.*", ACTIVITY_LOCATION matches "^US.*", $list : (from lookupDAO.getLookupValues("MILT.CUSTNO")) contains $GateIN.getSH_CODE() ) then System.out.println("Matched 001695568GP GATE-IN Match Rule - about to inovke Service..."); end Anstis, Michael (M.) wrote: -- View this message in context: http://www.nabble.com/Rules-with-Lookup-Tables...-tf3329159.html#a9360008 Sent from the drools - user mailing list archive at Nabble.com.

Let me clarify my intentions: the lookupDAO.getLookupValues(..) returns an ArrayList of String values. I need to make sure that SH_CODES attribute (String) of the RKEM_MOVE object exists in that list of Strings. Having trouble with this syntax: when // Get a list of Strings in ArrayList form from the DB table $lookupList : List() from lookupDAO.getLookupValues( "MILT.CUSTNO" ) // Now do the comparison... RKEM_Move (CUSTOMER_REFERENCE_NUMBER matches "^HX.*", ACTIVITY_LOCATION matches "^US.*", $lookupList contains SH_CODE) // <-- if SH_CODE exists in the $lookupList from DAO... then... System.out.println("Found a Match Rule - about to inovke Service..."); end Please help - James Edson Tirelli-3 wrote: -- View this message in context: http://www.nabble.com/Rules-with-Lookup-Tables...-tf3329159.html#a9374192 Sent from the drools - user mailing list archive at Nabble.com.