Database

Portal Logged Users

0 1

Hello everyone. Is it possible to select all authenticated users in the portal with the date and time of authentication?

How to update a record in wfelementTasks ?

0 1

I used to update this table and chagne wft_user and WFT_user name. But from the version 2023 i got Update or insert of view or function 'WFElementTasks' failed because it contains a derived or constant field. Is there any other way to udpate the column in wfelementtasks?

CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER

0 1

Hi, Following a security audit, we are compelled to set the CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER. I'm not an expert in SQL. What impact does this setting have on Webcon? Thanks, Raluca

Remove data of instances no longer in archive database not working

1 1

Hello, As usually, after encountering an error during tests, I have tried to Remove data of instances no longer in archive database option. Unfortunatelly, it is not working. Blue bar is sliding from left to right for about 10 minutes now. In Designer Studio, I can't remove the steps associated with the corrupted task, and the task also can't be removed because it doesn't load. Is there any tip, how to remove that? Best regards

Sharepointless database overwrite

0 1

Hi, Suppose I changed Webcon to a version without sharpoint. I have a PROD database and I would like to select the last year from the database and overwrite TEST, is this possible?

Creating sql views on BPS_Content DB

0 1

Hi, Is it ok to create a custom SQL views on BPS_Content DB? Does webcon allow it? Best Regards, Bartek

MS SQL Server - changing the authentication mode and collation

0 1

Hi, Due to requirements of another system: 1. I need to change the authentication method of MS SQL Server from Windows to mixed. Any risks connected with such operation? Or Webcon should be working just fine? 2. A need to change the collation of the SQL Server. Are there any risks connected for running Webcon service here?

OPENJSON does not list all fields

0 1

Hello everybody. I'm trying to display all the JSON fields, but I can't. Thanks to anyone who can help me. 1 - JSON structure '{ "status": "SUCCESS", "VentaPajaros": { "codigoClient": 13216598, "composicionParcelas": [ { "id": "07" }, { "id": "08" } ], "pago": { "fechaprimerpago": "09/12/2022", "datosventa": { "valor (...)

Split databases

0 1

Hey, now all 4 databases (Config,Content,Content_Arch,Content_Att ) are on the same MS SQL server. Do you have plans to give opportunities to host each DB in deddicated server? For example - to have 4 MS SQL Server , 1 for each BPS database.

Reports - SQL Function

0 1

Can I use sql function in computed report columns?

How to check users in actions using queries

0 1

Hello all, Hope you're doing great! Does anyone know how to configure a query which will return where a specific user was set in any action? I'm using this article https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3 but I want to also check where for example the user is hard coded for the Task Assignment for example. Hope you got ideas! Thank you

Report execution - takes too long

0 1

Hello, I have designed a solution for users so they can access their workflow documents via a simple report, that shows a list of documents with links. This seemed to be the most user-friendly way of presenting documents list. The report shows a list of documents from specified document flow definition. Unfortunately, the report runs very slow, even though there are not many documents in the database yet (about 40), and the users have to wait until the page refreshes. Are there any parameters t (...)

exceeded the quota

0 0

I am using the free version with a limit of 10GB. Recently I received a message - Failed to execute 'setitem' on Storage: Setting the value of 'ExpandFormButtonLogID' exceeded the quota. I checked and the base was 9600MB. I did a shring database and reduced it to 4500MB. Today, I have the same error with a 4600MB database. Is this the end of working with the free version?

Downloading attachments to a local disk

1 0

I would like to print attachments that are attached to selected tasks (with specific IDs) so that I can print them. It would be enough if I could automatically save them to the local disk. Does anyone have any idea how to do this? Plese help:(

Using SQL script to update WFD_Signature in WFElements

0 0

Currently I'm migrating files from SharePoint to a custom built WEBCON DMS application. Normally the Instance number is generated according to a rule which is perfect for new files. The customer wants to keep their document numbering. For the existing files I would like to update the Instance number (Database: WFD_Signature) using a small SQL script. But is it safe and is it wise to do that? I'm aware the numbers need to be unique in the system, and I know they are unique in the old system. (...)

Setup SOAP web service

0 0

Hi, we would like to use the SOAP web service in WEBCON (DBVersion 2022_1_2) . How can we get the delivering result? Webcon by default marks only the "Messages" area. See screenshot. Unfortunately, other markings are not possible... Thanks a lot! Florian

How to modify the "basic role" of a database

0 0

When trying to import an application, WEBCON BPS Designer Studio tells that the operation fails. I may check if the role "Import" as been started for the actual database. Where can I check this? Where can I activate this role? Thanks for any help. ---- Issue solved: The "basic role" message has been shown due to the fact that the BPS service was in "Safe Mode". The "Safe Mode" issue - in this case - has been solved by updating the license information and restarting the service (...)