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

search results

for sql

Have you ever faced the challenge of managing documents where multiple signatories need to sign on different pages or in specific positions, and didn’t know how to handle it?  We’ve developed an intuitive interface using HTML and JavaScript within WEBCON that allows each signatory to select the exact position of their signature on each document. This innovative functionality u

(...) External content by Daniel Krüger; November 10, 2024 ;  The original post has appeared on daniels-notes.de With WEBCON BPS 2025 the maximum supported compatibility level is 160 (sql Server 2022). Change log: Changed the default compatibility level for new sql databases created during the installation of the WEBCON BPS platform. As a result, the previous compatibility level set to (...)

(...) de choice After accepting the license terms, select "Update or expand an existing WEBCON BPS installation" in the installer's main menu. The installer will then connect to the sql server hosting the databases of the WEBCON BPS environment. Starting with WEBCON BPS version 2024, if the installer detects that the sql Server certificate is not trusted, it will display the followi (...)

(...)         "Enabled": true           },           "sql Tracing": {             "Enabled": true,             "Show (...)

(...) list retrieval are implemented using Microsoft Entra ID. The described installation consists of: WEBCON BPS 2025 Standalone installed on a Windows Server machine without Active Directory MSsql server with authentication based on sql login A local service account and application pool Authentication of users to BPS and synchronization of the user list are performed using Microsoft Ent (...)

(...) n (by default, this is the account on which the Workflow Service runs). The latter will be important for privileges, both to the network share and to the databases (if integrated login is used in the sql connection parameters). The PowerShell action can only be executed in the context of a workflow instance, so it is not possible to add such an action in cyclical automation. This simplifies config (...)

Applies to version: 2022 R1 and above; author: Konrad Keppert   Related documentation License Activation Service WEBCON BPS License activation Configuration of Portal-Service communication and selection of Nettops protocol   Introduction In the standard platform configuration, the name of the machine on which the WEBCON BPS components are installed is stored i

(...) s the names of the workflow phases for the instances displayed in the report, as determined by the step in which the instance is located. The column is available for reports with both SearchIndex and sql sources and can be used to configure Calculated columns, default filters, row coloring, dashboard value filtering, etc.       Business rules and Form rules Workflow ph (...)

(...) e Base. Additional options to expand on this could include:  Calculating “FileName” and “FileType”  Using categories  etc. Here’s the MS sql SELECT statement to copy and reuse (replace the {...} placeholders with the actual field values as shown in the image): SELECT   CONVERT(image, CAST(STUFF('{10380}', 1, CHARINDEX(',', '{10380} (...)

(...) FROM WFDataAttachmets WHERE     ATT_WFDID = {WFD_ID}     AND dbo.ClearWFElemID(ATT_Attribute1) = 1     AND ATT_IsDeleted = 0   In this field, you must define an sql query on the WFDataAttachmets table that returns the ID of the attachment to be signed. For this scenario, the query is limited to the current instance and filters attachments from the To be signed c (...)

(...) exception in this regard. This article aims to outline timeouts based on example scenarios across the following areas: automations, operations performed by the service, HTTP requests, T-sql transactions, It highlights which of these limits are configurable and which are determined by the underlying infrastructure. The article does not cover limits that may affect the behavior o (...)

(...) d on daniels-notes.de In my latest post I covered my personal No-Go's and their alternatives when using WEBCON BPS. The topics are: Fixed item lists and logic Dictionary data sources sql Queries Always add a filter for the company Use order by, when using Top Build-in Users business rules Using the author field You can read up on those here. When you a (...)

(...) ie). Starting with version 2019, this configuration method is no longer supported, and the following requirements now apply: Values in the ID and ParentID columns must be of the integer type. sql queries using the WITH clause are no longer supported, as they are blocked and may lead to errors in some environments. It is now possible to select intermediate nodes (e.g., teams), even when usin (...)

(...) hin the transferred content database.   5. Recreating source databases from backup The content, attachment, and archive databases of the source environment must be recreated on the same sql Server instance where the target environment databases are located. If the source database names are already in use on the target instance (e.g., both environments use a content database named &ld (...)

(...) </body> </html> I used the CONCAT function to create the text and stored it in a local variable Create the attachment To create an attachment, you can also use sql . In this case, you have to provide a Filename and a Content column. The type of the content needs to be VARBINARY(MAX). The conversion of text to varbinary can be done with the Convert func (...)

(...) Hi, with the introduction of BPS Portal we got a few additional options were we can add "code" and where variables from the expression editor would be useful if not even mandatory. 1. Report - sql Filter, there are a few variables there already 2. Calculated field in Reports and BPS internal view, no option to use existing variables 3. Report - advanced formatting, no options to use existing varia (...)

(...) Hi, just a simple, easy request - can you please add a usefull code editor to sql rules, JavaScript rules and HTML fields details ? Sure, one can copy paste the code from external editors, but it takes time, having an embedded editor would be a great feature.

(...) Hi, so HTML attributes are great, but only untill you try to do something with them - like hide for example... or export - import Seems like you keep them all in a single sql field:-( So, some JS manipulation is needed, rule editor is useless. Can you make normal HTML attributes - every attribute in separate sql field?

(...) positive. I thought about using the advanced settings, but I have no idea how. Documentation: You can also define the path dynamically. To do this, select Use advanced settings and create a suitable sql query in the Advanced path choice field. When is this executed? a) When the first sub-workflow is started b) When one sub-workflow finishes c) When all sub-workflows are in state finished Verificat (...)

(...) l to users from item list? I think it will be nice to have this option directly in "Send a custom email" action configuration". For now you have to use intermediate solution to get users list using sql /CAML querry.