search results

(...) Is there any way to compare the Production and Test environments? To compare the configurations of the same process between systems? In order to track changes. Do you have any sql , etc.? Do you use github or something else?

(...) io reports that the connection is in use. The usage sheet reports that the connection is not in use. I found where it is used... I searched in studio and indeed the 'Workflow' connection was used in sql command.

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

(...) report based on these 2 columns. It is working fine, until Assignee/Manager is multiple value. If there are 2 persons assigned, it doesn't bring that instance in the report. This is my formula (sql filter): and (WFD_AttChoose1 like trim('##currentloginname## ' )+'#%' OR WFD_AttChoose6  like trim('##currentloginname## ' )+'#%') Do you have any tips? T (...)

(...) of a choose field from a data source throws and this causes an error, it's not easily possible to see the actual "request" which was used to get the data. There are ways around this: - In case of sql and you have access to the server you could activate the sql profiler - In case of rest/soap requests you could add an http interceptor which can be used as a proxy. If you don't have access to (...)

(...) eitung Produktion, Pfad: Ja) Concurrency Error Log Error code: 100 Einzelner Wert: Attributwert von "Symbol - Fehlerhafte Rezepturen" auf "" geändert. Concurrency Error bei System.Data.sql Client.sql Connection.OnError(sql Exception exception, Boolean breakConnection, Action`1 wrapCloseInAction) bei System.Data.sql Client.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj (...)

(...) if I have signature of flow "ZAM/2024/03/00188" then "The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction." if I do sql SELECT [ATT_ID] FROM [WFDataAttachmets] where ATT_WFDID='{2592}' and in test field is "20008" then I see in designer 4 attachments but in action from (menu button) -> error .. the same (...)

(...) Hello, We have set a working Oracle connection. There is a procedure with 2 params, one IN, another OUT. Running a Business Rule containing a sql Command against the Oracle connection: declare l_out NUMBER; begin ZZ_WEBCON_TEST.TEST_PROCEDURE(P_IN => {BRP:21}, X_OUT => l_out); end; where {BRP:21} is a Business Rule decimal parameter. The Rule is working, Oracle procedure gets executed (...)

(...) /copy-attachment-to-other-workflow and https://community.webcon.com/forum/thread/3240 [quote="Daniel"] you using the function would be one option. Other are: - Set the local parameter using an sql command - Use the for each function to iterate through the attachments - Use the for each function in combination with a data source - Use the for each function in combination with "any collection (...)

(...) Could be nice to add BB Code or other tags used in Forum or information what type of Tags can be used for me I would like to use: [code][/code] or [code="sql "][/code] using code wil help read code - see attachment [quote][/quote] or [quote="name"] [/quote] [B][/B] - bold [i][/i] - italic ect. then is nice to use FF plugin or type tags ...

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

(...) Process can only be moved to Finish if all the rows have a match So this works, if I just have one row. In the control steps, For Each is not available so I will probably have to check this using sql command? Does anyone have suggestions? Thank you

(...) ld we please get an option to define whether we want to set a choose field or only the id of the choose field? See the attachment as one example. I have an item list with a drop down and a fixed sql statement with multilingual values. Assigning the id to the column in a for each loop does not resolve the display name and the "id" value is treated as the display name. The "solution" aka workar (...)

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

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

(...) Hi, Can I achieve such an effect in an calculated column? In sql it works but in webcon I have an error If atrubut is empty display the grouped attribute from the item list Code: select ISNULL(WFD_AttChoose5, STRING_AGG (CAST(DET_Att1 AS NVARCHAR(MAX)), ';')) from WFElements W left join WFElementDetails WD on W.WFD_ID = WD.DET_WFDID group by WFD_AttChoose5 What needs to be corr (...)

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

(...) hing accepted, like single line, and then you can delete the column and then change it to data row in order to keep your report. In this case the error GUID will show: "...Invalid column name 'SEL_sql Row'." version: 2023.1.3.169, but I don't think the version matters. I hope we get the option, at some point, to manually remove such column from your report if it was added before when it was no (...)

(...) cription b) attachment 2. I start child process a) copy data + copy attachments b) i would like to populate the same in child item list with records correlated with coped attachments ... I did sql source: [code="sql "] SELECT e.DET_ID as 'ID wiersza dziecka', e.DET_WFDID as 'ID Elementu Detalu dziecka', e.DET_WFCONID as 'ID Listy dziecka', e.DET_Att1 as 'Rodzaj dokument (...)

(...) rivate view without having to mark each result. Each time this view is opened, it would present the results for that phrase. Currently, results need to be marked manually, or such a report with an sql filter has to be created administratively.