Re: [rules-users] Fusion, Insert Events with timestamp in the past.
I realized that there are some mistakes in my previous post with the times: 1. First example: LHS: $e: Message (Message(this after [0, 10sec] $e), where Message has an @timestamp 1.1. insert(new Message(NOW().subtract(5sec))); -- 11:00:00am wait(6sec); insert(new Message(NOW())); // NOT Activated 1.2. insert(new Message(NOW().subtract(5sec))); -- 11:00:00am wait(2sec); insert(new Message(NOW())); // Activated at 11:00:05am 2. First example: LHS: $e: Message not (Message(this after [0, 10sec] $e), where Message has an @timestamp insert(new Message(NOW().subtract(5sec))); -- 11:00:00am // Activated at 11:00:10am Has anybody an idea with example #2 is not working? -- View this message in context: http://drools.46999.n3.nabble.com/Fusion-Insert-Events-with-timestamp-in-the-past-tp4029843p4030069.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
[rules-users] Need help in understanding Data enumeration’s drop down list configuration
Hi Drools, Need help in understanding Data enumeration’s drop down list configuration, I had created a simple data enumeration as, [cid:image001.png@01CF8A37.D4053860] For this, I also created a Customer object with a code field as String at org.kie.example.project1 package. While creating guided rule, I’m unable to view the enumeration as drop down as like below, [cid:image002.png@01CF8A37.D4053860] I had tried this scenario with JBoss BRMS 6. Please help me to understand on how to populate the drop down using data enumeration. Thanks, srinath [Aspire Systems] This e-mail message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Need help in understanding Data enumeration’s drop down list configuration
What happens if you click on the pencil next to equal to dropdown and select literal value? This is when you should see the enum list. On 17 June 2014 10:00, Shrinath Managuli shrinath.manag...@aspiresys.com wrote: Hi Drools, Need help in understanding Data enumeration’s drop down list configuration, I had created a simple data enumeration as, For this, I also created a *Customer* object with a *code* field as String at *org.kie.example.project1* package. While creating guided rule, I’m unable to view the enumeration as drop down as like below, I had tried this scenario with JBoss BRMS 6. Please help me to understand on how to populate the drop down using data enumeration. Thanks, srinath [image: Aspire Systems] This e-mail message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
[rules-users] Comparing Objects of same class.
HI Team, We came in situation where we need to compare our objects of same class. For example, we have a class like SampleData.java. It has fields like 1) No 2) Student Name 3) DOJ(date of join) Now, we want to write a Rule to get the Student Details like 1) if any 5 students joined in 2 days of span This rule might changed dynamically like for now it is 2 days but in future it may be 1 day or 3 days etc., Please provide any suggestions on this... Thanks Regards Naresh -- View this message in context: http://drools.46999.n3.nabble.com/Comparing-Objects-of-same-class-tp4030073.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
Re: [rules-users] Comparing Objects of same class.
What have you tried so far? And, please, clarify what you mean by any 5 in 2 days. For instance: If A, B, C, D, E, F join on 5/24, is this a match? And if G, H, J join additionally on 5/25, is this another match? -W On 17/06/2014, naresh.t nareshthota...@gmail.com wrote: HI Team, We came in situation where we need to compare our objects of same class. For example, we have a class like SampleData.java. It has fields like 1) No 2) Student Name 3) DOJ(date of join) Now, we want to write a Rule to get the Student Details like 1) if any 5 students joined in 2 days of span This rule might changed dynamically like for now it is 2 days but in future it may be 1 day or 3 days etc., Please provide any suggestions on this... Thanks Regards Naresh -- View this message in context: http://drools.46999.n3.nabble.com/Comparing-Objects-of-same-class-tp4030073.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 ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Fuse ESB Drools 6 - Fire-until-halt configuration using persistence
Maybe I'm wrong and I cannot use this configuration because in some case fail 2014-06-17 13:57 GMT+02:00 Sergio Besada scerqu...@gmail.com: Hi, I have seen that in the drools version 6.1.0.Beta4, the command fire-until-halt is developed using persistence but drools doesn't let me test it because this command implement the interface UnpersistableCommand so I have eliminated this interface and I have tested this configuration. Surprisingly, Drools works as I expected and doesn't throw any exception, ¿Where is the problem in this configuration? Here my camel context ?xml version=1.0 encoding=UTF-8? beans xmlns=http://www.springframework.org/schema/beans; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:kie=http://drools.org/schema/kie-spring; xsi:schemaLocation= http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://drools.org/schema/kie-spring http://drools.org/schema/kie-spring.xsd http://camel.apache.org/schema/spring http://camel.apache.org/schema/spring/camel-spring.xsd; kie:kmodule id=kModule kie:kbase name=rules packages=rules kie:ksession name=ksession1 type=stateful kie:batch kie:fire-until-halt/ /kie:batch kie:configuration kie:jpa-persistence kie:transaction-manager ref=txManager/ kie:entity-manager-factory ref=myEmf/ /kie:jpa-persistence /kie:configuration /kie:ksession /kie:kbase /kie:kmodule kie:environment id=env kie:entity-manager-factory ref=myEmf/ kie:transaction-manager ref=txManager/ /kie:environment bean class=org.postgresql.ds.PGPoolingDataSource id=jbpm-ds property name=serverName value=localhost/property property name=databaseName value=drools/property property name=portNumber value=5432/property property name=user value=DWP/property property name=password value=DWP/property /bean bean id=myEmf class=org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean property name=dataSource ref=jbpm-ds/ property name=persistenceUnitName value=org.jbpm.persistence.jpa.local/ /bean bean id=txManager class=org.springframework.orm.jpa.JpaTransactionManager property name=entityManagerFactory ref=myEmf/ /bean bean id=kiePostProcessor class=org.drools.osgi.spring.OsgiKModuleBeanFactoryPostProcessor/ bean id=fireALlRulesCommand class=com.execute.command.FireAllRules/ bean id=fireUntilHaltCommand class=com.execute.command.FireUntilHalt/ bean id=factStudent class=com.test.facts.Student/ camelContext xmlns=http://camel.apache.org/schema/spring; route trace=false id=testRoute from uri=timer:testRoute?period=10s/ to uri=log:message/ bean method=initStudent ref=factStudent/ to uri=kie:ksession1?action=insertBody id=AgeVerification/ !-- bean method=fireUntilHalt ref=fireUntilHaltCommand/ to uri=kie:ksession1?action=execute/ -- /route /camelContext /beans PD: I have attached my example , it's a maven project 2014-06-04 19:04 GMT+02:00 Sergio Besada scerqu...@gmail.com: Thank you in advance. 2014-06-04 18:29 GMT+02:00 Charles Moulliard ch0...@gmail.com: I will have a look to your use case as it is not yet covered and will perhaps require that we modify the kie-camel component On Wed, Jun 4, 2014 at 6:02 PM, s b scerqu...@gmail.com wrote: I'm testing the drools new version (6.1.0.Beta4) but I have a problem with the Stateful Drools Session. I have deployed in JBoss Fuse ESB the last versión of the drools (drools camel, jbpm, spring, etc), I have atached my camel context bundle (It's a maven project). This is my camel-context ?xml version=1.0 encoding=UTF-8? beans xmlns=http://www.springframework.org/schema/beans; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:kie=http://drools.org/schema/kie-spring; xsi:schemaLocation= http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://drools.org/schema/kie-spring http://drools.org/schema/kie-spring.xsd http://camel.apache.org/schema/spring http://camel.apache.org/schema/spring/camel-spring.xsd; kie:kmodule id=kModule kie:kbase name=rules packages=rules kie:ksession name=ksession1 type=stateful !--kie:batch kie:fire-all-rules/ /kie:batch -- kie:configuration kie:jpa-persistence kie:transaction-manager ref=txManager/ kie:entity-manager-factory ref=myEmf/
Re: [rules-users] Comparing Objects of same class.
Hi, more details... lets take a rule like If any 5 students joined in 5 days of span... NoNameDOJ 1 A*5/24* 2 B* 5/25* 3 C *5/27* 4 D *5/23* 5 E 5/30 6 F 5/20 7 G 5/15 If we take, A,B,C and D details, these 4 students are joined in =5 days of span(lowest date :-D:5/23 and highest date :-c:5/27 -- diff is 4 days). If any other student joined in these =5 days (5/23 to 5/27 ) then we need those all 5 students details. If we take F, A, B and D, these 4 students also joined in = 5 days...but no.of 5 students condition is missing. As we said we are able to work on static rules like if student joined =5/23 !=5/30 etc. Thanks Regards Naresh -- View this message in context: http://drools.46999.n3.nabble.com/Comparing-Objects-of-same-class-tp4030073p4030079.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
Re: [rules-users] Comparing Objects of same class.
Let S be the (nonempty) set of all students and d the length of the span of days. There exists a student s0 so that s0.doj is the minimum over all S. Then accumulate and count students x over S so that s0.doj = x.doj and x.doj s0.doj + d. If this count exceeds the threshold t: display the students. Finally, remove all students y from S where y.doj = s0.doj. Repeat until S is empty. I don't see any particular reason for doing this in Drools, although it's feasible with just a handful of rules. But it is a ridiculously simply exercise in Java. Does this have any practical value? Students' behaviour is notoriously erratic. Is this for a brand new branch of behavioural psychology?! -W On 17/06/2014, naresh.t nareshthota...@gmail.com wrote: Hi, more details... lets take a rule like If any 5 students joined in 5 days of span... NoNameDOJ 1 A*5/24* 2 B* 5/25* 3 C *5/27* 4 D *5/23* 5 E 5/30 6 F 5/20 7 G 5/15 If we take, A,B,C and D details, these 4 students are joined in =5 days of span(lowest date :-D:5/23 and highest date :-c:5/27 -- diff is 4 days). If any other student joined in these =5 days (5/23 to 5/27 ) then we need those all 5 students details. If we take F, A, B and D, these 4 students also joined in = 5 days...but no.of 5 students condition is missing. As we said we are able to work on static rules like if student joined =5/23 !=5/30 etc. Thanks Regards Naresh -- View this message in context: http://drools.46999.n3.nabble.com/Comparing-Objects-of-same-class-tp4030073p4030079.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 ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
[rules-users] NPE spring-boot project via a jar
Hi, Running into NPE on application boot up. It appears to be related to a previous topic. I didn't add to it as the last entry appears to veer off topic and didn't want it lost in the wash. http://drools.46999.n3.nabble.com/rules-users-NullPointerException-with-kie-spring-6-0-1-and-Spring-4-0-td4027854.html Using kie-spring-6.1.0.Beta4.jar, spring 4. As per the former topic, the application starts up without issue in IDE env, etc. but fails on jar boot up. The stack is as follows: Exception in thread main org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'kiePostProcessor' defined in class path resource [qres/callManager.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.kie.spring.KModuleBeanFactoryPostProcessor]: Constructor threw exception; nested exception is java.lang.NullPointerException at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1076) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1021) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1121) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:682) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461) at com.s.c.util.ConfigUtility.loadProfileContext(ConfigUtility.java:42) at com.s.c.manager.CallManager.init(CallManager.java:19) at com.s.c.manager.CallManager.main(CallManager.java:46) Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.kie.spring.KModuleBeanFactoryPostProcessor]: Constructor threw exception; nested exception is java.lang.NullPointerException at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:164) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:89) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1069) ... 13 more Caused by: java.lang.NullPointerException at org.kie.spring.KModuleBeanFactoryPostProcessor.initConfigFilePath(KModuleBeanFactoryPostProcessor.java:83) at org.kie.spring.KModuleBeanFactoryPostProcessor.init(KModuleBeanFactoryPostProcessor.java:68) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148) ... 15 more -- View this message in context: http://drools.46999.n3.nabble.com/NPE-spring-boot-project-via-a-jar-tp4030081.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
[rules-users] 5.6 Decision Table VLookup
Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.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
Re: [rules-users] 5.6 Decision Table VLookup
Is the VLOOKUP in the same sheet? I think there are problems with Apache POI resolving formulas across different worksheets (but am guessing based on some other changes we had to make regarding linked workbooks). On 17 June 2014 16:36, gboro54 gbor...@gmail.com wrote: Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.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 ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] 5.6 Decision Table VLookup
They are different sheets. Basically we have a our tables on sheet 1 and sheet 2 is populated from an import of data from an external datasource to allow a vlookup of information(so the business user can see the data/and we can maintain it) manstis wrote Is the VLOOKUP in the same sheet? I think there are problems with Apache POI resolving formulas across different worksheets (but am guessing based on some other changes we had to make regarding linked workbooks). On 17 June 2014 16:36, gboro54 lt; gboro54@ gt; wrote: Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p4030084.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
Re: [rules-users] 5.6 Decision Table VLookup
That then is indeed a bug. Can you please raise a DROOLS JIRA and attach a unit test demonstrating the problem (preferably please submit your unit test as a Pull Request)? We're always on the look out for community contributions, so if you want to tackle a fix it would be appreciated; otherwise we'll add the JIRA to the list to look at some time. With kind regards, Mike On 17 June 2014 17:25, gboro54 gbor...@gmail.com wrote: They are different sheets. Basically we have a our tables on sheet 1 and sheet 2 is populated from an import of data from an external datasource to allow a vlookup of information(so the business user can see the data/and we can maintain it) manstis wrote Is the VLOOKUP in the same sheet? I think there are problems with Apache POI resolving formulas across different worksheets (but am guessing based on some other changes we had to make regarding linked workbooks). On 17 June 2014 16:36, gboro54 lt; gboro54@ gt; wrote: Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p4030084.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 ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] 5.6 Decision Table VLookup
I will work on a test case and create a defect for it. I will see if I can't get some time to take a look at this myself but will keep you informed about my status on completing this ticket manstis wrote That then is indeed a bug. Can you please raise a DROOLS JIRA and attach a unit test demonstrating the problem (preferably please submit your unit test as a Pull Request)? We're always on the look out for community contributions, so if you want to tackle a fix it would be appreciated; otherwise we'll add the JIRA to the list to look at some time. With kind regards, Mike On 17 June 2014 17:25, gboro54 lt; gboro54@ gt; wrote: They are different sheets. Basically we have a our tables on sheet 1 and sheet 2 is populated from an import of data from an external datasource to allow a vlookup of information(so the business user can see the data/and we can maintain it) manstis wrote Is the VLOOKUP in the same sheet? I think there are problems with Apache POI resolving formulas across different worksheets (but am guessing based on some other changes we had to make regarding linked workbooks). On 17 June 2014 16:36, gboro54 lt; gboro54@ gt; wrote: Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p4030084.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p4030086.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
Re: [rules-users] 5.6 Decision Table VLookup
Thank-you Sent on the move On 17 Jun 2014 20:52, gboro54 gbor...@gmail.com wrote: I will work on a test case and create a defect for it. I will see if I can't get some time to take a look at this myself but will keep you informed about my status on completing this ticket manstis wrote That then is indeed a bug. Can you please raise a DROOLS JIRA and attach a unit test demonstrating the problem (preferably please submit your unit test as a Pull Request)? We're always on the look out for community contributions, so if you want to tackle a fix it would be appreciated; otherwise we'll add the JIRA to the list to look at some time. With kind regards, Mike On 17 June 2014 17:25, gboro54 lt; gboro54@ gt; wrote: They are different sheets. Basically we have a our tables on sheet 1 and sheet 2 is populated from an import of data from an external datasource to allow a vlookup of information(so the business user can see the data/and we can maintain it) manstis wrote Is the VLOOKUP in the same sheet? I think there are problems with Apache POI resolving formulas across different worksheets (but am guessing based on some other changes we had to make regarding linked workbooks). On 17 June 2014 16:36, gboro54 lt; gboro54@ gt; wrote: Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p4030084.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users ___ rules-users mailing list rules-users@.jboss https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p4030086.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 ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Comparing Objects of same class.
Dear Wolfgang, Thanks for your patience and understandings. Let me clear our requirement. Actually we are not working any student psychology thing. I thought to simplify the problem in terms of Student example but it is getting complicated. What we are trying to achieve is... We have some RAW logs(windows event logs like login success, login failed, bad user name and password etc., along with date and time) in our DB. We are trying get trend of some particular events like bad user name and password. If these type of events are happening in less span of time, then we will find those user names and do some activity on them. In our existing application, we have achieved this by using java with hard coded inputs. Means we are getting those events, if any 5 events occurred in 3 minutes. Now we are trying to add some dynamism for these type of requirements. We are exploring Drools Rule Engines to check that is it compatible with these type of rules. If you have any other Rule Engines in your mind, please suggest us. Thanks Naresh -- View this message in context: http://drools.46999.n3.nabble.com/Comparing-Objects-of-same-class-tp4030073p4030088.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