search results

(...) of the action will fail, if the integer values are not the same on both systems. In the worst case the value does exist for item list on both systems but for different ones. You can use the below query to get all actions which have a faulty configuration. Best regards, Daniel SELECT TOP (1000) ROW_NUMBER () OVER ( order by actionDefinition.ACT_ID asc) as RowNumber , actionProcess.DEF_N (...)

(...) The problem is that in my leave of absence workflow I have an action that sets up substitution for the time a person is out of office. When I run a test (see left side of the enclosed screen) the SQL query shows correct dates of substitution (the same as te person's absence). When the acton runs the substitution is set to last for one day longer than expected. Why is this like that? Where am I doing so (...)

(...) e step ... where I have 1 person and no waiting for other to finish - it was easy .. but if in step I have assigned 2-3 people and one of then is behalf then ... is more difficult ... SQL query : [code="SQL"] SELECT WFH_ID as 'ID of history', WFH_STPID as 'Krok ID', WFH_FinishDurationDateTime AS 'Data ukończenia kroku', WFH_LeaveCurrentStepPath, WFH_LeaveCurrentStepD (...)

(...) 3:30) 'Return single element ID for attachment step' started. (21.01.2025 14:13:30) 'Return single element ID for attachment step' completed in 0ms (21.01.2025 14:13:30) 'Build elements attachments query step' started. (21.01.2025 14:13:30) 'Build elements attachments query step' completed in 0ms (21.01.2025 14:13:30) 'Get attachment metadata' started. (21.01.2025 14:13:30) Downloaded 1 metadata r (...)

(...) In my scenario I will have very often negative steps Solution 1 option to solve all path put to positive step and use wait for all positive and forget about problem Solution 2 set sql query where it will wait for all subflows doesn't matter positive / negative and if all will finish then will go by 1 path common for all results. I did sql query : [code="sql"] SELECT e.WFD_ID (...)

(...) 19:02:51 msg: Step2 src: Upgrade 06-02-2025 19:02:55 msg: Sql version: 14.0.3480.1 src: SqlServerVersionChecker 06-02-2025 19:02:59 msg: Url to Solr: http://[SERVERNAME]:8983/solr/BPS_Activities/query ?q=*:*&q.op=OR&indent=true&fq=TS_Insert:[2025-01-06T19:02:59.060Z%20TO%20NOW]&fq=-User_Name:"WebCon%20Workflow%20Service"&rows=0&wt=json 06-02-2025 19:03:01 msg: System.Net.Http.HttpRequestException: (...)

(...) Hi, I'd like to build SQL query that uses 'current BPS database' and at the same time uses linked server that exists on that server. So I want to do sth like that: Select * from BPS_Content.dbo.WFElements t1 left join [my_linked_server].[database].[schema].[my_table] t2 on t1.id = t2.id Unfortunately it doesnt work. I got an error in Webcon Studio "Access to the remote server is denied becaus (...)

(...) te a new data source in the MSSQL Database category that would retrieve information from a list of values ​​​​from the form and other attributes on the same form, but I don't know what such a correct query should look like. Currently, my query is only able to retrieve information from the attributes themselves, but not from the list of values. Edit: I found the solution.

(...) Hi Guys, Is there any way to configure paging for the item list? Got one with > 280 rows, initiated from the SQL query . I cannot use data table to display the data only, as users need to add comment for each row in one of the columns.

(...) Process attributes > Attribute of a Select type using a BPS data source > Filtering section [The bug] In a data source filter, when using the ALL_TRUE operator, the WHERE condition in a generated query is prematurely simplified, what results in an SQL error. [Workaround] Chain AND operators. [Fix] Please fix the SQL translation of the ALL_TRUE operator :)

(...) In our case it takes almost one minute until the search is executed. This is due to the fact, that the SQL server breaks the search phrase into a a lot of parts which has a dramatic effect on the the query . A little background, the search result returned 4 rows and we have only 10795 workflow instances in the table yet. One improvement for our case could be if we switch to a SOLR based report. We (...)

(...) Hi all! Is there an easy way to list all the privileges (and scopes) for applications, processes, associated form types, dasboards and reports? Maybe someone already wrote a query for that or can point us in the right direction? Thanks a lot in advance & best regards, Nik

(...) where each user has an id, if i change any of these attribute fields, changes need also to take effect in the dictionary. There is a specific field that will trigger this action. I already created a query that will map correct attributes with update command. I'm interested in the logic that would need to take place in obtaining the current changes. thoughts: - after triggering specific field in th (...)

(...) Is it possible to insert into wanted dictionary related item via sql query or else ?

(...) Hello community, I need to start a workflow instance for each email address in a text, where the addresses are separated by semicolons. My plan was to initialize the Item List using an SQL query , and then to start a subworkflow (SQL) instance for each row (email). Since our WEBCON environment doesn't support STRING_SPLIT, I fabricated a custom SQL query to split the long string into individual rows (...)

(...) m the current element could be set as the main visible tab. Maybe this option already exists and I haven't found it yet - if so, please let me know. Additional idea - currently, when using SQL query for related attachments, we are limited to 3 groups of attachments. It would be much more flexible if SQL could return a column like GroupName, allowing attachments to be grouped dynamically without (...)

(...) ed to do GET via API I got empty response. GET: {{env}}/api/udef/db/1/MTBVENDOR?ComCode=PL12&InvoiceNum=ASDF&InvoiceDate=2025-08-25 RESPONSE: STATUS 200: { "Data": [] } when i check sql query for data source is like this: (([InvoiceNum] = N'ASDF') AND ((CAST([InvoiceDate] AS DATETIME) = '2025-08-25T00:00:00') AND ([ComCode] = N'PL12'))) and i works. Do you have idea what can be a (...)

(...) hides when I check the item list to readonly mode. Is it a feature / bug? Is it planned to be changed? Does any workaround exist, except the showing data table with the same result (and e.g. my query returns over 1k rows which is data table limit). I am aware that the form slow downs but is not crucial in that case :) Best Regards, Dominik

(...) er for user to enter directly search phrase rather than choosing from list, even filtered values (sometimes user have to check multiple options that meet search phrase). Additionally it skips one sql query used for generating list of values in filter. It could be defined on report parameters or available to switch by the user.