Rules, JS, SQL
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 (...)
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 (...)
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 (...)
Does anyone know if it is possible to provide translations for the Form Rule Functions ALERT and CONFIRM? I tried with "MyText$$DE$$Mein Text" but that doesn't do anything. Cheers Pasquale
Hello, I tried create sql script for created a global business rule with existing multiple global business rules . I tried use of multiple global business rule ( with parameters) in one global business rule (with parameters). Every global business rule used has parameters. The business rule that appeals to the other business rules has parameters that are mapped in the appealed rules. I get the error when I testing. I explained the error and showed the code in the attached image. Thank y (...)
Hello, I'm wondering is there a simple way to do this. Sometimes "SQL COMMAND" returns nothing (there are no rows that match the query). How do you test for this? IF "SQL COMMAND [...]" = EMPTY does not seem to work. Maybe there is a workaround?
Hello, I would like to prevent users entering duplicate values in item list. The solution on KB is out of date and doesn't work. How do I prevent the user to enter a value that already use in the item list ? Thank you.
I'm banging my head on the wall... I'm sure there is an easy solution but can't figure it out at the moment. I would like to prevent users entering duplicate values in a field when starting a new workflow and I don't want to use the Instance Number to achieve that. I have a process ABC with field WFD_AttText1. How do I prevent the user to enter a value that already exists in the field WFD_AttText1 of the process ABC? Thank you.
Hello Community, I've got a problem. I've got two workflows, a parent and one subworkflow. I'm trying to transfer data from the parent workflow (single line of text attributes - 'email' and 'phone') to a table in the subworkflow with the item list update action. The table has columns ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an SQL query to put different WFD_AttText attributes into one DET_Att column and different Att_Choose values into (...)
Hello Community, is it possible to check whether a value exists in a sharepoint list before I create a new entry via workflow action? What's the best way to do it? Can I use a data connection to query for a certain value in a business rule? Thanks!
Hello all, Does anyone knows how to configure filters in reports that will something like: 'Field A' EQUAL Empty We always have to choose Not equal to a specific value Thank you!
Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allow a little more time for this sql? Michal
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 everyone, I'm wondering if there is any function that will format today's date from original format into "JAN.14.2024" format. Basically to transform the month into letters and display them like that. Thank youu.
Hello Everyone, Recently, we upgraded Webcon from 2021 version to 2022 version. New version 2022.1.4.326. I have this html content in one of HTML field in Webcon: <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"> <a id="RabenCopyToClipboard"><button id="CopyClipboard" class="btn btn-md hide-on-sidebar-dash" onclick=' Promise.all([window.webcon.businessRules.executeBusinessRule(12909, "ClipboardRule", uxContext, {})]); (...)
Hello, I want to hide/show the buttons in an item list for : add row, delete row and clone but based on rule. To be more specific, I want the 3 buttons to be visible when the instance is using business entity 1, 2 and 3 , but when i use the business entity 4 i want them to be hidden. The only way I made it possible is by using a form rule with a Java Script, but could not see any build in Webcon options. If anyone knows other ways to make this happen, I would appreciate it a lot. Thanx
Hello community. I wrote SQL query for On timeout – Insert condition (SQL). My query is returning true value, but action is not working. See figure for details. Any idea what could be the problem? Thank you.
Hello, Does anyone know if there's a way of adding a tooltip to custom buttons one adds to the form? I have an item list with a datarow column. Inside this column I'm creating a button like so: <div class="subelements-action-button"> <button class="webcon-button standard-focus subelements-action-button__delete-row webcon-button--padding-small standard-focus webcon-button--icon-button no-background th-hover" tabindex="0" type="button" onclick="onClickNotForMe({BRP:55})" title="Not (...)
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 (...)
+48 12 443 13 90