Rules, JS, SQL
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
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
Hello all, I have a use case where for a parent workflow (let's say order) I'm starting many child workflows (suborders). There are some details which i don't want to duplicate on suborders like 'customer' for example - it should be stored only on order, but not on suborders. In the reports i have one report for orders, second one for suborders - on suborders I'm able to show 'customer' using custom column. With SQL like this: ( SELECT dbo.ClearWFElem(WFD_AttChoose2) /* Customer */ (...)
I have three environments: PROD, TEST and DEV. My current WebCon BPS version: 2023.1.3.169. There was a global problem with business rules in the TEST environment (it also occurred before the system update, i.e. 2023.1.3.76) - it is not possible to introduce a single new rule because an error immediately appears, as follows: Typ: System.ArgumentOutOfRangeException ------------------------------------------------------- Wiadomość:Zgłoszono wyjątek typu 'System.ArgumentOutOfRangeException'. (...)
Hello, I have a little problem. My scenario is something like this: I have an item list, with 3 columns A, B(not important here) and C and I want to disable column C(data row), if column A(choice field) has value 1#Mother, for example. Even if it's a new row just added by the user at that moment, even if it's a row added previously by other user in another step.. I just simply want that column C to be "enabled" only for a certain condition. What I did, I followed the steps from this threa (...)
Hi, I have found this thread, but i really don't understand how to create a custom button for each row in item list :( I would like to create a custom button that InvokeMenuAction for the row i have selected. https://community.webcon.com/forum/thread/3293 Can you help me? Thank you.
Hi all, I have a question, in a report view like the one attached, I mean the right hand side where the outstanding tasks are, is it possible to intervene to add a description? I have for example an urgent request which is also marked on the form, is it possible to include such information in this view, possibly change the colour of the tile or title. Can I do something to make it stand out? Maybe someone has already struggled with this.
Hello, I'm trying to create a rule in JS that will listen to my checkbox value change. checkbox -> TRUE do something checkbox -> FALSE do something else I've created a HTML field with a simple <script> InvokeRule </script> inside.. placed my rule, and error. :) Can you help at all? Thank you!
Is it possible to get an email notification when somebody is posting a comment without pressing any "move to next path buttons"? In the screenshot the yellow area.
I have got 3 different flows but on each flow I have got the same data in one variable (key). in flow 1 is Signature in flow 2 is WFD_AttChoose5 {72} in flow 3 is WFD_AttChoose6 {692} how to do SQL request or more interesting is how to do report where I can: filter Signature = WFD_AttChoose5 {72} = WFD_AttChoose6 {692} In Webcon reports I don't see process fields if I add 2 or more processes to report :/ so I can't do filter on request :/ so maybe in Source create Source by SQL (...)
Hello, I have a process (start - finish) that creates an instance and remains in the "Finish" state. Here, I have the following form fields: "Quantity TOTAL" (Floating-point number) and "Quantity" (Data table). In that data table, I have other instances from a different process, and in one column (Quantity Requested), I calculate the sum. How could I save that sum in Quantity TOTAL and have it consistently updated? (i mean - transferring the Aggregation type Sum value in my form field). (...)
+48 12 443 13 90