(...) 'phone') to a table in the subworkflow with the item list update action. The table has columns ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an SQL query to put different WFD_AttText attributes into one DET_Att column and different Att_Choose values into one DET_Value column into the 'value' column, so that the 'email' and 'phone' attributes get good (...)
(...) "Update Item List Values" action, so I used a workaround: "Clear Item List" + "Update Item List Values" / Add new rows from the data source. Do you also have such a problem? However, using the SQL query instead of the BPS source and filter works fine. My BPS version: 2023.1.3.76 Regards D.
(...) ne know how to use the 'Edit a list element' action to update a document element in a SharePoint document library that is in a sub folder in the SharePoint document library? I am trying to use a CAML query and while I can find documents in the root document library, I can't get the CAML to find documents in a sub folder in the document library. I should mention that this appears to be WEBCON specific s (...)
(...) Hi! So I have this Item List in "Orders app". Lets say it has 10 columns. 6 Of those columns can be editable depending on subprocesses or other proceses. So there is a query , that if returns 1 it means that column can be edited by a user, if 0 then the column in this row is blocked. For that I am using "Column edit restrictions" from the "Permissions" tab in the studio. And it works great. For few r (...)
(...) Is there any way to hook into an api that is hosted on a localhost? I have a locally fired server, I use FastAPI (the tool is built in python). In browsers the API works. However, when I try to run a query on a form I get this message. I have already tried restarting DNS, disabling the firewall. The server is on startup and the server is listening on port 8000. I am new to webcon and just learning. Th (...)
(...) he problem appeared? Version installation: current -> 2023.1.3.76 target -> 2023.1.3.118 In changelogs there was information about changes as to the columns in the AdminWFEventLogs table. Last query from profiler: IF EXISTS(SELECT * FROM sys.columns WHERE Name = N'WEL_Details_Deprecated' AND Object_ID = Object_ID(N'dbo.[AdminWFEventLogs]')) BEGIN (...)
(...) f subfolders for attachments, depending on when they where added. As far as i understand, i will need to use the action 'Delete a list element'. I see that i can either give it an ID or use a CAML query (first time user here; just started reading about it). I most definetely need to use the CAML query since there can be more than one document that needs deleting but i am also curios about that ID. (...)
(...) g for the Subworkflow and there a Tab that should get the status. For that I created a Data table and put the technical field as the filter. And when I test this I get a huge error message from the query test. With that I think that I am either doing something increadibly wrong, or it will be a simple thing like a checkbox I am missing. Which of the 2 is it and how do I fix this? Thanks in adva (...)
(...) ExceptionServices.ExceptionDispatchInfo.Throw() bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) bei WebCon.WorkFlow.BusinessLogic.Helpers.Sqlquery Logger.d__10`1.MoveNext() --- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde --- bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() bei (...)
(...) Hello everyone, I have to generate a Choice Field based on a query that have an aditional filter. The filter should only allow entries that are higher than a Decimal Field in the Form. Somthing like in the Picture. But this did not work.... Has someone an Idea?
(...) rameter. The Rule is working, Oracle procedure gets executed (witness on Oracle db) and most probably returns l_out. My question is: how do I get the l_out value? Tried another Rule parameter but query not working any longer. Thank you, Mihail
(...) rsion 2021.1.2.143 (getting ready for upgrade) I try to invoke a REST API to update form fields, and I get a proper response from the service, however, it doesn't update the fields. I'm using OData query to filter and expand the data, and load the response definition from the service. The action configuration and action log with response are on my pictures. What can I be doing wrong? The respons (...)
(...) ment a choice field (Autocomplete or Popup), whose results should be dependent of the following: 1. Current step 2. If second choice field is selected, it should narrow down the results from a subquery (Item list) First of all Webcon doesn't accept a DECLARE statement in the first line of a custom datasource based on 'Current BPS connection'. A workaround here is the 1. statement (IF (1=1)). (...)
(...) ed a typed source - leave history and leave types. This source collects absence information from many other processes. Unfortunately, the Gantt chart shows only part of this data, even though the SQL query returns all of it (currently 3715 records for approximately 80 employees). I added a Gantt chart in the BPS Portal and limit it to the current month and one month back and one month forward. Why isn' (...)
(...) Index (zero based) must be greater than or equal to zero and less than the size of the argument list. SQL query : SELECT 111 as WFD_ID , 222 as PATH_ID
(...) Hi, I have a following problem. I've created a data table form field that downloads data from SQL query . In the where clause, I refer to the value of another ‘Criterion’ field on the form. The data table should display the data depending on the selected criterion. Unfortunately as I change the criterion, the table sometimes fails to refresh and displays the data for the previous criterion. How do I (...)
(...) Hi, I have one major problem with the Add privileges action. It works when I add privileges to single users but doesn't apply when I choose a group as a USER / SQL query . On the Instance level there is information that the Group has privileges but members of the group do not have access to the instance. Additionally when I add privileges to the group manually users of the group can see the c (...)
(...) Dzień dobry Mam problem z wykonywaniem akcji globalnej, która ma za zadanie startowanie obiegu sql. W zapytaniu zastosowane jest open query do serwera oracle. Przy teście zapytania lub puszczeniu akcji globalnej dostaje błąd z załącznika. W management studio zapytanie jest wykonywane normalnie Proszę o sugestię Wersja Webcona 2022.1.4
(...) Inside custom columns we can access wfelems, which as far as i know is based on V_WFElements - if we could get DTYPE_GUID, DEF_GUID, WF_GUID there it would make that process easier - instead of subquery per column, we could get those just from what's already there :) Example query inside custom column: IIF((SELECT DTYPE_GUID FROM WFDocTypes dt WHERE dt.DTYPE_ID = wfelems.DTYPE_ID) = '51a1dfbc- (...)
(...) 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