search results

(...) le with a status of 0. I do not want all outstanding e-mail notifications to go out after changing the password. Is adding to the send queue based on the WFMails table, or is there another, dedicated Database table for this purpose? UPDATE I have already found some important information: This queue is stored in the Database in the WFMails table. Are messages with status 0 then retried?

(...) w with all (planned) attendances and (planned) absences must be created. For better visual differentiation, an extension of the standard colors "ColorID" is desirable. Is this easily possible via the Database ? The types that _we_ need to distinguish, but it should be possible to create as many color definitions as you like. Types of attendance: * Office * Home office * Business trip * Further ed (...)

(...) ch a problem in version 2023? I don't know whether to look for the cause in the environment configuration or if it's a general problem. The problem occurs on different processes and different content Database s. Thanks for any information.

(...) Is it for FREE? :) Yes, it is if you like SQLing :) Like we said WebCon BPS platform has got full history in the SQL and in history view (detailed one). Custom SQL taking data from WebCon BPS SQL Database s can give you such SIMPLE overview on the form. It is also configurable - with subworkflows or not, which columns, etc. BUT basic version is about WHO clicked WHAT (and WHEN) in the process. What (...)

(...) view how it is done :) BPS 2023+ It would be perfect if such an overview could be added out-of-the-box (e.g. such dashboard) of the groups (at least the ones directly used which can be SQLed from Database ) - alike in the kb article by Mr. Baszak :) https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3

(...) Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a Database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Klaus

(...) rt a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – Query returning data) works as follows: SELECT ‘value’ AS object of subworkflow (Database field Name) etc. • How to write SQL query / where to get ‘value’ from Dictionary process? • How to set up Step edit/Task creation/Tasks assignment to use this ‘value’ to assignment subworkflows ( (...)

(...) Hello, I' m new in webcon and i try to fix issue connected with attachments. I don't know much about attachments Database but as i saw there are two places where i can find data : [BPS_Content].dbo.WFDataAttachmets and [BPS_Content_Att].dbo.WFAttachmentFiles When im trying to add attachment like always going step by step in my workflow everything is ok - attachment is being added in both tables (...)

(...) After installing a new development environment, I have a problem with performing an SQL query to the BPS_Config Database . The environment was installed with my administrative account. From the Database level, I can also see that the users of the service and the application pool (db owner) have permissions to the Database . The application pool is the account indicated in the installer as the user to connec (...)

(...) if condition in the item list to execute only a part of the item list. This would work technically but I would still get a log entry in the history for each item in the item list. This will bloat the Database as I would have to repeat this path until instance was handled. 2. Update workflow with item list and sub workflows Instead of updating the data in the item list, I will use the item list to spa (...)

(...) Hi, Sorry for my lack of knowledge but I've just installed WEBCON 2 days ago. Please help! I want to add in a item list rows from a SQL Database but: Querying data is ok. I want to select a product name based on that query (from a Choice field) and get the correspondent price from the query... Also my query is based on another field as a filter When I change the value of that filter, the list of pr (...)

(...) I try to render values from a rich text editor (multiple lines of text; Mode: Rich) as a column of a table on a Word-Document. But after the Wordfile generation the formatting is lost. In the Database the value is stored as: X2OTestBla  Is it possible to generate the Wordfile with the given formatting? Thanks in advance. 1st Image: Value in the Rich-Text-Editor 2nd Image: Result in t (...)

(...) There are no such problems for the previous case of 20,000 loaded objects. What could be the reason? Is there any optimization of the WEBCON platform after such a large import? Or maybe you need Database optimization? Repair (reorganization) of indexes or Database file operations? What do you recommend?

(...) Hi, I need extract the name of form type from Database s. Does anyone know where the name of the form type is saved? Thanks, Raluca

(...) I am trying to write a SQL statement to start a workflow but the data source needs to be a SQL data source rather than the Webcon Database . I have defined the SQL data source (ConnectWise Companies) and it is working OK. I think the problem is what do I use in the "From" part of my SQL statement. If I omit the From part, when I test my query it does not recognise the column names and says "Invalid col (...)

(...) via Excel, make sure to save all reports again. The following numbers are referring to the second attachment. After importing the translation the report configuration will look like (1) in the Database . There's nothing wrong with it and it works just fine in the current environment. When you export the application and import it to another environment, you may be in for a surprise (2). Comparing t (...)

(...) Hi, We installed a fresh Webcon server and attached the backup of the config Database to a new SQL Server and connected it to the new Webcon server. The config Database now has references to the old host and the new host. Is it possible to remove the old host from the config db? Thanks

(...) s exactly executed when i'm using raports in WEBCON. What SQL SELECT is inside, I knew that i can find it some where in the console(debug mode) F12, but I can't find it right now. Or there is some Database table with this ?

(...) Hi all, do you have any information where are kept the covers in the Database on the 2023 version?

(...) Hi, We recently migrated Webcon to new servers on SharePoint 2019. Apparently, the configuration under Webcon BPS Configuration on each SharePoint site got lost (the Database name etc.). 1. Is this behavior expected during migration? 2. Is it possible to set it globally or is it necessary to set it manually on each SharePoint site/subsite? 3. Are there any other such settings that might have gotten (...)