search results

(...) 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 data base (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a data source for a Choice field, where I could query for names in both tables. It is purely for reading data . Kind regards Kla (...)

(...) ers groups (one per subworkflow) selected from Dictionary process. I am trying to use action “start 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 (data base field Name) etc. • How to write SQL query / where to get ‘value’ from Dictionary process? • Ho (...)

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

(...) Hi, I think it would be helpful if the data row field, when set to the percentage type, also displayed negative percentages when selected. This would be highly beneficial for various processes, especially when we want to track project progress or profitability. Currently, if we have negative percentages, it shows as 0. I believe negative percentages could be highlighted with a different color. (...)

(...) Hi, We have an issue related to the usage of columns from a data source (dictionary, BPS internal view) within a choicefield-type field. The user 'windows user' has created a new application, a new process, and a new dictionary. After configuring these, the user created the corresponding data sources for them. They created a new process where they associated the dictionary/process with choicefield (...)

(...) nges. What are your ideas for solving this? My ideas up to this point: 1. Update workflow with item list I wanted to: - Create an item list with all active workflow instance - Fetch the data from the ERP system for each row - Compare the old against the new data - Trigger an update if something changed Problem: Executing xxxx REST Requests in a "for each" loop in an item list will pr (...)

(...) hello, I need to migrate local groups from production to dev environment, do you know data base table or do you have sql that will show me all local grups, even empty one ? thanks in advance.

(...) Hello Is there a way to export data to specific csv file? I want to create one either as attachment, or saved directly on comuter/server. This should be button on form.

Hello all, We have implemented a new ticket system called Jitbit and I would like to connect it to WEBCON via REST web service. Unfortunately, I don't understand how to configure a "Basic authentication" or "Token authentication" in WEBCON. Using Postman, the authentication including the queries already worked. Enclosed you can find the documentation from Jitbit: https://www.jitbit.com/helpd

(...) 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 data base optimization? Repair (reorganization) of indexes or data base file operations? What do you recommend?

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

(...) How to display data from another data base (added as an MSSQL data source) in a report? How to do this in a new report? Or maybe it could be added to another process report

(...) Hi, We have a project in Webcon that has many processes and dictionaries (more than 150). The application has been in production for, let's say, two years. In the first year, the data base size was manageable, but now it's getting out of hand. Does anyone have any tips, tricks, or suggestions for dealing with large amounts of data ? Are there optimization techniques we can employ? Any opinions (...)

(...) Hi, I have a problem with adding new data in item list. When I'm try to add second row everything are deleting from row first. What can be the reason? In the item list are some columns with autofilling. Problem does not occur, when I type INDEKS (first column which is the main column through which the others are filled in. ) manualy (not using pop-up suggestions)

(...) Hi, In DEV-TEST-PROD Architecture environment also containing multiple BPS Content data base it would be helpful to runas BPS Studio to the exact environment and exact content data base. Then it would be possible to create .bat script to run exact environment, e.g. TEST to the specific data base e.g. BPS_Content_1 The script "BPS Studio PROD data base 1.bat" could then alike below runas /user:Domain (...)

What I have is working, but just for one item: 1. dictionary with shipping company: a) DHL, GLS ect. b) parcel tracking link with marking place: [tracking_no] 2. business rule is changing [tracking_no] and set to text field as hyperlink and "grab" the tracking individual string (see all screenshots) What I would like to have: the same functionality but add multiple lines (divided shippi

(...) Hi all! I am currently struggling with 'Add privileges' action. I want to use a predefined data source (SQL query based on WFElements), this is shown under (1) in attached picture. The data source I am using selects all elements from a specific formtype and needs additional filtering in SQL query window (2). But I am unable to do that, every attempt so far resulted in syntax error. I am s (...)

(...) Hi, if a data row/ data table is based on a BPS internal view to configure, whether the names/translations of the columns should be used. The default value should be true. It's just a waste of time to not only provide the translations the first time but also to update these when the name/translation of the referenced column changes. Most of the time it's forgotten anyway. Best regards, D (...)

(...) We have two attachment data bases, one for testing and one for production: BPS_Content_Att_test BPS_Content_Att_test2 BPS_Content_Att BPS_Content_Att2 In this application we use BPS_Content_Att_test2 for testing and BPS_Content_Att2 for production. Unfortunately we don’t have a data base with identical name, so when we import from test to production, the default attachment data base specified (...)

(...) Hello Community, We have problems with the different runtime environments of the WBCON Workflow Service (under .NET Framework) and the WEBCON BPS Portal (under .NET Core) and System.data .ODBC. I have developed an SDK plugin that integrates the NuGet package System.data .ODBC to access ODBC data sources. The target runtime environment of the plugin package is .NET Standard 2.0, so that the plug (...)