Rules, JS, SQL

How to implement Google Tag Manager into the generated Webcon Portal Header in a dashboard

0 0

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?

Calculated columns on SOLR reports

2 1

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?

SQL Execution timeout

0 3

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

SQL COOMMAND and empty answers

0 4

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?

Any option for getting next tasks assignments?

0 2

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

Isnull for Form Field type Floating Number

0 2

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

Problems when saving rules with "SELECT VALUES" from itemlist

0 2

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

Prevent duplicate entries in Item lists

0 4

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.

##currentloginname## in SQL filter for Report gives error

1 1

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'."

Prevent duplicate entries

0 4

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.

Update Item List Action

0 2

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

Starting SQL Subworkflow using Item List

0 5

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