Rules, JS, SQL

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

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

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

Get ID of form field that triggered function

0 2

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

[Solved] How to get "unsaved data" exists information aka "page is dirty"

2 2

Hi, does anyone know how to get via JavaScript whether the page "is dirty". So I can do a similar check to "You are leaving the form with unsaved data"? Best regards, Daniel

JS for adding new row in item list

0 2

Hi community! We want to add new row(s) to an item list due to customer requirement. This should be triggered on button click, that means on the client-side. Unfortunately I didn't find a way, to insert new row(s) to an item list in available JS functions. Does anyone know how to do that or could you provide some code samples? Thanks in advance & best regards, Nik

Portal Substitutions / SQL-Data

0 2

Hello, WebCon BPS user can specify substitutions on the portal. Does anybody know, where the data is stored in the SQL database? I'd like to create a weekly report with the data. We are on BPS Version 2021.1.4.55. Thank you! Cheers, Balint

Open first attachment from all atachment tab

0 2

Based on Daniels blog (https://daniels-notes.de/posts/2021/javascript-form-rule-execution-on-page-load#show-all-attachments-after-page-load) it is posible to open first attachments after page load but from all attachments tab (becouse attachment is in parent workflow)?

Attach sent "Custom Mail" as attachment in Workflow instance

0 2

Hi everybody. I wonder if there is a way how I can attach the message sent by an "custom mail" action as new attachment to the workflow instance? Kind regards, KLaus

Any option for getting next tasks assignments?

0 2

Hi everyone, does anyone have an idea whether it's possible to retrieve the users to whom a task will be assigned in the next step? What I've tested so far: - Verified that the variable 'System fields\Assigned persons' contains the current persons during path transition, exit and entry. - Created an SQL statement which returned the latest row from WFElementTasks, and executed this in an action during path transition, exit and entry. They all returned the old row. - SDK object RunCustomActionPa (...)

Isnull for Form Field type Floating Number

0 2

Hi all, I'm having a problem in Studio with a Form Validation rule using SQL. I have an item list that is populated with lines if the user select a Sales Order in another field or manually filled if there is no information on the SO. There is a column that is mandatory to be filled whenever the item list has any rows and I tried many examples to construct a validation form rule in order to have information on that column. I was using a SQL query because: - Column cannot be required (...)

Problems when saving rules with "SELECT VALUES" from itemlist

0 2

Hi everyone! I was just evaluating the latest version (2021.1.3.163) on our DEV system, and wanted to prepare new functions for my processes. I had issues when trying to save a rule that included the new "select values" function to check if a collection of values from an item list is not empty. In the testing window the rule works as expected, it just wont let me save it because of invalid rule configuration. As soon as i remove select values and replace it with something else it works. Is t (...)

Update Item List Action

0 2

Hey everybody! Does anyone already created an action to add news values in an item list? I'm trying to add a new line in one item list but one of the field I'm copying into is a Person/Group one and it doesn't get the value. I'm using the following query: select '{WFCONCOL:1769}' as {DCNCOL:105}, 'Requester Manager' as {DCNCOL:104} from WFElementDetails where DET_WFDID='{WFD_ID}' and DET_WFCONID={WFCON:1652} with the unique value set to be the row identifier Anyone with idea (...)

Dynamically hide / show form fields based on field GUID (Javascript)

0 1

Hi all! I want to hide / show / mark as required some form fields based on field Guid. Is there a way to do this easily? When I look at the signature of e.g. Hide function it just seems to take some shrinked DB name (e.g. AttText35) or field id (integer), which is different between environments. Appreciate any hint into right direction. Thanks in advance & best regards, Nik

SET FOCUS for item list row

0 1

Hi! I need your help regarding setting focus on the last row of the item list. Business wants to perform the following scenario. Batch of barcode lables from paper documents are to be scanned with hendheld scanner. Each scanned id is to be inserted into ID column of item list table. Based on the ID some additiona data are to displayed in other columns. What I have already done is the form rule that ADDs NEW ROW every time the value of ID item list column is changed. It works ok. The problem is (...)

Custom dashboard, show view of element

0 1

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

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

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

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.

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?