Rules, JS, SQL

Defining EMPTY or NULL in report's filters

0 3

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!

Tooltips on html buttons

0 2

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 (...)

Passing Instance ID using Hyperlink button with StartElement

0 2

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 (...)

Info: WEBCON BPS 2023 R2: window.initialModel is gone

3 4

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

Custom buttons in item lists

0 8

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 (...)

Implementing function random

0 1

How in buisness rule I can implemement function random my buisness rule? I want to set the form field randomly out of 3 choices

Parsing nested JSON REST API with OpenJSON SQL query

0 0

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?

Run a subworkflow (SQL)

0 5

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?

JavaScript changes after moving to WEBCON BPS 2023

1 2

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 (...)

Changing the comment format in Webcon 2022 (dbo.f_clear_description error)

0 4

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 (...)

Q: How to create a Add2Attachment-Button via HTML-field (JavaScript)?

0 1

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 (...)

Error "Incorrect sequence of form fields"

0 4

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.

Content as BASE64

0 4

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 (...)

Cant delete part of Form Rule

0 2

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

How to select row from dictionary process by tag (string) from other field value

0 7

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 (...)

Many rows item list (rules,requireness,iis-problem)

0 1

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.

JavaScript - Get ID of field that triggered function

0 0

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!

Block cell (DISABLE) in item list

1 2

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 (...)

Error using clause if in chocefield

0 5

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

dbo procedure to move attachment from one wfd id to another?

0 1

Like in title. Is there dbo procedure in database to move attachment from one wfd id to another with all necessary metadatada?