WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Most commented

most commented

MVP

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

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

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

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

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 ?

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

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

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

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?

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

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

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?

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

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

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

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

[Webcon 2024.1.1.130] (i thin it was working in 2022.1.4.404 - but I need double check] I have action to update item list where source is Parent Item list. The sql query is working but filters .. works if there is no polish letters :| so: [code='SQL'] SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL:1135} AS 'Sygnatura Audytu', d.{DCNCOL:1132} AS 'Tytuł raportu 8D', d.{DCNCOL:1131} AS 'Norma', d.{DCNCOL:1128} AS 'Punkt normy', d.{DCNCOL:1126} AS 'Opis', (...)

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

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.

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