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

search results

for SQL

WEBCON: Business Process Automation and Management as its best WEBCON develops the Low-Code Business Process Automation Platform, WEBCON BPS (Business Process Suite). This enterprise-grade system allows organizations to embrace digital transformation by digitalizing their workflows and building comprehensive, scalable, process-centric and future-proof applications applying t

(...) Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction The Run an SQL procedure action allows you to invoke SQL procedures from the WEBCON BPS form level, and to prepare the universal SQL queries with variables. This functionality is limited only by the capabilities of the SQL query language. It is possible to invoke SQL procedures using data in the WEBCON BPS form an (...)

(...) Applies to version: 2022.1.x and above; author: Jacek Język From WEBCON BPS 2022.1.1, the lowest supported SQL Server is 2014. In the case of WEBCON BPS installations using the higher versions of SQL Server, WEBCON BPS databases work with the compatibility level set to SQL Server 2014 by default. Changing the compatibility level from SQL Server 2014 to SQL Server 2019 is possible, but you (...)

(...) Applies to version: 2022.1.3 and above; author: Maciej Kieblesz   Introduction This article describes a method of maintaining databases to ensure the highest possible performance of the SQL engine, and thus the BPS application itself. In practice, this will mean a reduction in the number of 'timeout' errors, for example, when loading a report. This mechanism is tailored to BPS d (...)

(...) We have a use-case, where people need to export data from an SQL -Grid to Excel for data-verification. Unfortunately the export to excel only allows exporting the header + 999 rows of data - At least i couldn't find a way to raise the limit. It would be very helpful to get a parameter for a variable maximum row count for the Export in the SQL -grid configuration. Thanks!

(...) , the user creates a row. To start my subworkflow I'm using as conditions having the candidate name as not null and a flag set to true and i'm using this as an execution condition with the following SQL : if exists ( select 1 from WFElementDetails where DET_WFDID={WFD_ID} and DET_WFCONID={WFCON:1726} and isnull({DCNCOL:119}, '') '' and {DCNCOL:118} = 'Yes' ) select 1 else select 0 But (...)

(...) We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from tabl (...)

Hi all! I need to create an email alert that will be triggered if a Task Assignment Workflow is created for a specific user. My goal is to check if that user is a User Cal (has a Webcon licence) and if not send me an email so I can give the user the access required. I've created a Send custom email and I'm trying to define the execution rule that will be checking the previous statement. My

(...) or all workflows and translations. Values are shown depending on the users browser language. It simply shows which step was left with which path, by which user, at what time. I present this in an SQL -grid in the forms where I think it will be helpful to the users. It can be very helpful even in the preview form in reports. Attached 2 screenshots with german and english browser. Please excuse the (...)

(...) It would be great, to have some kind of IDE in the Designer Studio while editing SQL or Javascript code. Therefore it would already help if there were line numbers and code highlighting e.g. for opening and closing brackets. Sometime it is difficult to manage your own code when it reaches a certain number of lines. For example, if you have a Javascript code and only one semicolon or closing bra (...)

(...) Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoi (...)

(...) I'm struggling with the syntax of the SQL filter for a report. In general it works, but if I want to use the currently loggedin user, I get an error. I tried with the following syntax: AND (##currentloginname##='servr\Userxxx') The error message is: "Incorrect syntax near '='. Incorrect syntax near ','. Incorrect syntax near the keyword 'order'."

(...) When the user sets up a Subworkflow using the SQL version, it's not possible to save the ID of the instance created. This is only allowed doing other type of actions and most of the times returning Concurrency Errors in the system. This is allowed already in the Subworkflow normal version.

(...) just stumbled about an action which executions hasn't been logged. The reason is simple, the according checkbox wasn't ticked. If you want to verify that all you actions are logged you can run this SQL statement. It displays all actions which aren't logged. Maybe for a reason or due to some misconfiguration: SELECT AGR_Name, APP_Name, DEF_Name, WF_Name, STP_Name, ACT_Name FROM [dbo].[WFActio (...)

(...) Hello, I'm wondering is there a simple way to do this. Sometimes "SQL COMMAND" returns nothing (there are no rows that match the query). How do you test for this? IF "SQL COMMAND [...]" = EMPTY does not seem to work. Maybe there is a workaround?

(...) Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allow a (...)

(...) fixed. You can get an overview of all ids and which fields, tables you need to replace in the above command from: SELECT * FROM [dbo].[DicTranslationsObjects] The attached image shows the executed SQL command and the drop down values for the German language. Best regards, Daniel

(...) Hi there, as far as I know there is no official support for Azure SQL for the WEBCON BPS databases today. If we implement WEBCON BPS in a customer's own Azure tenant as their private cloud, it would be smart to use Azure SQL , because of the integrated HA features, scalability and low maintenance effort. WEBCON BPS is very well integrated with Microsoft technology and has great integrations with Micro (...)

(...) Hi, After upgrading from 2021.1.3.205 to ver. 2021.1.4.84, I can see a very big performance drop for reports that have more than 250k items. Very often they don't even load at all. All indexes and SQL statistics are rebuilt. After verification, I found the reason, it is the column 'assigned to'. After removing this column from the report, all large reports are loaded almost immediately (even those wi (...)

(...) Can I use SQL function in computed report columns?