search results

(...) Dear Webcon Community! Problem: you cannot use datarow fields on portal reports. Proposal: make it possible as it was a calculated field on report, running as subquery What do you think? Thank you! BR, Peter

(...) rformed through SQL queries that retrieve the users from the active directory. To support a simple configuration of the AD group names process constants are used to define the group name. 3.1) SQL query for the first user assignment Here no filtering is required except the appropriate AD groups: SELECT users.COS_BpsID FROM [dbo].[CacheOrganizationStructure] as Users join [dbo].CacheOrganizationS (...)

(...) Hi, I am trying to move multiple related child instances through an action. I tried doing that with the “Move workflow (SQL)” action. The query I used can be found in the Attachments. The table I get also looks fine, but I still get the Error "Incorrect column PATH_ID format". I already checked all of the IDs, they should all be fine. I used the following thread as a reference: https://alterpaths.c (...)

(...) really handy especially if there are some flaws in process and some rows on item list that shouldn't be there. Now if you want to delete them by action you have to use Replace Values option with SQL query that returns only rows, that you want to leave in the form, so other rows are going to be deleted. The problem is that every row is deleted and than rows from SQL query are added so every row have ne (...)

(...) We are aware that some functionalities are not available in a SaaS environment, like some query actions. But is there an official listing of what is not allowed in SaaS? Because Building and Testing a project on-premise, and having no way of knowing if something will break on PROD because of that is not acceptable. Is there a way to test for it? Or at least have something to read through to worka (...)

(...) /api/data/v4.0/db/{dbId}/elements Now we are facing the challenge to check if there are already elements in our system, to avoid duplicates. This can also easily be done with an integrated SQL query like Select Count() from WFElements WHERE ... So we need to cancel save operation if this condition is met. Since it is a fresh workflow element it should not be persisted in database. Unfortun (...)

(...) Hi everyone, I have problem with adding multiple attachments. When I use action "Add attachment", I can add only one attachment (picture1). When I use the same action, but the SQL query returns more the one attachment - the action doesn't work (and it doesn't matter if the ID's of attchments are in the one row or many rows). Thank you for your time :)

(...) t of rows to be added. We tried to call item lists initialize, but that seems to replace all items in item list, which we don't want. Maybe there is a way to initialize (with some sort of UNION query ) which takes respect to existing items and also adds new rows. I hope you understand what we are looking for and trying to achieve. Looking forward to your experience. Thanks in advance & be (...)

(...) ea structured, I'm facing some questions in regards to: - How can I initialize dynamically the item list with an information from an integer form field? Didn't find anything in the options using SQL query - Is it possible to translate the number of months as text field, example, from today until end of year, we have September/October/November/December, or at least, have in each row the month number (...)

(...) ch from 1 process. In this process I am using a list position(list items). In my report column I will use column only from this list items. I don't have any problem with prepare the source - sql query , but I have problem with present it in portal, how to do it ? I could use Reporting Services but maybe there is some other things in webcon site?

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