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

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?

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

Visibility of report rows and list of instances on application home page

0 4

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

[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

How to limit text in position list to 40 characters

0 5

Hi, I want to limit one column in list position , which is multiline text to show only first 40 characters smth like: <?php echo substr(get_the_title(),0,40).' ...'; ?> after click in '...' it will show all text

Webconapps - Connecting to an Azure SQL

0 5

Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission was denied on the object 'table_name', database 'database_name', schema 'dbo'..." Using SSMS the (...)

Change attribute field name on form

0 0

Hello, Is there any possibility to change attribute field name on form based on different attribute value?

SQL query for calculated column suddenly no longer working when added as constant

0 1

Hello folks, We have used constants which contain SQL queries for calculated report collumns a couple of times already, so this does work. But i now have a query which works perfectly when added into the calculated collumn directly, but no longer works when stored in a constant. (img attached) Through logs we found that he has a problem seemingly with strings, but we found no way to baypass that. Anyone have an idea what is done with the query on the way or why this might be the case?

Translation of ALERT and CONFIRM contents in Form Rules

0 4

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