Database

Reports mails

0 1

How to check all the emails that are in our systems ? If i use the WFMails than we see the ones that are currently being sent right? But how to get the data from the all emails that we sent in general?

Translaation query from database

0 4

we are currently in a process of compare which translations we have and which we do not. I do not want to do it by going through each application than dowload the excel but I would like to generate a report with app,worfklow and form fields where there is no tranlsation. Can anyone help me with this issue?

the time of editing a given ID by a user

0 5

In which table can I find information about the time of editing a given ID by a user? Mayby do you have a query?

Admin mode in archive element

0 2

Hello, I have element in archive database, when I click admin I show error "Cannot read properties of undefined (reading 'showTitle')". How it fix?

Adding MSSQL Database datasource

0 1

Hi I'm having trouble on adding a MSSQL Database data source on Data Sources -> Connections -> MSSQL database as I keep getting the error message below: "Unknown error: A network-related or instance-specific error occured while establishing connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections." I have attached the image of information for my msssql server. On the Webcon (...)

When is a user synchronization finished?

0 3

Hi everyone, I have a process which updates the group members. This is done in async mode because the synchronization takes a while. I'm trying to prevent updates by moving the workflow to a step which checks whether the synchronization is finished. As far as I found out so far a job get's added to the [UserSynchronizationQueueItems] of the current content database and it maybe get's deleted when the job is processed. At least I thought so, because the job got deleted some time after th (...)

dbo.WFAttachmentFiles

0 2

Hello, I have noticed that some attachments for some apps are stored in [BPS_Content].[dbo].[WFAttachmentFiles] and some in [BPS_Content_Att].[dbo].[WFAttachmentFiles]. I am not sure what the cause might be, but I have observed that the attachments in [BPS_Content].[dbo].[WFAttachmentFiles] belong to older applications. Is it okay for it to be like this? Thanks.

[solved] Database Backup Type

0 2

Hello! Why does Webcon suggest configuring simple recovery model for the databases during installation? Does this only apply for the installation process or is this also recommended for the productive system? For which Environment does this apply?

Substitutions

0 1

Hi, I have a question regarding Substitutions - BPS_Config. In the Substitutions table, the SUB_isActive column is 1, even if the period has passed. If I delete the Substitution, only then it will be 0. Is it supposed to work this way? How can I see the active Substitutions? Thanks.

Liczba niestandardowych pól w tabeli

0 4

Czy system pozwala na użycie wielu dodatkowych pól niestandardowych? Ilu dla danej tabeli?

report permission

0 1

Hi is there a way to get from the database all the permissions to all the reports that we have ? I was not able to find any column with that information and I do not know how to get such info

Tables: WFActionExecutions ,AutomationSessionExecutions

0 1

Hi, Are there any issues with deleting rows related to cyclical actions in those tables (WFActionExecutions ,AutomationSessionExecutions )? Thanks, Kuba

Sql query to list all of the application

0 1

HI I need by sql query to outline the list of the appliacation that we have and a workflows to a choice field. How can I do if the app is on Main_Db and we have apps on Main_db and main_db2?

How to transfer the database to a new server ?

0 2

Hello, how to transfer the database to a new server? I have no problem with transferring processes in WEBCON Designer Studio, but how to transfer data?

All uses of connections and data sources via SQL query

0 8

In Designer Studio it is possible to check the use of a single connection or data source in the context of all processes. Is it possible to get such a list for all connections and sources using an sql query?

Best practices steps to backup and restore db PROD on TEST

0 1

Hi I'm looking for steps or best practices how to do it correctly - restore db prod on test env ?

Information about deleted instances

0 2

Hi, Does anyone know where in the database I can look for recent activities? I mean the ones that are on the Dashboard, specifically "Delete of instance".

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?

Recovery Pending and HTTP error 502.5

0 4

My database goes into "Recovery Pending" mode which causes a program HTTP error 502.5. Restarting the SQL Server service solves the problem, but this has happened several times, does anyone know why this is happening?