search results

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

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

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

(...) Hello community. I wrote SQL query for On timeout – Insert condition (SQL ). My query is returning true value, but action is not working. See figure for details. Any idea what could be the problem? Thank you.

Hello. Is it generally impossible to use the above action type to create a new workflow item with a "filled" item list or do I have a mistake in my doing? I have a table (item list) where I want to start subworkflows from (depending on field value) where this line of the item list is "copied" to the new workflow. Creating the WF item is easy, but the table stays empty. Is this a bug in

(...) Hello, is there any way to connect other data sources (MySQL or Generic-ODBC)? If not, is there a plan to implement this in the future? Thanks in advance Markus

(...) I have a question: How to create an SQL filter in the "source" section of the report that will show only the column/attribute items indicated in this SQL . The attribute column consists of the dictionary entry ?

(...) IS there a way to extract the information with SQL about the bps groups via SQL command?

(...) have got 3 different flows but on each flow I have got the same data in one variable (key). in flow 1 is Signature in flow 2 is WFD_AttChoose5 {72} in flow 3 is WFD_AttChoose6 {692} how to do SQL request or more interesting is how to do report where I can: filter Signature = WFD_AttChoose5 {72} = WFD_AttChoose6 {692} In Webcon reports I don't see process fields if I add 2 or more proce (...)

(...) In Designer Studio it is possible to check the use of a single connection or data source in the context of all processes. Is it possible to get such a list for all connections and sources using an SQL query?

(...) HI I need by SQL query to outline the list of the appliacation that we have and a workflows to a choice field. How can I do if the app is on Main_Db and we have apps on Main_db and main_db2?

(...) 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 different way, but it is not consistent, for example, with other pickers using a BPS source. Would it be possible to (...)

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

(...) Dear Webcon, are you planning to give us a new Report model (in the data presentation) that allows us to use our own/independent SQL ?

(...) Index (zero based) must be greater than or equal to zero and less than the size of the argument list. SQL query: SELECT 111 as WFD_ID , 222 as PATH_ID

(...) Hi, I would have two ideas/requests (probably simple) regarding the SQL editor 1. The SQL query editor should have a monospace font 2. The SQL query after copying to SMSS/notepad has unnecessary newlines. Is it possible not to add newlines? regards

(...) Hi, I have a choice field with SQL data source connected to it. Is it possible to create a link (into the choice field) to a selected element like as in the case of BPS Internal view? Simplify, I need the same option as in the selected screenshot but for the SQL data source.

(...) Hi I have a question. I want to return all weekend days in SQL for my form validation. This is my SQL Code that returns these days, but only for the current month: WITH Dates AS ( SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS DATE) AS DateValue UNION ALL SELECT DATEADD(DAY, 1, DateValue) FROM Dates WHERE DATEADD(DAY, 1, DateValue) < DATEADD(MONTH, DAT (...)

(...) test webinars I've heard that there is open 'Designer Studio' project at Webcon, so I'll give it a shot - if not now, then I'm not sure if there will be a better time ;) I think most of us have used SQL Server Management Studio or Azure Data Studio to test some queries, and maybe a VSCode / Notepad++ for some powershell - all of those support autocompletion (which in most cases of recent software 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 rem (...)