search results

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

(...) Hello all, I have a data table field where I'm selecting the fields using a SQL query . One of the field is a picker and I want to show just the Text and not the ID. I've tried many options but as soon as I try using the Database-Name, it's giving errors. I believe it's because the option has space on it : 'Non Ok'. But the system should overcome this right? Even using the DBO function, it doesn't (...)

(...) ered if they are used in an item list data row column.: https://community.webcon.com/forum/thread/5247 I tested the most common/likely elements and to verify which are supported by using this SQL query : select 'a tag' + ''+ 'button tag' + ''+ 'div tag' + ''+ '' + ''+ 'img tag' + ''+ 'input tag' + ''+ 'p tag' + ''+ 'span tag' + ''+ 'strong tag' + ''+ '.class'+char(123)+'display:none'+ c (...)

(...) into process [1] via a subworkflow. The data that comes from process [2] is in an item list and should all be entered individually (as separate instances) into process [1]. Before this, however, a query should be made as to whether the respective instance of the specified person has already been entered in process [1]. Problem: I can't seem to access the value of the item list (qualification) in (...)

(...) ce with something. I am currently working on a Business Rule that should return a value using SQL. The Business Rule needs to be as universal as possible, and I want to pass two parameters to the SQL query . So far, so good. The issue is that I want to pass the same form field as a parameter twice: once as a value and once as a "column name" (essentially as an object value that I can transform in SQL (...)

(...) } = '{WFD_ID}' The big question is, why was it working in the first place and only failed in production? The production database contains way more data and the SQL server decided to execute the query differently. Test system: The index of the choose column wasn't used, which "magically" allowed the query to work. Production system: The index of the choose column was used which contains text an (...)

(...) alParams/UserSynch/SynchConfig/LDAP I'm trying to make it work, but all entities (users, and groups) are being synchronized as groups. From the error log it seems like Webcon is generating LDAP query with an error - the OR - | - operator seems to be in wrong place: - (8/12/2024 8:29:33 PM) Searching LDAP://ldap-server:389/DC=ldap,DC=goauthentik,DC=io?uid,gidNumber,objectClass,accountExpires,ad (...)