search results

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

Hello, I would like to create 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 solu

Hi, it would be great, if the 'Search panel' configuration would allow the positioning of the 'Search everywhere' field. Currently this is always displayed at the top which makes it really tempting to use it for searching, even if there's a dedicated field has been added. While this is not necessarily an issue, it may become one depending on the search phrase. In our case it takes almost

(...) an endpoint that returns the required data. To achieve this, I planned to use a global action (cyclical). First, I created a business rule that fetches the data using a REST API. Then, I wrote an SQL query that utilized this business rule to retrieve the data. However, when testing it, I keep encountering the following error: WebCon.WorkFlow.BusinessLogic.BusinessRules.Exceptions.BusinessRuleEval (...)