Rules, JS, SQL
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?
Is there a option to insert values do database (my own table) by the button added in html form? My idea is like a picture I addend, but when I click on the button I get error Message=Error occured during rule SQL Dodaj powiązanie (Id: 136) evaluation. Source=WebCon.WorkFlow.Base StackTrace= at: Evaluation requested at: Evaluation node: Rule at: Evaluation node: SQL InnerException: Message=Error occured during rule SQL Dodaj powiązanie (Id: 136) evaluation. Source=WebCon.WorkFlow. (...)
Hi All we have a large report build in one of our processes (list of all invoices which contains >350k items) which is now not loading for users. we have rebuilt it in SOLR and it is fast like TGV train but we had some calculated columns based on item lists which we need to rebuild. Is there any manual, KB article that describes this or anyone having expierience?
I'm struggling with the syntax of the SQL filter for a report. In general it works, but if I want to use the currently loggedin user, I get an error. I tried with the following syntax: AND (##currentloginname##='servr\Userxxx') The error message is: "Incorrect syntax near '='. Incorrect syntax near ','. Incorrect syntax near the keyword 'order'."
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?
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!
Hello, Is there any possibility to change attribute field name on form based on different attribute value?
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 (...)
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
Based on Daniel post https://daniels-notes.de/posts/2021/retrieve-ps-variable-value I figure, it is posible to retrive output value from SQL Procedure? How force "Run sql procedure" action to log ouptut to [dbo].[WFLogs] table? Write-Output in PowerShell is logged to LOG_Description column. How log ouput from sql procedure?
Hi, Does anyone else have problems with JavaScript rules not working in the mobile app? Is there any trick to it? Thanks
Hi, we have a column visibility/edit/requirement restriction for every field in an item list. But there is no column visibility restriction for the delete button, so you cannot prevent deletion of some rows. It is something you can do easily with js, but only with classic display form mode. It doesn’t work with modern forms. The problem is that it is not guaranteed that your form rules “Main form -> Behavior-> forms rule to be executed on page load” are being executed AFTER the page has been (...)
Hello, I personally like immediate validation – right after the user checks/selects/enters something on the form - much better than validation on an action. So usually I validate fields “on value change” and set the field error if necessary. Currently I use a js-function like this to showing/remove the error message (form display mode: Modern on BPS portal): function showError(columnName, hintText) { let errorLines = $("#" + columnName + " .attributeErrorsPanel li"); if (errorLines (...)
We have to iclude the Google Tag Manager into the Head and Body of the generated Webcon site of a dashboard. Including into the body seems to be possible via a HTML field. But we seemingly have no option to put it into the page header. Does anyone have any experience with Google Tag Manager and Webcon?
+48 12 443 13 90