WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for sql

(...) Hi I'm having trouble on adding a MSsql Database data source on Data Sources -> 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 rem (...)

How to access values of the 'datasources'? -> The query only returns the ID of the datasource.

(...) Hi there, Is it possible to use one datatable to show different tables from a sql server? Right its possible to filter the sql results based on a value in a certain column. I also want to make it possible to show the content of a different table, however account to the infobox to the right side of the textbox where i write the sql statment, its not possible. So i was wondering if there is an alterna (...)

(...) nt, 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 pain right now. If you still have to update to 2023 make sure you tes (...)

ORIGINAL SUBJECT WAS: Assistance Needed – Retrieve "Content as Base64" for All PDF-Attachments of an Instance Dear All, I am currently looking for a way to extract the "Content as Base64" for all attachments associated with a specific instance. My goal is to obtain a single text line in the following format: 'Base64 PDF 1', 'Base64 PDF 2', 'Base64 PDF 3'. -> The easiest way would be to us

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

(...) Hi, I need to build a process that will work as a service, check a mssql table, and start the process if new rows are added to the table. Single process based on a single row in sql table. Maybe someone has built a similar functionality? Best regards.

(...) Does someone know how to fix this problem? The cleaner fills our sql server with error messages that took 20gb of space after few days. This Error occours even when using a different version and virtual server.

(...) Hi everyone, I have a scenario where, in one of our workflows, we use the “Move Workflows (sql )” action on a transition path to update multiple workflow instances—often dozens or even hundreds. Each of these updated workflows executes several actions upon transition, including making a REST API request to an external system. The issue arises when, for example, out of 150 instances, 140 complete (...)

(...) It is possible to show the value form sql Row on Webcon report? Is this functionality planned in future versions of the system?

(...) h stage we have 2 system accounts: Prod: service_webcon service_webcon_iis Dev: service_webcon_dev service_webcon_iis_dev In the production environment the user service_webcon_iis has NO sql rights and is configured as user for the application pool. service_webcon is used for the service. So far so good. So we prepared the accounts for the dev-stage exactly like the accounts in the pr (...)

(...) Anyone suggest me a best method to recover corrupt sql database.

(...) Introduction of sql query based reporting model to reports with the capability of current table reports functions

(...) Hi, until two hours ago, I would have said, that you can't use AI to help with sql command generation and documentation. Then I started playing around VS Code. My POC switched my opinion completely. Can something like this be added. :) The first two images is the generation of an sql statement and how the result is interpreted by the Designer Studio. The last image is the documentation of a (...)

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

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

(...) able in the template. The good option is to create the dictionary processes – for more information, see Dictionary processes.   Fig. 10. Attachement section   The sql query returns the attachment ID because the attachment versions are stored in the database. You must select the current one –for this, add TOP 1 and ORDER BY ATT_TSUUpdate DESC. ATT_WFDID is th (...)

(...) eld is set by the “Set Nett Amount in PLN” form rule which uses the “Nett amount in PLN” business rule. The business rule returns a floating-point number calculated with an sql query. The sql query returns the result of multiplying the value from the “Nett amount” field and the average rate of the selected currency, where the invoice date is the effective date o (...)

(...) sitive value for each type of transaction.   Fig. 10. The configuration of the "Change value of a single field" action   The last action is “Move a workflow (sql )” that moves the “Account” workflow to update the amount in the “Balance” field. In the configuration window in the “Parameters” tab enter the “_Update (...)

(...) : Franciszek Sakławski   Introduction When creating the configurable e-mail templates there is the option to add fields from the form. This article describes how to add an item list and sql data table fields.   Fig. 1. A list of fields available in the system   To enter these types of fields in the template is needed: Basic knowledge of HTML language (spe (...)

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings