search results

Hi all, first of all: this is not supposed to be a moaning complaint, just a heads up so other people 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 querying field IDs. It hit us on some neuralgic spots in our main workflow, causing quite some

(...) s, and 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 (...)

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

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

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

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