most commented

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

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

SQL Update on WFElements table

0 9

Hi! I have a process which generates subprocess (list is from sql query). The subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors occurred. Operacja została wycofana Concurrency Error Concurrency Error" In attachement you can (...)

Remove Item from collection

0 9

Hi everyone! Am I blind or there is no function oposite to COLLECTION, that would remove an element from collection? How do you manage to overcome the lack of this function? I came up with an idea of making a JS form rule that takes a collection and removes a value given in one of the parameters. It works. But there are limitations that make the solution inelegant. First of all the form rule can not return a value (in opposition to business rules, but those however can not contain Javascript (...)

Automated email for inactive users

0 9

Hi, we have created a data dictionary with people picker field. This people picker field has few team member names. I need to setup a process to check the dictionary everyday if there inactive users. If inactive users found, send email notification to Admins. Please suggest the best way. Thank you

First synchronizing user AD list

0 8

Hey, I am synchronizing the user list according to the instructions. I have filled in the domain, the user has the right to view AD, I have checked it by adding a new data source and the data appears there. However, after pressing the Synchronize now button, the message Task has been added to the service appears and nothing happens. No entry in the history appears either, as it is shown in the instructions. What could be the cause? Maciej

Start subworkflows from excel sheet

0 8

Hi Community! Is there any possible ways to start subworkflows from Excel file? Business case is that, I have MS Excel file with estimated 500 rows. I want to attach sheet to attachments section and start workflow by path or button on menu bar with starting workflow action. Is any way to do it without special SDK customization? Subworkflows should have data from in excel sheet. Every workflow contains one row.

[solved] subworkflow started from item list is started twice

0 8

Hello, I have an item list where, upon leaving the step, each data row is sent to a separate instance into another application via a subworkflow action. Unfortunately, I have the problem that if I have more than 2 datarows, my subworkflows start the instances twice

[solved] Copying Attachments from Itemlists to Individual Instances in Subworkflow

0 8

Hello, I have an item list where, upon leaving the step, each data row is sent to a separate instance into another application via a subworkflow action. However, when attachments are copied to the subworkflow using the checkbox function, all attachments from the entire item list are copied to each new instance. Is it possible to configure it so that only the attachment associated with the specific data row is copied to its respective instance, instead of copying all attachments to every n (...)