search results

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