WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Rules, JS, SQL

Rules, JS, SQL

Good day webcon community, As the title states, i ask myself if javascript is faster than using formrules. As example i had a formrule what would get the sum of a number column in an item list and compare it to another field. It took sometime for the formrule to procress this, while my javascript that i wrote in a html element did it much faster. I wonder now if i should reimplement certain functions with javascript instead of using formrules to shorten the page loading time. So can someo (...)

Hi i have a task to extract formfields from all the applications that has like this makred. Can anybody help? would be much appreciated

MVP

Hey everyone, I have the following challenge. I'm storing travel expenses in an item list. The expenses could be in various currencies. I'd like to get the exchange rate automatically for each row (because the exchange rate might be different for different dates and currencies). The API GET call is: https://kurs.resenje.org/api/v1/currencies/<CODE>/rates/<YEAR>-<MONTH>-<DAY> I have <CODE> in DET_Att6 and the <DATE> in DET_Att3. The response is a JSON: { "code": "USD", (...)

[Webcon 2024.1.1.130] (i thin it was working in 2022.1.4.404 - but I need double check] I have action to update item list where source is Parent Item list. The sql query is working but filters .. works if there is no polish letters :| so: [code='SQL'] SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL:1135} AS 'Sygnatura Audytu', d.{DCNCOL:1132} AS 'Tytuł raportu 8D', d.{DCNCOL:1131} AS 'Norma', d.{DCNCOL:1128} AS 'Punkt normy', d.{DCNCOL:1126} AS 'Opis', (...)

MVP

Hello everyone, we are using JavaScript for a RestAPI call (long story – it's a requirement from IT). Now I receive the "Response Status Code" and "Response Text" within the JavaScript, but I also need to send these values back to WEBCON for further processing. Since we usually work with WEBCON without using JavaScript, I’m lacking the necessary know-how in this area. Can anyone assist me with this? Thank you in advance! Wishing you all a great weekend, Bjoern

Hi, I have a problem with 2024.1.1.114 and SDK execution. I created an SDK to connect to the SAP and download data from the chosen contractor. The SDK was working from version 2022 to 2023 with some updates to c# code - after updating Webcon and SDK to 2024 i received the error: ERROR -> Plugin changed transaction nesting count. Please contact administrator. Interestingly, when I connect the VS debugger to the portal, the error does not occur and the SDK downloads data to the form. (...)

What is the possible and if, the most efficient way of getting data from a dictionary into a js file that is supposed to read all the items from said report ? SQL(business rule, then convey it to the js file as an argument) or we can natively do it in js ?

Is there a way to change the style of a choice field when it couldnt find a mach?

Hi there, Is it possible to use one datatable to show different tables from a sql server? Right its possible to filter the sql results based on a value in a certain column. I also want to make it possible to show the content of a different table, however account to the infobox to the right side of the textbox where i write the sql statment, its not possible. So i was wondering if there is an alternative. It would be a grueling task to create a datatable for every table on the server(there are m (...)

Dear WEBCON Team, is there an option to only SHOW or HIDE the cell of the current row (in the specified column)? With the Form rule in the Screenshot the whole column is affected. Same for the Mark Required / Mark Not Required Rule. Thank you & Best Regards, Lena Schmidbauer

Hello, I have create a form rule JS that would color the cell in an itemList. But when i move between tab panels, JS is not working anymore. On page loading/Refresh, it is fine. Do you have any tips? Thank you. let itemList = #{BRP:151}#; setTimeout(() => { var itemListElement = document.getElementById(itemList.fld + "_" + itemList.id); if (itemListElement) { const provenientaElement = itemListElement.querySelector('th[data-key="#{SFLD:512}#_#{DCN:512}#"]'); if (pro (...)

Hello, I'm trying to create a more complex delete of line function. To explain this briefly, I have a list, where I can't use the normal delete button. So instead, I'm adding one using a dataRow form field, where I call the JS function like this: deteteFunction(list ordinal number); In this list there is a column called IsOld, and it's values can be OLD or NEW. * If the line I want to delete has the value NEW in the IsOld column, then I want to just simply delete that line using the ba (...)

Hello :) I have a process where I generate an XML file. I would now like to extract this XML file in another process with a sustainable solution. My XML file contains multiple fields as well as lists. What would be the easiest way to achieve this using WEBCON? I was thinking of writing the content of my XML file into a technical multiline text field via SQL and then extracting it with the "Change Values" action. The lists would be handled with the "Update Item List" action. Is this possible? T (...)

Hello there :) I have fairly an easy question. I want to set up the timeout action which would remind users to do their step while the step would have the "Active" Status or onhold. The current logic did not work unfortunately :( Any tips on that? See attached. Igor

Hello, I have a simple question, just out of curiosity, what does: ATT_IsSecret good for? I never used it and today I saw it and I realized I know nothing about it. If anyone has any knowledge, please share. Thank you, Best regards

MVP

Hello everyone, I need your assistance with something. I am currently working on a Business Rule that should return a value using SQL. The Business Rule needs to be as universal as possible, and I want to pass two parameters to the SQL query. So far, so good. The issue is that I want to pass the same form field as a parameter twice: once as a value and once as a "column name" (essentially as an object value that I can transform in SQL with single quotes to something like WFD_AttText4). Thi (...)

Hello there :) I have yet another problem, regarding the form validation. I've attached the rules that I've applied. What I want to do is I want to block the occurence of choosing current day while it's after 9.00 A.M. Otherwise If the day is <> than Today() then the result is TRUE, which means, you are able to go further. Best Regards, Igor

Hi I have a question. I want to return all weekend days in SQL for my form validation. This is my SQL Code that returns these days, but only for the current month: WITH Dates AS ( SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS DATE) AS DateValue UNION ALL SELECT DATEADD(DAY, 1, DateValue) FROM Dates WHERE DATEADD(DAY, 1, DateValue) < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0) ) SELECT DateValue FROM Dates WHERE DATEPART(WEEKDAY, Date (...)

Hello. I have a choice field that is appearing in 2 different steps. Is it possible to filter the returning data depending on the current step? ex: if in step A, choices to be 1,2,3 and if step B, choices to be 4,5,6.

Hello there :) I have a problem when trying to generate a table using the manual initialization via HTML Button. It only works when I initialize the table manually. I want to use SQL however, to automate the whole thing. I failed using many Select Statements. What would be the ideal Select statement that would return the days between two dates, which happen to be the attributes? Best Regards, Igor