search results

(...) author: Michał Kastelik   Calculated columns enable you to display additional information in WEBCON BPS reports. They are created by adding a new column in the report and then inserting a sql   formula. They allow the report to be supplemented with additional fields that are not present in an application. A calculated column only works within a given report.   Creating calc (...)

(...) and choose how to add elements: Static - in this mode, fields from the workflow form should be assigned to the columns in the SharePoint list, Dynamically - in this mode, you should define a sql query. It will return columns with the same name as the SharePoint list column.   Fig.6 Configuration for the action “Add a new list element” The "Save ID in: (...)

(...) iagnostic mode is running, all form, report, and other WEBCON BPS Portal elements' invocations are registered. The following are recorded:  business rule invocations (with sql content, if the rule contains this type of invocation),  form's rules invocations (including all invocations of functions that modify the form),   invocations (...)

(...) e attachment from the form. In our example, we have configured the action to place the user picture in a category named "User photo."  However, you can also use a regular expression or sql query to indicate where it should be placed. The photos created must be saved in an appropriate format (JPG, BMP, PNG, GIF), have a size not larger than 10 KB, and their resolution cannot exceed 96x9 (...)

(...) Fig. 20 Setting to whom the task should be assigned if there is an error   As you can see in figure 20, you can select a user manually or from a form field; another option is using a sql /CAML query to return them. Now, we will again submit a requisition for buying a laptop. Its value will exceed our defined superiors’ approval limits, causing an error; thus, the task should (...)

(...) the link will not be visible. If you need a hyperlink creating a new instance instead, add a new data row “Create tags.” As the data source, indicate the current database and fill in the sql query as shown in figure 14: Fig.14 - Create tags field’s configuration   In the advanced configuration, select Show column and Instance hyperlink and click on the 3 dots. (...)

(...) olumns “STP_ExpectedAvgStepDurationByHours” and “STP_ExpectedAvgEditDurationBySec”). The report, which is the subject of this article, is created through a properly prepared sql query, operating mainly on the tables mentioned above. The report supports translations; the names of processes, workflows, and steps can be translated. The KPI report supports filtering, but it (...)

(...) of competencies” item list, go to the “Layout” tab and check the “Use advanced appearance settings” option. Select the “For whole row” color mode and add the sql query. Fig. 17 – The row coloring setting On the form, it will look like in Fig 18.   Fig. 18 - Coloring rows with incompatible answers b) Finally, the superior giv (...)

(...) e, and the processes for which the substitutions will be active can be defined based on the application/process ID or the rule. The entire action can also be configured on the basis of an appropriate sql query. Fig. 8. Configuration window of the Add a substitution action   If necessary, the substitution added in the above way can be removed using another action – Remove a sub (...)

(...) t contain software acquisition by entering the URL with the right parameter into the address bar. It could look like this: https://www.webcon.com/WEBCONBPS/db/1/app/report/2?VALUE1=Software 4) use sql filters to filter how many workflow instances should be shown on the report. The condition should be entered after the keyword AND; for example, AND YEAR(GETDATE())=2021 Fig. 6 Mandatory filte (...)

(...)   As we develop WEBCON BPS, we strive to march in lockstep alongside other platform products, i.e. Windows Server, sql , SharePoint, etc. We do our best to maintain backward compatibility with older versions of these platforms to accommodate our diverse client base and their preferences. However, as the publishers end support for their aging products, so must we. It’s not all gloo (...)

(...) e. Index is created for values of all form fields and items list columns. All text document added as attachments to the forms are also indexed. Apart from text formats such as TXT, RTF, XML, HTML, sql indexation is also done to documents in following formats: Word (DOC, DOCX, DOCX, ODT), Excel (XLSX, XLSM, XLS), PDF with text layer and e-mail message files (EML, EMLX, MSG, OFT, MBOX, TNEF).

(...) m)   1.1.Software   Windows Server 2012 R2, Windows Server 2016, Windows Server 2019 Microsoft SharePoint Foundation 2013 or Microsoft SharePoint Server 2013/2016/2019 MS sql Server 2012 or higher (full text search mode required) Active Directory (or Azure Active Directory) environment   1.2.Hardware   1.2.1.Architecture There are 3 basic scen (...)

(...) 50 Choice field 90 in total Survey fields - Choice list Date and time 50 Yes/No choice 20 Person or Group 15 sql row No limit sql grid No limit Google map 3 Gant chart 2 Absence chart 1 Vacation summary 1 Custom cont (...)

(...) ield other than the “Person or group” type, you must designate a column that contains a user login or group ID).   Fig. 4. The "Dynamic" option   sql query – by entering the appropriate sql query that will return user logins or group IDs (the login or ID should be in the first column returned by a query). In the presented example, the (...)

(...) o the euro currency. The method of handling the return of currency exchange rates for weekend days was also presented. Using the tools built into the WEBCON BPS system, as well as the benefits of the sql language, we can freely configure the data sources used in workflows.

(...) The preview window can be closed with the cross in the upper right corner or by clicking outside the screen.     Other files such as .PDF, .WORD, .XLSX, .XLS, .ODS, .TXT, .sql , .MP4 video files, and e-mails - the attachment preview window is different from the previous one. Similarly, you can smoothly move between attachments using dedicated buttons.   &nb (...)

(...) thanks to which the created solutions will be more understandable, less sensitive to change and, consequently, more reliable.   Use of Tags Tags are elements used to create expressions (sql , CAML, JavaScript) as well as Business Rules and Form Rules. The tag represents a specific value of a specific object in the system, e.g. the value of an attribute. Tags in the case of sql and CAM (...)

(...) that point to a specific user or group.    Fig.1 Form for checking user's or group's privileges   For each example, we will show the user’s view and the sql query that returns the appropriate data.  Choosing a user or a group Before any data is displayed, the user must select a person or group. Basic information about the user will be displaye (...)

(...) ser ID PLN_From <Int32> - Date od (in YYYYMMDD format, e.g. 20200123) PLN_To <Int32> - Data do (in YYYYMMDD format, e.g. 20200125) PLN_WFDID <Int32> - Absence plan ID The sql query contains data from the WFElements table (such as employee's id) connected by JOIN with the WFElementDetails table with values from item lists. The DET_WFCONID constraint allows you to selec (...)