search results

Applies to version: 2023 R1 and above; author: Łukasz Maciaszkiewicz   Introduction The logic behind the execution of tasks by service is a multi-faceted and complex issue. When planning tasks, application designers are often unaware of the mechanisms and rules used by the service. To fill this gap, this article describes the elements affecting the sequence in which the service exec

(...) the default behavior is not enough.   The Solution Fortunately, WEBCON BPS provides a way to solve this quite readily using a technical field, an automation action, an extra path, and a SQL query .   Part One: The Technical Field Create an extra field to be used by the parent workflow of type Date and enable time selection under Advanced configuration. Part Two: The Au (...)

(...) ate SELECT clause. Rather than counting task responses, it lists them (the author and the chosen path). As such, the rule should return all rows, not just the first one:   The specific SQL query text is: SELECT CONCAT(   WFT_UserName,   ': ',   SUBSTRING(WFT_FinishPath, CHARINDEX('#', WFT_FinishPath)+1, LEN(WFT_FinishPath)) ) AS [Vote] FR (...)

(...) y due to the processing of each database table row. This process is particularly time-consuming, especially in the case of large data collections. Additionally, the syntactical complexity of the SQL query containing the aforementioned function can make it difficult to create a correct and effecive query. To counter those problems we have employed indexed choice columns that offer an alternative to (...)

Applies to version: 2023 R3 and above; author: Krystyna Gawryał   Introduction Version 2023 R3 introduced the ability to use the CONCAT function within the LIKE function to create advanced filter conditions on Data sources. This is particularly applicable when configuring Choice fields, allowing the list of returned values to be limited to those required by the user. This article

Applies to version: 2023.1.x and above; author: Marcin Smarzewski   Deactivating Licenses on Test and Developer environments Before mirroring the environment, it is recommended to deactivate the test or development license service (depending on which environment will receive the production mirror), Doing so will make it possible to activate the license service without assistance. If

Dear all, what would be the best practice to update/change the Business Entity of an instance? Background: I would like to create an application containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggl

(...) Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing (...)

(...) a column that is mandatory to be filled whenever the item list has any rows and I tried many examples to construct a validation form rule in order to have information on that column. I was using a SQL query because: - Column cannot be required (there are cases that the user is sending documents so the item list will be empty) - Form rules using Condition By Row cannot be used inside the form validatio (...)

Hello, I'm wondering is there a simple way to do this. Sometimes "SQL COMMAND" returns nothing (there are no rows that match the query). How do you test for this? IF "SQL COMMAND [...]" = EMPTY does not seem to work. Maybe there is a workaround?

(...) Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allow a littl (...)

Hi, After upgrading from 2021.1.3.205 to ver. 2021.1.4.84, I can see a very big performance drop for reports that have more than 250k items. Very often they don't even load at all. All indexes and sql statistics are rebuilt. After verification, I found the reason, it is the column 'assigned to'. After removing this column from the report, all large reports are loaded almost immediately (even those

(...) Hi, I add new connection (MSSQL database) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has no (...)

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

(...) m Wfelements where WFD_DTYPEID='77(Dictionary ID)' AND WFD_ID='Instance ID' AND WFD_ATTchoose1 = '{Form name}' and WFD_Attchoose4='{Step Name}') THEN 1 ELSE 0 END Is my SQL query wrong?

Hello, Lately I was thinking about SQL optimization. So I did this query on production environments of our 4 random clients. The query shows where probably we should be thinking about putting index, because of high usage of those columns. Of course we all know that putting index on WFElements with attribute columns is not a good idea (maybe if you have secondary BPS_Content for only 1 process cou

(...) s performed through SQL queries that retrieve the users from the active directory. To support a simple configuration of the AD group names process constants are used to define the group name. 3.1) SQL query for the first user assignment Here no filtering is required except the appropriate AD groups: SELECT users.COS_BpsID FROM [dbo].[CacheOrganizationStructure] as Users join [dbo].CacheOrganizationS (...)

(...) Hi, I have a following problem. I've created a data table form field that downloads data from SQL query . In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date formats. I (...)

(...) d be really handy especially if there are some flaws in process and some rows on item list that shouldn't be there. Now if you want to delete them by action you have to use Replace Values option with SQL query that returns only rows, that you want to leave in the form, so other rows are going to be deleted. The problem is that every row is deleted and than rows from SQL query are added so every row have ne (...)

(...) Hi all! We want to add some rows to an item list with 'Change item lists values' action. The SQL query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which results i (...)