Rules, JS, SQL

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

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

SQL Command in Business Rule removes line breaks (CR-LF)

0 5

Hey everyone! Is there a way to keep line breaks (CR-LF) in the output of the SQL Command used in a Business Rule? I'm selecting values from DET_LongText1 which has line breaks. I'm attaching 3 images to show what I mean. 1. Webcon Form: What I see on the frontend. 2. Notepad++: What I see in Notepad++. 3. Output: What I see in the email if I output the value of the field with a Business Rule. I can't output the form field directly because it is coming from an Item List. Do you have a (...)

Generating QR code from text attribute

0 0

Is it possible to generate a QR code other than the database document ID in Webcon BPS? I used the action described below but it is not optimal for me. I have an action (javascript) that generates a QR code and puts it in an HTML attribute. The QR code is created from the value of the text attribute. I want to insert this QR code into the attachment created from the document process. HTML created in this way cannot be added to an attachment. I added an image type attribute, I can drag from H (...)

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)?

Execute SQL stored procedure & SaaS

0 0

Hi all! We have to transfer some values from old database fields to new database fields, since we want to switch some fields in process to global fields. We plan to do this with well know T-SQL statement (UPDATE WFElements SET ...) within a cyclic action, which can be triggered on demand. Does anyone know if there are any restrictions in Webcon SaaS (Software as a service) regarding SQL UPDATE or is it allowed to do such thing? Thanks in advance & best regards, Nik