Rules, JS, SQL
Hello all, I'm trying to set up a button to start another workflow but I want to pass the current instance ID so I can relate the two instances. I'm using the info from Webcon but I don't know how to pass the ID: <div style="margin-top:30px;"> <div style="margin-bottom:30px;"><button style="background-color: #DAA520; padding: 10px 25px;font-weight: bold;font-family: Helvetica;font-size:18px; " class="fr-rounded fr-large" onclick="StartElementInNewWindow(54,54, 'AttText47=' + encodeU (...)
Hi everyone, maybe someone else is using some internal JavaScript objects and if this is the case, check whether you are using window.initialModel and make adjustments. In R2 it's gone. Most of the objects of the initialModel can be accessed via the liteModel. /api/nav/db/${parameters.dbId}/element/${parameters.instanceId}/desktop If you have no idea what I'm talking about, than everything is fine. :) Best regards, Daniel
Hello, Does anyone know if it is possible to achieve the following functionality: - I would like to insert a button in an item list column. I can achieve that so I don't need help with this (WebconBTN_01.png). This code produces the kind of button from WebconBTN_02.png image. - When this button is clicked, I want to set the DET_Att1 (it's a Yes/No field) to 1 (not run the action from the screenshot). Can someone help me out? Can this be achieved with javascript? If yes, how? Thank yo (...)
How in buisness rule I can implemement function random my buisness rule? I want to set the form field randomly out of 3 choices
I'm having some troubles using OPENJSON to parse a nested JSON response from a REST API: Following the solution posted at https://alterpaths.com/json-nested-collection-handling-in-webcon-bps/ but I cannot get the query to work in Webcon. When copying the whole query from the Show window into SQL Studio it works just as expected, but in WebCon Designer studio the following error occurs (see screenshot). Any ideas how to proceeed here?
I'm having trouble running the SQL subworkflow. The query entered during the configuration works fine in testing. However, when I try to run the subworkflow in the application, I receive an error message that says, "An error occurred while executing the start subworkflow (SQL) action at the path. (Step: Verify application, Path: Submit for review) Incorrect syntax near the keyword 'from'." What could be the cause of the error if the test query displays values correctly?
Hi everyone, I think any changes to JavaScript is worth a dedicated thread, since these won't effect everyone and can be quite technical. As everyone has read the change log, it should be no surprise that we need to apply some changes to any JavaScript based modifications. The cash-dom library has replaced the former jQuery library. The change may affect how form rules work in JavaScript mode if the rules used the functionality provided by jQuery. For a description of the differences (...)
Hi We recently changed the version of Webcon from 2020 to 2022 and I came across this problem. In the report we used a calculated column to show comments: (SELECT ISNULL (dbo.f_clear_description(wfelems.WFD_SIGNATURE), 'None')) However, from what I can see in database, the comment format has changed and now when using this function I get an error: "Invalid length parameter passed to the LEFT or SUBSTRING function." In the attachment, I marked in green old comments, and those starting w (...)
Good morning, we have a special situation, where we need an configured JavaScript(?)-Button which works like an "Add Attachment"-function INCLUDING predefined group. We would have defined the Attachment-Section with following groups: General, F1, F2, F3, F4, F5, F6. Our users should load pictures to the attachment (1x for F1-F6). These would be copied to one of six picture fields (F = German for Foto / Photo).The reason is that we need the filename for each picture, which, as far as i (...)
Hi all, does anyone know why this error is showing or how to fix it? It appears when I try to change the position of the fields in the form.
Hi, I'm having trouble converting the contents of an attachment to BASE64. On the system step I have a TimeOut that calls the transition path after a minute. In the traversal path, I have an action that calls a web service. The frame uses a business rule to convert the content of the attachment to Base64 (the business rule returns the text value of the last attachment). When the whole thing is handled by TimeOut, I get the error: Message=Error executing SQL rule Create Attachment Base64 (I (...)
Hi, Is this a bug? I am trying to delete a field from a SET statement, but Webcon tells me it can't be deleted, because it is used. When I click Show Usages, the message is "This configuration element is not used anywhere. What is going on? Thank you
Hello Community, it's time to ask my first question...so please, be understanding and polite ;) Business case: 1. I have a dictionary process, let's say 'Products', with 'Tags' text field, which contains tags (eg. black, bike, red). Every tag is separated by ','. 2. I have another process, for example 'Order'. On this form, user can enter what he is looking for, on 'Description' field. I want to check if any word from order's 'Description' field matches the 'Product' tag and return the n (...)
Hello, I have item list with anormous amout of rows from time to time. Few columns with action on it (for example set another column,select data etc.). When item list comes to 100 rows system will send many requireness (once requireness = one log on IIS). This causes slow loading of the form. No once form is unavalible ,error from web browser (Not enough ram memory). I have few ideas, but im intrested in yours.
Hi, How can I use JavaScript to get the ID of a field that triggered a function? The goal is - if JavaScript validation fails on field value change, I would like to revert the value of the changed field back to the default value )or previous value). I was researching the uxContext input parameter, but I was unable to find a function or value in the uxContext structure that would contain information about the ID of the field, that triggered the function. Thanks!
Hello, does anyone can help me, how to disable a specified cell in item list? Problem description: 1) User enters ID numbers that are not allowed to be edited in the attribute "ID numbers uneditable" (screenshot). 2) For each ID number in item list, specified in the attribute "ID numbers uneditable", item list row should be colored red and should not be editable (should be DISABLE). Especially, in this case, for specified ID number, cell in column "Choose" should be disabled. WEBCON bu (...)
Hi, I used in data sources " Current BPS databases" in field type choicefield clause IF. It's was worked until did upgrade at last verison 2022. After upgrade, When I select a value from field show id value not name value. Thank you, Raluca Lupu
Like in title. Is there dbo procedure in database to move attachment from one wfd id to another with all necessary metadatada?
Hi, I would like to programmatically get the ID of the form field that triggered a function. How can I do this? The end goal is to set the form field back to its default value in case javascript validation fails. Thanks! Mark
I've got a contract database workflow. One of the fields on the form is Project/Department field which is the same as user department in AD users list. Two users: Adam and his boss John. Is it possible to: 1. show in the report only these records, where current user login (account) department is equal to Project/Department felds. 2. on the app home show instances not only created by the current user but all instances created by John's team? At he moment John is seeing Adam's data but this n (...)
+48 12 443 13 90