WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for sql

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

(...) used to send documents to the Skribble platform for signing.   b) Attachment selection SelectionMode – attachments can be selected based on the category (the Category value) or sql query (the sql value) CategoryMode – attachments can be selected from a specific category (the ID value), not related to any category (the None value) or all (the All value) Category ID &nd (...)

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

(...) is data is necessary for all SDK actions so you can enter them as constants in the process. In the “Attachment section”, define  the method of attachment selection (by Category or sql query) and technical form fields to which the ID of the signed document and envelope created in DocuSign will be saved.   Fig. 6. The configuration of the action   In the ne (...)

(...) dash; zooming/reducing. In some parts of the system you can use with the ability of zooming and reducing the entered text/rules to improve their readability. These places are e.g. a window to enter a sql query, window to enter rules/formulas, window of workflow graphic schema.   Fig. 10. The diagram before rescaling   Fig. 11. The diagram after changing the scale  (...)

(...) are represented in the content database – which is the main place of the system’s operation. There are also “virtual tables” automatically created by the system – called sql views – that contain data from the linked tables. This article describes some of the most important views that users can refer directly to the WEBCON BPS Designer Studio level or from the da (...)

(...) istered” step. In order to configurate it, we need to double click it, then go to the “Actions” tab. As it is presented on Figure 5 type of the action is “Start a subworkflow (sql )”.   Fig. 5 Action configuration window   On the „Execution condition” field you can see a nested sql Command. You can configurate them by clicking the ico (...)

(...) /t.green@webcon.pl”   To create such a list, we will first pass our data through a technical form field – multiple lines of text.     The action uses the sql query to merge all records into a list, with entries separated by commas. The final result is in a format that can be used for calling the Microsoft Graph method. Our technical form field prepared in (...)

(...)   Fig. 2. The history of the instance   The workflow was changed only once. In the WFHistoryElements table two entries were made – to check this go to the SSMS (“sql Server Managements Studio”) and create a query about this particular table. Check also the WFElements table – they should be one entry with the current data.   Fig. 3. The (...)

(...) te presenting the names of the selected columns along with one, empty row. Now, you can set the table style by using built-in Word options.   Downloading data from other systems by using a sql query. In the same way as the item lists, you can add the data tables based on the sql query which refers to the WEBCON BPS database or an external system. In the Word file you can put not only th (...)

(...) displays this information on the form. After approving the request, the number of days is subtracted from the employee pool.   Fig. 4. The configuration of the action   The sql query used in this action:   Fig. 5. The sql query uses to calculate the working days   This query uses the Calendar table. From this table in the third row, you can limit t (...)

(...) . WEBCON BPS allows you to map these conditions by using the privileges mechanism. For more information about privileges, see Tasks vs privileges. The WEBCON BPS system operates based on a sql database, one of the places where the information the privileges is stored is the WFSecurities table.   Description The WFSecurities table contains information about current privileges (...)

(...) d configuring process – so that these limits are not reached. All of the following limitations result directly from the WFElements (for form fields) and WFElementsDetails (for the item list) sql table structures.   Limit tables   Global form fields The limit of global form fields applies to the entire system configuration. Regardless of the number of processes, workf (...)

(...) p; Fig.5. The configuration of the Teach OCR AI action   Attachments selection criteria – you can select the attachments which will be included during teaching by using the sql query By using the “OCR AI Learn” path you can teach the program. In this way the system learns how to analyze vendor invoices based on the NIP distinguisher.   Summary (...)

(...) s” option   In the window which appears on the screen, select the “View logs” tab.   Fig. 2. The “Administration tools” window   The sql query template is automatically substituted in the “Query” section. Such a query should be implemented with an action ID. You can also add the additional filter in the “Additional f (...)

(...) r the start and end date of the substitution. The date can be selected from the calendar or can be entered manually. Advanced options – the configuration of the action can be written via sql query. The query should return the following information: Substituted person Substitute person Start and end date of the substitution Process ID (optionally) Business entity (opt (...)