WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Database

Database

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:(

Hello, Does anyone can help me, how can I see WEBCON tables via MS SQL Server Management Studio? What the process of connecting to the WEBCON server looks like? When I tried to enter the server name (test.company.corp) into MS SQL Server connection dialog box it didn't work. Regards

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

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

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.

MVP

Hi folks, today I have a special problem and hopefully somebody of you already has a solution. I am working on an internal Knowledge-Database. One given requirement is: In case of an update, the old entry has to be archived and a new entry with all previous information should be created to be edited. So far no problem - except for the attachments. I dont want the old attachment files to be copied to attachment section. Instead of that it would be nice to have a DATA TABLE with _li (...)

Hi, I can't delete one step from my workflow. First problem that I have is there is some active elements associated with this step. I deleted it on webcon portal but after that operation I still have comunicate at workflow designer: "The database contains workflow instances associated with this step. You must delete those elements first in order to delete the step". On which SQL table I can find that archive elements? Any ideas how can I fix it? Thanks advance for your help.

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

Hello folks, The query in the attached image is not working in the designer, but working flawlessly on the same DB in the MSSQL Management Studio. Is there the possibility that the designer somehow does not like "ROW_NUMBER" function? Or is it a Webcon bug? I hope someone has experience with this already. Thanks in advance :)

Dear Community, I have a question regarding attachments database. Size of the database is quite large and I'm trying to find optimizations here. Table / index compression is not a solution - compression ratio is barely reaches 0,5% level. I have found a lot of records in this database where attachments are deleted (column ATF_IsDeleted = 1). Is it safe to remove such records from database or it will make inconsistency of the data? Do you have any experience in it? Looking forward for any (...)

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.

MVP

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