(...) 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 could b (...)
(...) cationProvider must be set. at CommonServiceLocator.ServiceLocator.get_Current() at WebCon.WorkFlow.Data.Solr.BPSSolrServerProxy.GetInstance[T]() at WebCon.BPSCloud.Core.SolrEngine.BpsSolrquery Executor.query WithPerformanceLogAsync[T](IBPSSolrServerProxy solrProxy, String query ToRun, query Options opt, String name) at WebCon.BPSCloud.Core.SolrEngine.UserBehaviorEngine.ExecuteActivityquery (...)
(...) fter 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 (...)
(...) I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Klaus
(...) per subworkflow) selected from Dictionary process. I am trying to use action “start a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – query returning data) works as follows: SELECT ‘value’ AS object of subworkflow (Database field Name) etc. • How to write SQL query / where to get ‘value’ from Dictionary process? • How to set up Step (...)
(...) t 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? (...)
(...) After installing a new development environment, I have a problem with performing an SQL query to the BPS_Config database. The environment was installed with my administrative account. From the database level, I can also see that the users of the service and the application pool (db owner) have permissions to the database. The application pool is the account indicated in the installer as the user to con (...)
(...) es Force? I have a connection and I use it in a process but I'm getting the data from Opportunities. I would like to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data/v52.0/analytics/reportTypes/Opportunity But when I use the field as a Data table in order to check the information, the list comes empty. Anyone tried this? Do you kn (...)
(...) it would be great when form rules would be stored in a minimized version too. This minimized version would be used by default whenever a form rule is send to the client in a HTTP response. When a query parameter like 'minimized=0' is added, the "full" version would be used instead. Currently the a JavaScript form rule will be bloated because line breaks are transferred as \r\n. Depending on the (...)
(...) 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 "Invalid column name Company ID, Invalid Column name GroupID" I have tried using the Objects tab in the Variables editor to select the "ConnectWise Co (...)
(...) 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}' (...)
(...) 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.
(...) ropdown. I'm using js and global variables right now, but this doesn't work after saving the form with custom values - I'm lacking some control state info. (I've tried to achieve it with document.query Selector, but without luck).
(...) start subworkflows from (depending on field value) where this line of the item list is "copied" to the new workflow. Creating the WF item is easy, but the table stays empty. Is this a bug in my query or doesn't it work at all? Kind regards Klaus
(...) 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.
(...) Hello, Do you know how can i find what query is exactly executed when i'm using raports in WEBCON. What SQL SELECT is inside, I knew that i can find it some where in the console(debug mode) F12, but I can't find it right now. Or there is some database table with this ?
(...) 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 su (...)
(...) . I have created a Report - "Equipment allocation" and I want to add a calculated column to this report that brings in the "Series" of the equipment from the Initialization process. I have this query : (select dbo.ClearWFElemAdv(WFD_AttChoose2)[which is the "Series" column in process (1)] from wfelements where wfd_dtypeid=102[which is the form id of process (1)] and wfd_id=3557) In my seco (...)
(...) 0' ... further conditions) vs (select Count(*) from WfElements childs join WFDocTypes on childs.WFD_DTYPEID = DTYPE_ID and DTYPE_GUID = '0000' where .... further conditions) I didn't test this query so it may be off and there could be syntax errors, but I think it's clear what I want to tell. Best regards, Daniel
(...) applied filter of the vacation chart generating engine. The user should decide what dates spread the want in each of therse groups (history and plans) by forming an appropriate filtering the the sql query . The vacation chart can be used for several other applications than just vacation. The currently applied filtering restricts these uses, really.