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

search results

for sql

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

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

(...) Adding possibility to add sql row as a column could be also a workaround to achieve that. Right now (BPS 2020...434) is is only possible to add instance number from system fields to mass notifications.

(...) ts/post/using-calculated-columns/196/3) but that's not my case. What I would like to do is join the items from the report to a table in a different database (on the same server) or to an existing MSsql data source. In many processes I have a global field with the unique identifier. I would like to use this key for a 1:1 join. I can show the join results on the form (using Data row field type) but n (...)

(...) Hello everyone, did someone update the database compatibility level from the default 'sql Server 2008 (100)' to a newer one and can share their experience? I really would like to make use of those "new" functions instead of using hard to read workarounds. Best regards, Daniel

(...) Hi all, i hope you are well. We have moved our PROD-Environments Databases to a different sql Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old databases are offline. Currently there is still an alias configured, that routes (...)