search results

Is there a option to insert values do database (my own table) by the button added in html form? My idea is like a picture I addend, but when I click on the button I get error Message=Error occured during rule SQL Dodaj powiązanie (Id: 136) evaluation. Source=WebCon.WorkFlow.Base StackTrace= at: Evaluation requested at: Evaluation node: Rule at: Evaluation node: SQL InnerException: M

Hi! Unable to retrieve data while processing SQL Command, the error is: Error occured during business rule evaluation. The given key (-25) was not found in WFBusinessRuleDefinitions cache for current content database. at: Evaluation requested at: Evaluation node: SQL The same error is while configurating action or creating a business rule

Hi community! We are getting some data from external system via REST API. Specifically workflow elements are created and there is a default path for saving workflow element. This can be easily done with the well known POST endpoint: /api/data/v4.0/db/{dbId}/elements Now we are facing the challenge to check if there are already elements in our system, to avoid duplicates. This can also

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.

(...) Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSsql database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSsql database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission was denied o (...)

Hello, is there a possibility to use existing SOLR as Data Source? I had an idea to show users SQL grid, which would show similar items found in database, based on text typed in regular TextInput field. That lead me to Levenshtein Distance algorithm, which might be slow in SQL, but i've found that such a thing is already implemented in SOLR (https://stackoverflow.com/questions/1752301/how-to-c

Hi all! We want to execute a JSON query on a path (actually it is some business rule containing SQL query) and send these results to an external endpoint (REST service). The problem is that the query does not reflect current changes in form, since this happens on save. This should be related to database transaction and current values which are not persisted at this moment. Is there eve

After upgrade to version 2022.1.4.174 I get errors on some querries that use . Error occurs when querying another database directly or using join, etc from SQL COMMAND or choose field querry. I found that this is related to change described in https://community.webcon.com/download/changelog/117?q=cf05b90, associated with using bps_user on SQL COMMANDS. Is there any way to deal with it at SQL s

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

Every WebCon BPS Applications needs permissions to work properly. Of course best practices is to use groups: WebCon BPS, Active Directory, SharePoint ones. It is worth to some have naming convention for them. It is also crucial to know which are used within the specific Application. We can dig into the BPS Studio and check Application, Process, Worfklow, Document Types permissions. We can chec

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 t

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 "Inv

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

Hello, Do you know how can i find what query is 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, I am currently exploring options for viewing documents within Webcon. Specifically, I am interested in understanding whether there is a possibility to visualize a document by providing a link that points to a document stored either on SharePoint or within a SQL Server database. My goal is to enable the automatic display of the associated document in preview mode when a user selects a reco

Hi, In my opinion, the biggest advantage of BPS data sources is the ability to link to a selected element. However, the disadvantage is much lower performance in advanced conditions, inability to join data, use union, and combine data from different content databases. By changing the source from BPS to SQL, users lose the functionality of the link. Of course, we can achieve this in a diff

Hello all, I have a data table field where I'm selecting the fields using a SQL query. One of the field is a picker and I want to show just the Text and not the ID. I've tried many options but as soon as I try using the Database-Name, it's giving errors. I believe it's because the option has space on it : 'Non Ok'. But the system should overcome this right? Even using the DBO function, it doe

Hi, this may sound strange, but so was the reason, why I'm proposing this. My suggestion is that the expression editor for a SQL command inserts the instance id variable in a way: Currently it is inserted as: {WFD_ID} My suggestion is that it is inserted within single quotes: '{WFD_ID}' The reason for this is, that it would prevent errors which may only surface in production. This is

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

Hi, I'd like to build SQL query that uses 'current BPS database' and at the same time uses linked server that exists on that server. So I want to do sth like that: Select * from BPS_Content.dbo.WFElements t1 left join [my_linked_server].[database].[schema].[my_table] t2 on t1.id = t2.id Unfortunately it doesnt work. I got an error in Webcon Studio "Access to the remote server is denied b