search results

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 baypas

(...) Hello, Does anyone can help me, why in WEBCON sql query apostrophe is replace with quotation mark? On the form, I have an attribute with value: '2339226', '2504286'. In action "Change items lists value", I used an sql query whith this attribute, but query preview returned "2339226", "2504286". Regards

(...) Hi all! We want to execute a JSON query on a path (actually it is some business rule containing sql query ) and send these results to an external endpoint (REST service). The problem is that the query does not reflect current changes in form, since this happens on save. This should be related to database transaction and current values which are not persisted at this moment. Is there even a way t (...)

I'm having trouble running the SQL subworkflow. The query entered during the configuration works fine in testing. However, when I try to run the subworkflow in the application, I receive an error message that says, "An error occurred while executing the start subworkflow (SQL) action at the path. (Step: Verify application, Path: Submit for review) Incorrect syntax near the keyword 'from'." What co

(...) at after each transport from the Dev/Test to the Prod environment, the attributes, tables or view names of the SQL queries affected must be changed to suit the respective environment. ((Otherwise, an sql query will not work at all, or worse, incorrect data will be returned from the query.)) That can't/shouldn't be the goal, right? It is also a possible source of errors if a query is forgotten in this pr (...)

Hi, I have a problem with the execution of SQL queries in different environments using a Default connection (after moving the system to AZUR-e servers). SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation par

(...) Start a subworkflow (SQL)". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the sql query of the subworkflow action... So now I am facing the mystery where exactly this error occurs at all and what exactly is the cause. Does anyone know where I can find more information about the error? (...)

Hi, Sorry for my lack of knowledge but I've just installed WEBCON 2 days ago. Please help! I want to add in a item list rows from a SQL database but: Querying data is ok. I want to select a product name based on that query (from a Choice field) and get the correspondent price from the query... Also my query is based on another field as a filter When I change the value of that filter, the li

I am trying to write a SQL statement to start a workflow but the data source needs to be a SQL data source rather than the Webcon database. I have defined the SQL data source (ConnectWise Companies) and it is working OK. I think the problem is what do I use in the "From" part of my SQL statement. If I omit the From part, when I test my query it does not recognise the column names and says "Inv

(...) hi I have datetime type fields i.e From and To , i want to check in current db table (WFElements), if datetime exist or not between two dates validating on form submit path using sql query . Issue: all the time showing validation error message , My validation Sample below: select case when ( SELECT count(*) FROM [BPS_Content_Prod].[dbo].[WFElements] where wfd_attchoose1='{1189}' and (...)

(...) Hello community. I wrote sql query for On timeout – Insert condition (SQL). My query is returning true value, but action is not working. See figure for details. Any idea what could be the problem? Thank you.

(...) Hello community, I am trying to color whole ITEM list rows with sql query . I followed, the article https://community.webcon.com/posts/post/coloring-the-background-of-the-item-list/195/3 but even the simplest sql query (same than in article) generates the error (see figures enclosed). Any idea what I am doing wrong? Any example of your working sql query for ITEM list coloring? Thank you.

(...) Hi all! I am currently struggling with 'Add privileges' action. I want to use a predefined datasource (sql query based on WFElements), this is shown under (1) in attached picture. The datasource I am using selects all elements from a specific formtype and needs additional filtering in sql query window (2). But I am unable to do that, every attempt so far resulted in syntax error. I am sure t (...)

Hello, We have set a working Oracle connection. There is a procedure with 2 params, one IN, another OUT. Running a Business Rule containing a SQL Command against the Oracle connection: declare l_out NUMBER; begin ZZ_WEBCON_TEST.TEST_PROCEDURE(P_IN => {BRP:21}, X_OUT => l_out); end; where {BRP:21} is a Business Rule decimal parameter. The Rule is working, Oracle procedure gets execut

(...) Hi, I would have two ideas/requests (probably simple) regarding the SQL editor 1. The sql query editor should have a monospace font 2. The sql query after copying to SMSS/notepad has unnecessary newlines. Is it possible not to add newlines? regards

Hi, this may sound strange, but so was the reason, why I'm proposing this. My suggestion is that the expression editor for a SQL command inserts the instance id variable in a way: Currently it is inserted as: {WFD_ID} My suggestion is that it is inserted within single quotes: '{WFD_ID}' The reason for this is, that it would prevent errors which may only surface in production. This is