(...) Hi I'm having trouble on adding a MSSQL Database data source on data source s -> Connections -> MSSQL database as I keep getting the error message below: "Unknown error: A network-related or instance-specific error occured while establishing connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote conn (...)
(...) Hi, when you want to add a new new report tile with a link to the "details" in WEBCON BPS 2024 you have to: 1) Choose a data source 2) Choose an existing report The current implementation forces us to create the data source twice. While the effort for the data source creation may be neglectable, I'm quite sure that a lot of us will forget to update both data source s. Especially because it will be ra (...)
(...) I would like to propose a change to the Process Import/Configuration grid. It would be great if the names: data source s, Fields, Constant etc. were in a separate column (if it were possible to sort/filter by this column it would be great :-) ). With many data source s, finding the one I don't want to import is not easy.
(...) month. The user (author) updates the data and submits it for verification. I proposed the following procedure: 1. I created a BPS source that lists all 10 reports from the last month. 2. The BPS data source has columns including: ID, Signature, Author, Company, etc. 3. In the cyclic action, I added automation and the "Execute for everyone" operator, where I indicated the above-mentioned BPS data source (...)
(...) reports (simple/advanced) dont show any past vacations. We updated to 2024.1.1.161 after finding changelog notice, that some problems with vacations report were repaired. Our config: We use a data source with SQL view with past vacations, 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 (...)
(...) one of our systems started to enforce compression for its HTTP responses. They are now compressed as gzip which leads to an error when trying to access data from the system using a REST Web Service data source in Webcon. I can help myself by implementing a custom data source , but if there is a native solution, I would be glad to hear about it.
(...) [Location] 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 :)
(...) ess rule works fine. Setting this one into an ALERT all members are returned as expected. Using 'testgroup' as string in the group picker of the function GROUP MEMBERS ['testgroup'] in a filter of a data source works fine and all members are returned as expected. But using the AD-Group field in the function GROUP MEMBERS [AD-Group Login and name] in a filter of a data source always returns no result. The (...)
(...) t if one would have a global function in system settings like it is for global CSS for form rules that shall be loaded for all forms automatically when set. Maybe it could be realized like it is with data source s. This means one has to connect a global form rule in system settings to forms individually or with the global option "load global form rule to all forms". The last idea would just need a new checkbo (...)
(...) Hi, ver. 2025.2.1.91 Is there any changes to CTE SQL availability when used as a data source ? After the update from version. 2025.2.1.42 to 2025.2.1.91 we found that all functions using CTE from data source s stopped working. Strange - when you use CTE in the action config, it still works. Can you confirm whether it is a bug or not ? Error: Error in On path action Wgrywa nadgodziny (zrodlo (...)
(...) While parent & children are not archived, everything is just fine, but when you archive any of these elements, datatable/row gets empty and datatable shows that "No data preview ... archived ...". data source s are custom T-SQL, but I suppose that's not the problem. I need to show the data within datatable / datarow no matter the element status. Thank you, Mihail
(...) Hi, for compliance and data protection reasons it would be great if there would exist more permissions. A junior developer e.g. doesn’t need access to data source s, system settings. An idea would be to have more permission roles for apps, data source s, system settings and so on. It would be nice too to have some kind of environments as they are known in Microsoft’s Power Platform. So different teams c (...)
(...) Hello. I'm testing new User defined API: I have endpoint for data source . When I tested it manually, it works. But when I tried 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([Invo (...)
(...) Hi, data table /rows display the values as they are returned from the data source . In case of the MSSQL data source this is fine for text fields and for choose fields, integers/decimals we can work around it. Either by using the available functions or using format functions and the current user language. In case of date time there's no work around. The issue is especially visible when users are loca (...)
(...) WEBCON works on ver. 2024.1.1.130. We have a few dashboards with created data source s for reports. After data source s, we created reports but using this data source s, not creating new one in Designer studio or in Portal. Now, users gave us information about lack of access to one of the reports which uses data source . Inside configuration of dashboard we have option to change priviliges but if the report (...)
(...) Hi, it would be great if in the section data source s of the Designer Studio all entries (authentications, connections and all types of data source s) could also have group containers as they exist e.g. for form/business rules. Flat lists miss structure and having more and more entries lead a bit to confusion. The only way to get structure is having a really good naming convention right now - what is always (...)
(...) Hi, Let's assume I'm configuring data from a data source (a report) with one column and one filter. I want to use a User-Defined API that allows me to dynamically filter the report using a defined endpoint. Will the response return a simple JSON with information from this single column, or will it return the entire data set (element ID, signature, step, etc.) as in other responses?
(...) I would like to be able to add a hyperlink to a choice field and make the selected value clickable. Just selecting a column in the data source which provides the link would be sufficient, however building it through an expression like the "Link to a form for adding an object:" would be the best possible solution. For example, we are using a data source that is connected to our project management system si (...)
(...) team to build their diagrams? Or maybe this is already documented and I'm just missing the link? Later edit: I wanted to add the post to the „Database” topic but unfortunately it ended up in the „data source s” one. If an admin can move it, I will be obliged.
(...) cess via sharepoint lists and the protocol that I want to achieve it with is by using cyclical actions. I've created an automation that is runing subworkflow(sql) and there is a problem with mapping. data source has exact values that I need, and I'm using them as intended but the problem is I'm getting data rows I don't want and even then those queried fields are still not applied to created instances after (...)