most commented

Task Delegation Fails with 500 Error (Works in Swagger)

0 10

Hi everyone, I’m working on a feature, where single button triggers a set of actions that grants permissions across related parent and child workflows, and delegates active task to other user using REST API. I'm currently facing a frustrating issue with the task delegation API using the endpoint POST /api/data/v6.0/db/{dbId}/elements/{elementId}/admin/tasks/assignment When I use this endpoint via Swagger, the task delegation executes successfully. Here's a sample of the payload that works p (...)

CTE SQL no longer usable as Data Source ?

0 10

Hi, ver. 2025.2.1.91 Is there any changes to CTE SQL availability when used as a Data Source? After the update from version. 2025.2.1.42 to 2025.2.1.91 we found that all functions using CTE from Data Sources stopped working. Strange - when you use CTE in the action config, it still works. Can you confirm whether it is a bug or not ? Error: Error in On path action Wgrywa nadgodziny (zrodlo danych). (Step: Rozliczenie nadgodzin, path: Pobierz nadgodziny) Error getting data for (...)

Link to the workflow element

0 10

I'm creating an email that is supposed to have a link to the workflow element in the message content ? i cannot seem to find a variable related to it ?

How to check and assign task in subflow to users in item list column?

0 10

I have Item list [slave]with column where I can pick people (from other item list [master] which contain 1. BPS users, 2. AD users (some of them are in BPS users - not all) and others - people out of AD and BPS. 1. I would like to run sub flow for each row of item list (done) 2. fill proper data (done) 3. assign to people from item list [slave] : a) assign to all BPS users and skip non BPS users and others b) if any of people is not BPS user then assign to person from form (who is BPS use (...)

[solved] Source AD - grab just "manager" name to item list

1 10

Unfortunately I can't use as source "BPS Users" and I need to change source to "AD Users". The BPS Users have 100 users but AD Users have 300 users In both sources I need name of Manager. I use item list with dropdown list with Autocomplete when source id BPS user is fine but if I switch to AD Users then I would like to column "manager" but it give me: CN=John Doe,OU=Users,OU=Employees,OU=CTM,OU=People,DC=xyz,DC=xyz,DC=local and I need just "John Doe" in text box ...

User reminder

0 10

Hi, Is it possible to remind the user to save the form after adding several items to the item list (WFD_SubElems). I ask because users report a problem, such that they forget to save (click on the transition path).

Periodically updating data via rest

0 10

Hi everyone, I'm wondering what would be the best approach for the following use case. There may be between 300 and 500 active claim workflow instances. The costs for these claims are tracked in the ERP system. The total of the costs needs to be in the claim, so that it can be used in reports. Challenges: 1. I can only use REST for retrieving the costs 2. The ERP system supports webhooks, which doesn't help us. 3. The total changes only rarely, I don't want to create a new version for (...)

Problem calling the data source

0 10

After installing a new development environment, I have a problem with performing an SQL query to the BPS_Config database. The environment was installed with my administrative account. From the database level, I can also see that the users of the service and the application pool (db owner) have permissions to the database. The application pool is the account indicated in the installer as the user to connect to the database. The message itself points to a SID that I don't have in my domain. Every (...)

Using dictionary process data in action “start a subworkflow (SQL)”

0 10

Hello community, I am building application with one Dictionary process, and one standard process with 2 workflows. I would like to start second workflow many times as subworkflow of fist workflow and assign it to the several users/users groups (one per subworkflow) selected from Dictionary process. I am trying to use action “start a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – Query returning data) works as follows: SE (...)

Fixed values list on the database

0 10

Hi everyone, I wanted to ask if anyone knows where or in which table the "Fixed values list" are stored. I am using a "Start a subworkflow (SQL)" to migrate data from our old sharepoint workflow tool to Webcon. Unfortunately, it seems that Webcon has decided that 'Choice fields' always require a GUID#Name to be populated. (Without this format I get an error and the subworkflow does not run). Now I have some Choice fields that use Fixed values lists in Webcon and I need to concatenate th (...)

