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