search results

(...) I'm trying to reach some value in SQL Filter in Source Tab when creating report, using HTML template i got what is shown on a picture -when im using DET_Att3 it references yellow field -when im using DET_Att4 it references red field is there a way to get one from green field?

(...) I wanted to make New SQL Data Source with data type: Organization Structure to use it to my holiday process. When I use original source from AD -> CEO and Managers can see all of their employess. But people in each team don't see their coworkers from another teams. So I wanted to make a new SQL Source to improve Gant Chart in Holiday Process. I used data from Workers Profile in BPS. Everythin (...)

(...) Hi. Since we switched from V2021 to V2025 I noticed that it seems to be no longer possible to use the content of a form field (unsaved data) in a SQL query (see pic). It just delivers "empty". Is there a workaround? I frequently used the data of form fields to control actions and so on. This is a major degradation ! Kind regards Klaus

(...) Can I query SQL (WFDElements) to get a value for calculated column in the report from another workflow? Alternatively is there any way to present an SQL query as a report? Or on dashboard? I have a few cases where I need to pivot certain information. The only way until now that I found is to create a data source and a technical workflow that will load it into a table but it's far from perfect

(...) Hello, Can anyone help me with this SQL filter. The problem is that the SQL filter returns all rows, instead of filtering only those that meet the warehouse condition. No matter how I change it, it returns all records from the data source I am attaching a screenshot of the configuration: - WFD_AttChoose2 is a field of type Person in the "warehouse" dictionary In the advance configuration (...)

(...) In a step, I configured an On timeout action that runs a SQL procedure (a very simple query that updates a field in another database) after 1 minute. However, occasionally—about 1–2 times out of 100—the field is not updated, even though in history shows that the action was executed successfully. An external process calls the WEBCON API using a specific path. On that path, a SQL procedure action i (...)

(...) Hi everyone, maybe this question asked before. I am currently working with a WEBCON BPS SaaS instance and I need to connect it to a local (on-premises) SQL Server to access internal data sources. I understand that the WEBCON BPS Bridge is the recommended solution for this hybrid setup to avoid opening inbound firewall ports. However, I am having trouble locating the actual download link for th (...)

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

(...) n of the form rule with using the business rule   Execution of a form rule depending on data in other instances/workflows In the business rules, there is the ability of referring to the SQL database and returning the specified data based on the process configuration or documents registered in the system. In the example, the SQL COMMAND function was used and it was checked whether contra (...)

(...) author: Dawid Golonka   Introduction Some processes in WEBCON BPS require data from some other source to operate correctly. This data can be provided from external data sources such as SQL databases or SharePoint lists. Internal sources can also be created in the system such as Fixed value lists or references to data contained in WEBCON BPS workflows. Any WEBCON BPS process can be used (...)

(...) tion of the action for sending documents   In the first field define how to select the attachment to sign – there are two options: Based on the document category Based on the SQL query If you select the first option, you can define which category is to be selected. Additionally, a RegEx expression can be used – to limit the search by attachment name. If you select (...)

(...) e via up/down arrow keys, and then entering them – either by pressing the Enter key or using the mouse. By clicking the “Show more result” option, the user will be redirected to the SQL R search engine. There is also the option to enter search content in the search field. The entered phrase is also searched in the form fields. The search is carried out in real time and with an wit (...)

(...) in, so it is a good idea to define it as a constant in the process. Attachment selection – indicate: The method of attachment selection -> based on the attachment’s category or SQL query The technical form fields to which the attachments’ identifiers will be saved Message content – enter the title and content of the message sent with the attachment Recipien (...)

(...) n of the “Picture” field   Using the icon of three dots, you open the editor. In the editor go to the function tab and from the “Integration” list select the “SQL COMMAND” option. Then place the following query in it:   Fig. 13. The SQL query editor   In the SELECT clause select the field that stores the picture code, while in t (...)

(...) D column” option in the item list form field configuration. The above query returns all completed data from the “report of service events” item list.   Fig. 6. The SQL query   An example query that returns information about service visits along with information about given car – in the last 30 days.   Fig. 7. The SQL query – di (...)

(...) lds (dates, numerical fields, choice fields…) are stored in the WFElements table in a different format from the one in which they are displayed on the form of the given instance. The following SQL query returns all the completed fields on the form for the above instance (Fig. 4) – Infiniti registered car.   Fig. 6. The SQL query – storing data about the instance & (...)