search results

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

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

(...) Hello, Does anyone can help me, why in WEBCON SQL query apostrophe is replace with quotation mark? On the form, I have an attribute with value: '2339226', '2504286'. In action "Change items lists value", I used an SQL query whith this attribute, but query preview returned "2339226", "2504286". Regards

(...) er a certain amount of databases, which we then have access to. The question is, is it even possible to install Webcon into existing databases (e.g. Config, Content, Att,...) or do we need a fresh SQL instance from the customer and an admin account with db_creator or sysadmin rights (as described in the installation manual)? Sorry for the somehow unclear question... Thanks in advance & best (...)

(...) I would like to run an SQL procedure (something like the article Run an SQL procedure https://community.webcon.com/posts/post/the-run-an-SQL -procedure-action/230). But, I would like the procedure to generate a .txt file with the results (e.g. JSON), and the file to be downloaded using the WEBCON platform (maybe a new process with starting the procedure and preparing a .txt file for download, such a (...)

(...) Webcon ver 2021.1.5.315 I found a bug in business rules with parameter and SQL query. When type is text and value start by '0' then rule cut first char.

(...) Hi, Due to requirements of another system: 1. I need to change the authentication method of MS SQL Server from Windows to mixed. Any risks connected with such operation? Or Webcon should be working just fine? 2. A need to change the collation of the SQL Server. Are there any risks connected for running Webcon service here?

(...) Hi, Is it ok to create a custom SQL views on BPS_Content DB? Does webcon allow it? Best Regards, Bartek

How can I in here write dinamic company from my item list (My company is in DET_att5) ? Or I have to do another way ?

Hello all, I have an item list where I want to display some column color based on the value that will be the outcome of 2 dates. I would like something like if it's zero, the column should be green, if it's between 0 and 30 days, it should be yellow and if more than 31 days, it should be red. I'm trying to use this, but it's not working: if ('{SFD:-4}' = 0) select '#90EE90' if ('{SFD:-

(...) Hi, I want to use the action - Send a custom email and get email addresses from a Dictionary. I checked "Selecting addresses by SQL /CAML query" and as Data source: i chose my Dictionary When i write a SQL query it doesn't filter. It shows all columns and rows. In my workflow i have a choice field Vendor name (from a Dictionary - it contains Vendor Name, Vendor Email). When i pick that vendor (...)

(...) I'm having trouble running the SQL subworkflow. The query entered during the configuration works fine in testing. However, when I try to run the subworkflow in the application, I receive an error message that says, "An error occurred while executing the start subworkflow (SQL ) action at the path. (Step: Verify application, Path: Submit for review) Incorrect syntax near the keyword 'from'." What could (...)

(...) ng the solution posted at https://alterpaths.com/json-nested-collection-handling-in-webcon-bps/ but I cannot get the query to work in Webcon. When copying the whole query from the Show window into SQL Studio it works just as expected, but in WebCon Designer studio the following error occurs (see screenshot). Any ideas how to proceeed here?

(...) Hi all, I was wondering what the best practice is when using SQL queries in Webcon with attributes, tables or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This me (...)

(...) mple history on the form - WHO clicked WHAT and WHEN is part of our Internal Company WebCon BPS Guidelines. We put in on the every form in the processes. Is it for FREE? :) Yes, it is if you like SQL ing :) 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 databases can give you such SIMPLE overview on (...)

(...) kflow but attachments do not transfer. If I do it manually as a action on path then the attachments move to subworkflow and its ok. But if I use a cyclical action to call the same action -> "create SQL subworkflow", tasks are created but without attachments :/ Example in the attachment, I trigger the same action: Uruchom zadanie TEST (en: Run the TEST task) I use version 2022.1.4.223

(...) flow many times as subworkflow of fist workflow and assign it to the several users/users 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 (Database field Name) (...)

(...) HI, When installing Webcon, the SQL Server compatibility level is set to 120 (default). To use advanced functions like `string_split` and data processing functions from JSON, it is necessary to manually change the compatibility level to 150. These functions are essential in developing more complex processes. If we manually upgrade the compatibility level from 120 to 150, Webcon will no longer p (...)

(...) Hello Does Webcon 2023 work with SQL 2022? Native or with compatibility db level 2019?

(...) Hi, Following a security audit, we are compelled to set the CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER. I'm not an expert in SQL . What impact does this setting have on Webcon? Thanks, Raluca