search results

Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date f

Hi all! I personally think the operator 'ForEach' is a great addition to version 2022.1.2.31, thanks to Webcon Team. Unfortunately I do not find any documentation on that, especially how to iterate over 'Any Collection' and access columns in custom action. If I select 'Any collection' and put some SQL statement in there, is there a way to access specific table columns from generated tabl

Hi all! We want to add some rows to an item list with 'Change item lists values' action. The SQL query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which

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

(...) I've got following fields: 1. Choice field with connection to MS sql table - name of the supplier. 2. Text fields like address, postal code filled based on the value chosen in choice field from point 1. 3. Another choice field with bank account numbers - another MS sql table filter by ID value from choice field in point 1. Two qestions: 1. By clicking 'x' in supplier name choice field I'd like to re (...)

Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not

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

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 ?

Hello, I have a question, a curiosity... In the WFDataAttachmets table, there is a column called ATT_IsDeleted. If I want to Run SQL procedure (webcon action) and update table and set the ATT_IsDeleted column with 1 or 0. Is it a good practice? Or is it not allowed? Thanks.

Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In the where clause, I refer to the value of another ‘Criterion’ field on the form. The data table should display the data depending on the selected criterion. Unfortunately as I change the criterion, the table sometimes fails to refresh and displays the data for the previous criterion. How

Hi everyone, Jarosław created a threat in which he points out that elements are no longer rendered if they are used in an item list data row column.: https://community.webcon.com/forum/thread/5247 I tested the most common/likely elements and to verify which are supported by using this SQL query: select 'a tag' + ''+ 'button tag' + ''+ 'div tag' + ''+ '' + ''+ 'img tag' + ''+ 'input

Hi there, Is it possible to use one datatable to show different tables from a sql server? Right its possible to filter the sql results based on a value in a certain column. I also want to make it possible to show the content of a different table, however account to the infobox to the right side of the textbox where i write the sql statment, its not possible. So i was wondering if there is an alte