WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for query

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