(...) w. Data Population in the Itemlist Itemlists can populate data either dynamically or statically. Dynamic initialization typically involves integrating data from various sources, often using sql scripts that can range from simple to complex. Once the script is created, the columns from the sql output are mapped to the itemlist to ensure accurate data transfer. Alternatively, static initializ (...)
(...) es.de Even though this is quite old, it still works and it can help others: If you are providing multilingual user interfaces this post can provide you with little helpers to generate sql statements: For multilingual choose fields. Multilingual icons If you aren’t interested in these then you can still take a look at the sql command stubs: Get (...)
(...) External content by Maksymilian Stachowiak Starting Webcon journey usually begins with moving some data from other places, let it be sql databases, but when more applications are created you still might need this knowledge to migrate further processes. In this series I'm creating an example application into which I'm importing data using built in cyclic actions, and external powershell sc (...)
(...) nly now updated to optionally collapse the the attachments. Thanks for the request. :) The linked blog post also contains a small documentation how to use the Category and ElementName field of the sql statements in the related attachments. READ MORE: here.
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 (...)
(...) ash; scribe, which defines the context and role of the AI Agent within the workflow. Input data, such as notes and summaries from previous meetings, are automatically retrieved using a business rule (sql Command) that extracts the relevant information from the database. In the subsequent Verification step, the user can review the summary generated by the AI Agent, make any necessary (...)