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

search results

for sql

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

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

(...) or group" field where the picker is limited to a group. 2) I added the "SearchAllTables" stored procedure to look for any occurrence of the BPS_ID of the group. https://ignas.me/tech/searchalltables-sql -stored-procedure/ Note for myself: I should add a second stored procedure which only searches through relevant tables. Best regards, Daniel

(...) CON BPS. I would like to have at least the last modifying users migrated as well. How could i achieve this? Was thinking about setting a technical field to the last modifying user and then doing an sql Update on the element after migration. Sure this is not the way that is officially supported. But is there another way?

(...) cation for the new candidate. There are some issues with this, I'm not able to initialize the item list with the dictionary details (only DB or Sharepoint is available), I don't want to do this by sql query because in the future I will need to do maintenance work if something changes. And the user doesn't want to click Add for all the options needed. I don't have many ideas on how to this. (...)

(...) instances that have the searched term somewhere in the metadata. If i do a global search I get hundreds of hits - so the documents are properly indexed, and can be found when searched. The report is sql based. Portal Version is 2020.1.3.411, but I couldn't find anything in the bug fix lists about a behaviour like this. Although there were a few bug fixes prior to version 411. I have the same behav (...)

(...) ication containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an sql Update directly on the WFElements table, but I am struggling by running this query by (cyclic) action on a separate path. The path is walking through fine according to the history, but no changes in (...)