search results

(...) BPS) to the content database, causing them to stop working. Therefore, they must be updated by changing the address, name, and/or credentials of the account used for the connections.   If sql queries (data sources, Run an SQL procedure actions, business rules containing the SQL COMMAND function) include explicitly defined database names, these must also be updated if they have changed.   (...)

(...) rsquo;s name Remarks ASP .NET Core Instrumentation   SqlClient For Portal and Service it is possible to view sql queries . HttpClient   WCF Client Integration with Service * For traces WEBCON BPS supports data export by the OTL (...)

Maybe this is simple and I'm just overthinking it. I'm creating new proposals, each new proposal has an automatically generated # associated with it (PFY2021-xxxx). I have the form rule built to create the string, but I need the number portion to append. The xxxx number needs to increment for each new record entered. I can't seem to create an "application wide" variable that I can reference, c

(...) Hi all, I was wondering what the best practice is when using sql queries in Webcon with attributes, tables or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This means that (...)

(...) Hi, I have a problem with the execution of sql queries in different environments using a Default connection (after moving the system to AZUR-e servers). SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parameter that (...)

Hi everyone, This might be a big one, but on one of latest webinars I've heard that there is open 'Designer Studio' project at Webcon, so I'll give it a shot - if not now, then I'm not sure if there will be a better time ;) I think most of us have used SQL Server Management Studio or Azure Data Studio to test some queries, and maybe a VSCode / Notepad++ for some powershell - all of those suppo

(...) eciate any advice, ideas, or suggestions on how to approach this. Any pointers on how to capture and log these actions would be incredibly helpful. I was thinking of potentially tracking the internal sql queries but I need to know which user accessed the data specifically and I'm not sure I can engineer a solution that tracks background queries anyway. And this does not solve the issue of users accessing cac (...)

Hi, Current Situation: Data Sources are typically static and context-independent. Each Data Source is bound to a fixed query or API call, with no native mechanism to pass parameters dynamically. As a result, any variation in use (such as retrieving different columns, filtering by different criteria, or adapting to different workflow contexts) requires creating multiple Data Sources or embeddin

Hi everyone, I’m running into an issue with calculated columns in a WEBCON BPS report and I’m wondering if anyone has faced something similar or found a workaround. I have a report based on some workflow, and I’m trying to add a calculated column that returns the value related to a given element in report. The value is stored in a table located on another SQL Server (linked server), which is alr