search results

(...) ly idea right now is to remove the class which causes this via JavaScript in the HTML field, so that it is aligned with the other controls (2). document.getElementById("SEL_HTML_#{WFCON:7009}#").query Selector(".grid-template__panel .upsidePanel__content").classList.remove("upsidePanel__content") or with CSS: #SEL_HTML_#{WFCON:7009}# .upsidePanel__content {margin-inline-end: 0px;margin-inli (...)

(...) Hi everyone! After upgrading to version 2025 we noticed that the Advanced settings are not working in the same way as they were in the previous versions. The query that was working just fine before is not doing its work. Does anyone else have the same experience? If this helps, this is the query that we're using: IF ( /* Number of all child workflows */ SELECT COUNT(*) FROM WFElemen (...)

(...) dont fall for the issue that hit us today. I wanted to share some info regarding the update from 2022 to 2023, as we ran into some very unsatisfying issues with SQL COMMAND business rules that are query ing field IDs. It hit us on some neuralgic spots in our main workflow, causing quite some pain right now. If you still have to update to 2023 make sure you test every SQL COMMAND based rule (and da (...)

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

(...) and API call fails with 401 The question: is there a way to have that global constant request suffix NOT ENCODED when concatenated with the server base URL? As it is part of the call address, not query params for the call. Thanks, Mihail

(...) nd all type of data in columns are correct: VAC_UserID VAC_From VAC_To VAC_VACTypeID SQL: select * from [V_Urlopy_Historia] After some tests we've done: After manually entering the sql query on TEST SERVER (2024.1.1.161) that indicates a specific time range, user and vac_type - data appears in the report. BUT ONLY if the query concerns a maximum of 2 days. If the query has more than 2 da (...)

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