Rules, JS, SQL
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?
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?
Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allow a little more time for this sql? Michal
Hello, I'm wondering is there a simple way to do this. Sometimes "SQL COMMAND" returns nothing (there are no rows that match the query). How do you test for this? IF "SQL COMMAND [...]" = EMPTY does not seem to work. Maybe there is a workaround?
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 (...)
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 (...)
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 (...)
Hello, I would like to prevent users entering duplicate values in item list. The solution on KB is out of date and doesn't work. How do I prevent the user to enter a value that already use in the item list ? Thank you.
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 banging my head on the wall... I'm sure there is an easy solution but can't figure it out at the moment. I would like to prevent users entering duplicate values in a field when starting a new workflow and I don't want to use the Instance Number to achieve that. I have a process ABC with field WFD_AttText1. How do I prevent the user to enter a value that already exists in the field WFD_AttText1 of the process ABC? Thank you.
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 (...)
Hello, I'm trying to start a subworkflow from an item list. My item list will have the candidate for Positions and it will not be filled at the same time, each time there's a candidate for an offer, the user creates a row. To start my subworkflow I'm using as conditions having the candidate name as not null and a flag set to true and i'm using this as an execution condition with the following SQL: if exists ( select 1 from WFElementDetails where DET_WFDID={WFD_ID} and DET_WFCONID={WFCO (...)
+48 12 443 13 90