search results

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

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