Activity for OpenL Tablets
-
Gil Tabakman posted a comment on discussion Help
Hi, How would I implement a loan payment schedule with a variable number of payments such as a mortgage where I want to have an input parameter of the number of monthly payments? Thank in advane, Gil
-
mina karimi posted a comment on discussion Help
hello Could you please guide me on how to establish a dependency between two modules in the same project or across different projects in OpenL Tablets? thank you in advance
-
Mayank Mahajan posted a comment on discussion Open Discussion
Can someone tell me which version of openl-tablets-webstudio.war file has the support for TBasic and Spreadsheet tables. I tried with the version 5.26.5 but it only supports SimpleRules table. I tried installing the later versions like 5.27.8 , 5.27.7, with Tocat version 9, 10 and 11 but the webstudio itself was not coming up once I created the project it gave the error - Type Exception Report Message /pages/common/footer.xhtml @54,97 test="#{not (request.requestURI.endsWith('login.xhtml') or request.requestURI.matches('./install/.\.xhtml'))...
-
Where should we define the Data Table and Data Type in the Openl Tablets rules ? I tried executing the rule in the attached excel sheet from Java using intelij, but each time it is not able to identify the rule itself. This is how I am trying to execute it - RulesEngineFactory<discountcalculator> discountCalculatorRulesEngineFactory = new RulesEngineFactory<>("src/main/openl/rules/DataTableWithinRule.xlsx", DiscountCalculator.class);</discountcalculator> DiscountCalculator discountCalculatorRule...
-
I am trying to acheive something similar to this rule.but the Data Table - Data Order orderData data table will be in a different excel sheet. How do I pass this excel data in one of the rules
-
Stanislav Shor posted a comment on discussion Open Discussion
Could you attach your rules and your data? It is still not clear to me whar you are trying to do
-
I need to lookup the data in the Data Table in my rules and if I find a match as per the rules the same value fro Data Table will be used to proceed further.So, basically I need to ensure my rule is able to access the data from Data Table.
-
Mayank, i need more details, please explain how do you want to use data table in rules
-
Thanks Stan. I wanted to ask how do I create wrapper for Data Table which I can pass to methods representing decision table rules. My Dats Table can have multiple columns which I need to refer from my rules. I am not able to get the syntax right while creating the wrapper for Data Table. Can you please share me some ways to create wrapper over Data Table and how to use the wrapper in rules ?
-
Mayank, 1) You should think of OpenL project as a class where Decision Table or Spreadsheet tables are methods (like in Java) and Data Tables are read only Data Fields. 2) If you have a data table 'numbers' containing int values it cuould be accessed from Decision Table code or Spreadsheet code as numbers[i] as a regular array. 3) Wrappers are used to access OpenL Tablets components from java code. In this case, your generatted wrapper should havwe a method int[] getNumbers() to access the data table...
-
I referred the openl tablets documentation and found this info under the section - Using Simple Data Tables - " In the example above, information in the data table can be accessed from Java code as shown in the following code example: int[] num = tableWrapper.getNumbers(); for (int i = 0; i < num.length; i++) { System.out.println(num[i]); } where tableWrapper is an instance of the wrapper class of the Excel or Word file. For information on wrappers, see Wrappers. " I am not able to understand how...
-
OpenL Tablets released /5.27.1/OpenL Tablets 5.27.1 Released source code.tar.gz
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Elena Kosolapova posted a comment on discussion Help
Hello Hussian, Could you please let us know which version of the MariaDB connector you are currently using? I'd like to bring to your attention some important compatibility notes: JDK Support: OpenL 26.11 is compatible with JDK 11. Further details can be found on the OpenL Supported Platforms page. JDBC Connection URL: For MariaDB, the JDBC connection URL format is jdbc:mysql://[host][:port]/[schema]. This information is available in the Installation Guide on page 24. Additional Recommendation: We...
-
Hussain Akbar posted a comment on discussion Help
I am facing the same issue. I have Oracle Linux 9 with OpenL-Tablets 5.26.11 which I am installing on Tomcat 9.0.80 with JDK 20.0.2 and MariaDB 10.10. The message I get is: Caused by: org.flywaydb.core.api.FlywayException: Unsupported Database: MariaDB 10.10 at org.flywaydb.core.internal.dbsupport.DbSupportFactory.createDbSupport(DbSupportFactory.java:151) ~[flyway-core-4.2.0.1.jar:?] at org.flywaydb.core.Flyway.execute(Flyway.java:1420) ~[flyway-core-4.2.0.1.jar:?] at org.flywaydb.core.Flyway.migrate(Flyway.java:971)...
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Chaitanya Sreepathi posted a comment on discussion Open Discussion
Hi , i would like to know if there is a way to integrate external REST API in OpenL tablets rules. during my research i found that i can create simple rules in web studio and invoke those rules from rule service application. but i need to call external public REST API ftom web studio. please provide any references for above requirement. thanks in advance Chaitanya
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Kees modified a comment on discussion Help
Hi, I have a business rule that checks the input date. Problem is that the input date is in UTC and I always have to check on a local (CET) time. Can I convert UTC to a local time? Kind regards, Kees
-
Hi, I have a business rule that checks the input date. Problem is that the input date is in UTC and I always have to check on a local (CEST) time. Can I convert UTC to a local time? Kind regards, Kees
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Hello, Thank you for bringing this issue to our attention. We will do our best to resolve it as soon as possible in the upcoming release. In the meantime, as a workaround, we kindly suggest that you make use of OpenL version 5.26.3. Thank you for your continued patience and understanding. Best Regards, Elena Kosolapova
-
Janis Jumtins posted a comment on discussion Help
Hello, Problem when I try to add project and save under Deploy Configurations - Projects to Deploy - Add. After saving there are no changes, show that project dose not added "No entries found". Where can be a problem? Thank you.
-
MANAS HALDER posted a comment on discussion Help
Yes, possible. It is my heartiest request to you to kindly go to below link on Github openl discussion where I post the problem and codes from there you can take the codes from google drive: https://github.com/openl-tablets/openl-tablets/discussion/857 Kindly if you found solution, please provide me it is very much important for my project. Thank you on advance from India!
-
Hello, would it be possible for you to provide an peace of example that we could run locally? It would also be helpful if you could explain in detail what you are trying to achieve. Thank you.
-
No but this solution does not match with requirement. I need to access the rules table from the UI end and then I have to show the results to UI end.
-
Hello, For each datatype table OpenL Tablets generates a java class bytecode at runtime. All generated classes are written to the generated sources folder during maven build with openl-maven-plugin. I share you some code with you how to build a maven artifact with generated openl datatype classes for use them as dependency in Maven: Add following lines to your pom.xml file with openl rules, if you have already maven-assembly-plugin add only execution with id datatypes-jar: <plugin> <groupid>org.apache.maven.plugins</groupid>...
-
Hello Openl Tablets, I stuck on a project where I have to take input from UI end and then this input will go to a service which is written in Java code and also a rule written in spreadsheet. But I got an error while doing this. kindly help me to solve it. I am attaching a picture of the error. Feel free to reply whatever other information you need. Thank you from India.!
