Rules, JS, SQL
Hi, short: Business rule text parameter string values only containing digits seem to get casted to an integer value in WEBCON. long: Declaring a VARCHAR variable in SQL as a string like '001' is returned as string. If 001 is replaced by a text parameter in between single quotes its value '001' turns to 1 as integer. I would expect that a string value '001' remains a string when using it as a text parameter in a business rule. This is needed when ids have leading zeros as e.g. SAP often (...)
Hi, we are using version 2025.2.1.179. For a demonstration of a possible bug I've created a MSSQL data source with this query (the cat column can be ignored): SELECT 123 AS ref, 1 AS cat, 'EQU' AS country UNION ALL SELECT 123 AS ref, 2 AS cat, 'EQU' AS country UNION ALL SELECT 123 AS ref, 3 AS cat, 'EQU' AS country UNION ALL SELECT 567 AS ref, 1 AS cat, 'ESP' AS country UNION ALL SELECT 567 AS ref, 1 AS cat, 'ESP' AS country UNION ALL SELECT 567 AS ref, 3 AS cat, 'ESP' AS countr (...)
Does someone know what functions are called when i press the "Duplicate" button on a row in an itemlist ? We want to give the user the ability to copy a row, however after copying the row i need to change certain values of the copy. Right now i trigger the duplicating by selecting the html element and executing a .click() on it(the user is not allowed to just copy a row). The problem is i cannot change the values as the row does not exists at the moment when i try to change the values, and (...)
Hi all, I have a question regardong Form Field Extension PhoneNumber, I went through instruction: https://developer.webcon.com/docs/your-first-form-field-extension-js/ . My problem is I can't get intermidiate step to be executable, what I mean by that is that when I press on my Start step "Go to next step" it automatically executes and saves like already done instance and it says the workflow instance were saved and it is empty because I couldn;t write in any number. Pictures of Workflow des (...)
Hi all, I was following the instructions for Form field extensions: https://developer.webcon.com/docs/your-first-form-field-extension-js I got stuck at the first build step in WEBCON BPS SDK Tools, specifically here: "In order to build your Form Field Extension JS you have to select it in the appropriate dropdown in the tool and click the build button. It results in creating the BPSPKG file which contains all necessary files for the control. Please keep in mind that the first time you (...)
Hi all, I have a question about calculating a Date to field based on two other fields in WEBCON. I have: Date from – DateTime field Time (h) – Choice field (values like: 1, 1.5, 2, etc.) Date to – DateTime field I want Date to to be automatically calculated as: Date to = Date from + Time (h) hours I tried to use a form rule, but I keep getting an error in the Date to field. Has anyone implemented a similar calculation? What is the recommended way (formula / ADD DATE / (...)
Created form rule that is triggered on Change by a float field. It checks if the sum of a certain column in an itemlist exceeds the value in the field, if so the colum should turn red. The problem is if the form rule is triggered it chan only change the color once. If we change the value again the color persists (i tested the statment with an alert if it follows the right branch) Does someone know what causes this issue?
Hi, I need to validate a workflow instance against other instances of the same workflow. Use case: - users reserve a resource (swimming lane) - each instance has StartDate and EndDate - the same lane cannot be reserved by two instances for overlapping time ranges Question: What is the recommended approach in WEBCON BPS to implement cross-instance validation? I tried Custom Action SDK, but it works only on the current instance. Thanks.
I need to call a REST API from a WEBCON form and write the returned values back into form fields. The REST API performs several validations on the incoming JSON payload (e.g. date from valid, date to valid, amount valid, etc.). In case of a validation error, the API returns something like: { "state": "error", "error_msg": "Date to must be greater than date from" } Approach 1 – Automation (menu action) I trigger the REST call via an Automation started by a menu action. What w (...)
Hi there, is there an easy way to get the ID of the last path passed? I want to create a rule that decides whether an action template is executed or not, depending on which path the element "travelled" last. Kind regards, Klaus
Hi everyone, I’m trying to set up a connection from WEBCON BPS (2025 R2) to an Oracle database, but the documentation I found is quite limited. It only shows fields like user, password, and service name, but there’s nothing about host, port, a full connection string, or any driver requirements. Apologies if I missed something obvious — maybe the documentation is out there and I just couldn't find it. So my questions are: How exactly does WEBCON connect to an Oracle database? Do I need to ins (...)
Hi everyone, I’m working on a feature, where single button triggers a set of actions that grants permissions across related parent and child workflows, and delegates active task to other user using REST API. I'm currently facing a frustrating issue with the task delegation API using the endpoint POST /api/data/v6.0/db/{dbId}/elements/{elementId}/admin/tasks/assignment When I use this endpoint via Swagger, the task delegation executes successfully. Here's a sample of the payload that works p (...)
Hello community, I need to start a workflow instance for each email address in a text, where the addresses are separated by semicolons. My plan was to initialize the Item List using an SQL query, and then to start a subworkflow (SQL) instance for each row (email). Since our WEBCON environment doesn't support STRING_SPLIT, I fabricated a custom SQL query to split the long string into individual rows with email addresses. This approach seems to work when executed via SQL COMMAND, but it doesn't (...)
Hi, is it possible to do it via javascript is the main question. i know that this could be done via sdk(c#) and there is already an example guide of it on the forum, but i was wondering would it be possible to create a parser in javascript, that can be loaded maybe by the hotfolders option ?
Hi guys, I'm trying to cyclically start new elements in BPS based on data retrieved from another system. I already have an endpoint that returns the required data. To achieve this, I planned to use a global action (cyclical). First, I created a business rule that fetches the data using a REST API. Then, I wrote an SQL query that utilized this business rule to retrieve the data. However, when testing it, I keep encountering the following error: WebCon.WorkFlow.BusinessLogic.BusinessRu (...)
Is there a simple way to get the URL of the current instance? Use Case: In a specific step a user can create a ticket (via menu action) in a 3rd party app (REST POST). In the request body of the rest call I create the json and want to submit also the url for this instance. Thanks! Ernst
Hi all! Is there an easy way to list all the privileges (and scopes) for applications, processes, associated form types, dasboards and reports? Maybe someone already wrote a query for that or can point us in the right direction? Thanks a lot in advance & best regards, Nik
I have some form rules that have parameters, i would like to trigger them in a javascript/formrule javascript. However it seems there is no way input the parameters when invoking the form rule. Does somebody know a way to do this?
Hi, I'm having a dilemma about comparing two date objects. My thinking is when I do sql queries to retrieve data from objects it will give you already stored db results, but with webcon functions you actually get value before it is actually stored. It does not work this way, so i'm looking for a way to do it. In conclusion, it should compare date before change and after change (this is triggered on menu action SAVE).
Hi, Does anyone know how I can view the history for the "BpsUsersGroupRelations" table? I want to find out if a person was in the specific group. Thanks, Raluca
+48 12 443 13 90