search results

(...) Hi everyone, the start new element API has the mode parameter with the following description: mode String($int32) (query ) Optional mode parameter that specifies validation behavior. When empty or standard, all fields will be validated. When set ignoreReadonly, readonly fields won't be set but no error will be returned. Admin value allows to edit readonly fields, but requires admin permissions. (...)

(...) In the logs, we are seeing the following error: "Dynamic operations can only be performed in homogenous AppDomain" Since the error started appearing, some form fields that get data from SQL query stopped working. What could be the issue and solution? Thanks in advance Mark

(...) }, "composicionAcuerdo": { "totalDeuda": 1490.62, "iof": 0, "notificacion": 0, "gestionProtesta": 0 } } }' 2 - query SELECT [status] ,codigoClient ,id ,fechaprimerpago ,valor as cuota_valor FROM OPENJSON(@json) with([status] varchar(50) '$.status' ,VentaPajaros nvarchar(max) as json ) outer app (...)

(...) items in one of actions. It works well when I pass a sharepoint item ID, but I do not have this available in webcon. I would like to delete an item based on other column that I have. I tried CAML query below, but it does not work. Tried different columns, tried "" and '', tried contains but it does not work. Any ideas how to do it properly? 3153 I have (...)

(...) Project B. 4. Manager A is in Project A and Manager B is in group Project B. If we have e.g. expense acceptance workflow and depending on which expense belongs to which project, how can I find with query the manager of Project A or manager of Project B.

(...) After upgrade to version 2022.1.4.174 I get errors on some querries that use . Error occurs when query ing another database directly or using join, etc from SQL COMMAND or choose field querry. I found that this is related to change described in https://community.webcon.com/download/changelog/117?q=cf05b90, associated with using bps_user on SQL COMMANDS. Is there any way to deal with it at SQL server (...)

(...) How can I initialize attachments on the item list in the subworkflow? The initializing query retrieves text fields, but does not retrieve attachments. I receive an error message: Validation Error, SubElems (ID: 9031) Attachment not found. SubElems (ID: 9031) Attachment not found.

(...) technical. As everyone has read the change log, it should be no surprise that we need to apply some changes to any JavaScript based modifications. The cash-dom library has replaced the former jquery library. The change may affect how form rules work in JavaScript mode if the rules used the functionality provided by jquery . For a description of the differences in the operation of the two librar (...)

(...) Hi community! We have 2 choice fields, first one is a dropdown (field1), second one has behaviour autocomplete (field2). Dependent on selection in field1, datasource of field2 (which is an SQL query containing value of field1) changes. This is working as expected. Picker search mode of field2 is set to 'Contains', minimum characters = 3. Regardless of what is entered in field2, all availabl (...)

(...) Hi all! I am really struggling with this action. I am trying to send JSON data to a REST web service. JSON string is generated by a business rule, which contains a JSON query (FOR JSON). Testing this business rule works fine, also umlauts are shown. My configuration in request body is body type: Binary, which is the only way to send dynamic JSON data. Somehow my encoding (which should be (...)

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