Rules, JS, SQL
Hello, I have a parent process with Item list. This item list is list of tasks. I can add positions to this list and I have a button to initialize this list as a tasks. In this list I have a title, responsible person, status of the task and section (it should be item list with attributes in the form?). When I add the position and put in all data (title, person responsible and section) I hit the button, and I make new process Task to responsible person - new workflow. I have 2 problems: (...)
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 am trying to color whole ITEM list rows with SQL query. I followed, the article https://community.webcon.com/posts/post/coloring-the-background-of-the-item-list/195/3 but even the simplest SQL query (same than in article) generates the error (see figures enclosed). Any idea what I am doing wrong? Any example of your working SQL query for ITEM list coloring? Thank you.
Hi everyone, I have a questiion about dashboards: 1. I have a custom dashboard, where I have only HTML element. In this element I'm using REST API to get report (made earlier) and thanks to that I can customize it with js, css. The question is, is it possible to have functionality of view the element like in report? Explaining, when I have a report and I click element I have a compact view or something of element from right side of the page. More details about element. 2. When I have rep (...)
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.
Hi, I don't know if this is the right place, but I put in HTML element in dashboard. I want to get data from forms or reports and display them modified with CSS, JS. Is there any tips to do it? Is it possible? Regards Adam
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!
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 (...)
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
+48 12 443 13 90