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

(...) able in the template. The good option is to create the dictionary processes – for more information, see Dictionary processes.   Fig. 10. Attachement section   The SQL query returns the attachment ID because the attachment versions are stored in the database. You must select the current one –for this, add TOP 1 and ORDER BY ATT_TSUUpdate DESC. ATT_WFDID is th (...)

(...) eld is set by the “Set Nett Amount in PLN” form rule which uses the “Nett amount in PLN” business rule. The business rule returns a floating-point number calculated with an SQL query. The SQL query returns the result of multiplying the value from the “Nett amount” field and the average rate of the selected currency, where the invoice date is the effective date o (...)

(...) sitive value for each type of transaction.   Fig. 10. The configuration of the "Change value of a single field" action   The last action is “Move a workflow (SQL )” that moves the “Account” workflow to update the amount in the “Balance” field. In the configuration window in the “Parameters” tab enter the “_Update (...)

(...) : Franciszek Sakławski   Introduction When creating the configurable e-mail templates there is the option to add fields from the form. This article describes how to add an item list and SQL data table fields.   Fig. 1. A list of fields available in the system   To enter these types of fields in the template is needed: Basic knowledge of HTML language (spe (...)

(...) dquo; field to whom the task is assigned in the next step. Below there is a query used to select a person:   Fig. 10. The "Responsible" field is the person or group type. The SQL query returns an employee's login to whom the task is delegated and sets them as a field value   The query returns the user’s login (PersonLogin) – the ID of employee (...)