Database
Hi! I have a process which generates subprocess (list is from sql query). The subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors occurred. Operacja została wycofana Concurrency Error Concurrency Error" In attachement you can (...)
Hi Guys, Has Webcon any function or script to extract the [Comments] field in the "human eadible" way? Lets say DATE | AUTHOR | COMMENT TEXT. Selecting from WFD_Description for particular ID gives me output like below. It is becoming more complicated if I have two or more comments, divided by ','. SELECT WFD_ID ,WFD_Description FROM [BPS_Content].[dbo].[WFElements] where wfd_id=xxxxx output: [{"d":"2022-02-21T14:40:40.086895","l":"username@domain.com","a":"Name Surname","c":"Text (...)
Can anyone recommend some good calculator or formula to calculate the database size increment for demo applications and N users over time? Condition (no attachments are uploaded) something like: application A or B * user or process * month = yMB data size Rather, it is an order of magnitude to evaluate for these ready-made sample demo applications As far as the attachments can be estimated, I am interested in the scale and speed of the database growth at the beginning based on the (...)
Hi, I noticed something strange in the database values for a choice field - a hash in front of the ID (screenshot attached). Has the behavior of the database changed? In the documentation I still find it's supposed to be ID#Name, no mention of a hash. Best regards
Can I use sql function in computed report columns?
I know that in webcon report there is only possibility to show only one "Item list" attribute but is there any possibility to create some technical data table or atribute to show more than one list? Or maybe you can give some example of SQL function which select more than one "Item list". Thank you in advance for your help.
Is there a supported way to change the Acronym of the content database after the installation?
Hi there, as far as I know there is no official support for Azure SQL for the WEBCON BPS databases today. If we implement WEBCON BPS in a customer's own Azure tenant as their private cloud, it would be smart to use Azure SQL, because of the integrated HA features, scalability and low maintenance effort. WEBCON BPS is very well integrated with Microsoft technology and has great integrations with Microsoft services, i.e. M365. I would strongly appreciate, if support for Azure SQL could be added in (...)
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
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 (...)
Hi, I have noticed that you can create multiple content databases on one Webcon installation. Why and how would you actually use that? It would be great if you could segregate the instances of different business entities in different databases, but I am not sure that is possible. What else do you know about this subject of multiple content databases on the same Webcon portal. Thanks, Razvan
Is it possible to use CTE Tables in sql commands in the attribute configuration? If yes, could someone show me an example?
Hi, I have a project where I can't save attachment in a webcon database storage(becouse of company policies). I am looking for a solution to store attachments on network drive. Is there possibility to change localization of attachment ? May be some workaround? Some action, rule, ect? I thought about action which will create a folder on shared drive and webcon form will show information to user where to store attachment. But I don't know how to achieve this:/ Any idea?
Hi all! I need to create an email alert that will be triggered if a Task Assignment Workflow is created for a specific user. My goal is to check if that user is a User Cal (has a Webcon licence) and if not send me an email so I can give the user the access required. I've created a Send custom email and I'm trying to define the execution rule that will be checking the previous statement. My query is the following: SELECT UCL_BpsID FROM WFElements JOIN CacheOrganizationStructure as G O (...)
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 traffic that might go to the old SQL-Server to the new one, which is okay, but nothing we want to (...)
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
+48 12 443 13 90