most commented

Retrieve output parameter value from Oracle procedure

0 1

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 (witness on Oracle db) and most probably returns l_out. My question is: how do I get the l_out (...)

Calculated Columns with If conditions

0 1

Hello, I need to set up two columns to calculate some KPIs for a report. The first one will show the status based on Case statement and date difference: (select case when DATEDIFF(day,WFD_AttDateTime3,getdate()) >0 then 0 when DATEDIFF(day,WFD_AttDateTime3,getdate()) = 0 then 1 else 2 end) The second column should pick the number of instances that have the conditions DATEDIFF(day,WFD_AttDateTime3,getdate()) = 0 DATEDIFF(day,WFD_AttDateTime3,getdate()) < 0 and then divid (...)

.

0 1

.

Run SQL procedure action

0 1

Hello, I have a question, a curiosity... In the WFDataAttachmets table, there is a column called ATT_IsDeleted. If I want to Run SQL procedure (webcon action) and update table and set the ATT_IsDeleted column with 1 or 0. Is it a good practice? Or is it not allowed? Thanks.

Moving back the instance by using the “Back to the previous step”

0 1

Hello, I have STEP A and STEP B both going into STEP C. In STEP C I have made a path called BACK where I've put as destination step "Back to previous step", but now I'm wondering if I can set up an automation with actions that will act differently depending on where it goes next, STEP A or B. Is there any way to do this? Thank you!

Concurrency Error on timeout

0 1

Hello everyone, I have a workflow where data is imported and instances are created. After the import, a timeout (minute) is defined which further delays the instance. A field value (multiline text) is set on the path. At this point, the workflow encounters an error (Concurrency Error). However, if I manually pass the WF instance on the path, the field value is set correctly. I hope someone can help me. Thanks in advance. Error Stacktrace: Nachricht Fehler Setze Symbol - Fehl (...)

Check status/step of subworkflows

0 1

Hello everyone, I am new to Webcon so it might be a dumb question. Anyway, I am trying to create an App where one Department starts one Workflow that creates subworkflows for several other departments. The main Workflow should be able to see the current status/step of every subworkflow. But with what I did, I am getting 2 Errors [Form] "Failed with an unknown exception Fehler-ID: d1a18cc6-c67d-43bb-b883-66e3584445e9" [] "during saga execution: Failed with an unknown exception". See the at (...)

File attachments can be edited by all users

0 1

Hello everyone, Is it possible to set the attachment function so that users can upload files in all workflow steps? Currently, in my app, this only works if the user has editing rights for this instance. But I don't actually want that the users have editing rights on all instances and do not want to create complicated rules, that then unlock the overall rights, but immediately revoke the rights for certain fields. In the field matrix I can only set the attachements checkbox to visible or in (...)

report permission

0 1

Hi is there a way to get from the database all the permissions to all the reports that we have ? I was not able to find any column with that information and I do not know how to get such info

Discard User Checkout

0 1

Is there any way to influence the user checkout behaviour (i.e. force discard after x ammount of time) when users are only saving an instance but not ending the edit mode of the form. I currently have the issue that there are several users who are behaving like this and we aren't able to convince them to either close their browser window/tab or at least click "Cancel editing" after they have saved their progress. I know there would be the potential risk that data is lost if i force the discard (...)

Column 'Login' does not belong to table Results

0 1

Hi! We're stuck with an error using the Send Custom Email action with the default User or Group attribute as the Recipient, after updating from 2023.1.2.123 to 2023.1.3.118. Any tips on how to resolve this issue? Thanks, Patryk

Set up Onedrive connection

0 1

Hello all, Does anyone configured a Onedrive connection in Webcon? I'm following the topics: https://community.webcon.com/posts/post/integration-with-aad-using-rest-invoke-method-and-microsoft-graph/117/18 https://community.webcon.com/posts/post/adding-attachments-to-onedrive/183/4 https://community.webcon.com/posts/post/working-with-onedrive-files/341/18 But this is explaining on how to configure using MS Graph and Rest API. However, in the connections area, there's one specific for On (...)

I really despair of this application!

0 1

So this application is incredible... without words how much it can get on your nerves!

Callapse the categories in attachments

0 1

Hi, Can I collapse the categories in attachments by default without using JavaScript? Thanks, Raluca

Remove Personal Data Action

0 1

Hi, Have you encountered this situation? I deleted some instances using the 'Remove Personal Data" then "Archive workflow instances' action. Both actions delete the instance, but the instance's signature remains in the WFElementSignatures table. Thanks, Raluca

Tables: WFActionExecutions ,AutomationSessionExecutions

0 1

Hi, Are there any issues with deleting rows related to cyclical actions in those tables (WFActionExecutions ,AutomationSessionExecutions )? Thanks, Kuba

Filter report current user

0 1

Hello, I have 2 form fields - Person (Assignee, Manager) I would like to create a report and filter that 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 (...)

Delete process

0 1

Hi, Can you help me with advice on how to quickly delete a process that is no longer in use? I should mention that the process has form rules/business rules/actions Thanks, Raluca

Form validation

0 1

Hello, I have a big problem. I have an order form, e.g. for a contractor, and I have created a data source that shows all the orders of this contractor. Additionally, Kontrahnet has a monthly order limit entered in the field I need the system to check whether the limit has not been exceeded during the next order. Please help me how to do this

Menu action refreshes a form and moves to the top

0 1

Is there any way to avoid refreshing a form after invoking a menu action? The problem is that it moves the form to the top and the form flashes.