STARTING SQL SUBWORKFLOW USING ITEM LIST FOR DIFFERENT COMPANY'S

0 10

How can I in here write dinamic company from my item list (My company is in DET_att5) ? Or I have to do another way ?

Don't understand Foreach / For aach Action

0 10

Hi there. Trying to familiarize myself with the for each action. I have an item list an I want a business rule to evaluate the value for each row of a certain column (choice field) an execute an action for it. Unfortunately, as soon as I have more than one row in the item list, the BR evaluation will fail as it attempts to test against all the row values for the specified column. My BR uses: IF[GET IDs[SELECT VALUES[Item list | Column]]] = [Choice field id] I guess there must be (...)

Support for Azure SQL

4 10

Hi there, as far as I know there is no official support for Azure SQL for the WEBCON BPS databases today. If we implement WEBCON BPS in a customer's own Azure tenant as their private cloud, it would be smart to use Azure SQL, because of the integrated HA features, scalability and low maintenance effort. WEBCON BPS is very well integrated with Microsoft technology and has great integrations with Microsoft services, i.e. M365. I would strongly appreciate, if support for Azure SQL could be added in (...)

Standard-Mail vs Custom Mail - Taskdetails in mail

0 9

I have a workflow with these steps: * Start => *Approval Task name: "upon approval" Task details: "check and approve the order" If I use "Standard Mail" in Task-Creation via Task-Configuration I get these info in the mail: "Approval - upon approval" "check and approve the order" => all correct If i use "Create Custom Mail" in the action on path i get: "Start - upon approval" "check and approve the order" So the stepname is not correct evaluated ... or am I missing something he (...)

Error when executing Menu button action

9

Hi Folks, whenever I try to execute [Menu button] action, which should open a hyperlink, I get an error: "Error in Menu button action Start Counterparty Card. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_WFElementDatails_WFD". The conflict occurred in database "BPS_Content", table "dbo.WFElements", column 'WFD_ID'. The statement has been terminated." I have exactly same button configured in other workflow in the same application and it works fine. It is irrelevant wha (...)

Generate an Excel from an Itemlist

0 9

Hi guys, i just have another question... we need to create an Excel file from an item list. Basically, this works well using an appropriate Excel template. However, I have fields in the item list that are filled from a fixed value list and the action then creates an entry in the column in the format [ID#Name]. But I only want to see [Name]. What am I doing wrong?

Data sources - Fixed values list - API

0 9

Hi, Are "Fixed values list"s' content available through API? Not dictionaries or other process types, but "Fixed values list" object types only. The need is to synchronize Webcon data with other systems, assuming Webcon repository is master. I found this article https://community.webcon.com/forum/thread/2491 which states that there would exist /api/data/v4.0/db/{dbId}/elements/resolveFieldValue/{idguid}, but this kind of call results in 404 - not found error. I did not find resolveFie (...)

Same Action, many Paths

0 9

Hi all, I am currently building a process in which it is possible to go back to the 'start' step from almost any step. (There are 10 steps that can go back to the 'start') Now I have an (1x) action (action template) that should be performed when someone selects the path to 'start'. Is there a better way than adding this action to every path? (Adding the same action to all paths that lead to the same step again and again is simply inconvenient and contradicts the "Don't repeat yourself" (...)

Data source filter issue (dictionary process)

1 9

Hi, After updating BPS to version 2022.1.4.111, I can't see the data source columns for dictionary processes. This applies to creating filters. Fixed value lists do not have this problem. What is causing this problem or change in behavior?

Save space on SQL server with ATF_IsDeleted?

0 9

Dear Community, I have a question regarding attachments database. Size of the database is quite large and I'm trying to find optimizations here. Table / index compression is not a solution - compression ratio is barely reaches 0,5% level. I have found a lot of records in this database where attachments are deleted (column ATF_IsDeleted = 1). Is it safe to remove such records from database or it will make inconsistency of the data? Do you have any experience in it? Looking forward for any (...)