(...) rformance, this is not an optimal solution, because when loading the form, all records from the EMSI_JobChange_UK table will be downloaded first, which will be filtered only in the next step, and the filtering result will be displayed on the form. However, from a business point of view, it is not necessary to know the SQL syntax when using filters. Fig. 9. The configuration of the data tab (...)
(...) ents included in the documentation of the selected API (in this case – host and API key). In the “Filter mode” tab, you have two options – Using BPS and Using Web Service. filtering on the BPS side will cause that the entire data collection will be downloaded first, and then the searched value will be found (e.g. contractor with a given NIP). filtering can also be performed on t (...)
(...) drag all of the group content to other panels simultaneously. Fig. 3. The Global form template In the “Form type filter” section, it is possible to set the filtering of fields displayed on the panel to those belonging only to the selected form types. In the “System areas” section, you can add the fields such as Instance ID and Business entity. (...)
(...) olumns let you add new columns to reports wherever they are necessary without changing anything in Designer Studio. You can also sort and filter reports with them. Fig.14 Sorting and filtering reports with calculated columns
(...) selected tag to the technical form field “_tag id to deactivate.” Fig. 20 - Move Workflow (SQL) action configuration, Parameters tab Fig. 21 - Query filtering data On the “_deactivate” path, set the action to change the item list's value (figure 22 below). Fig. 22 - Action setting a given tag as inactive &nbs (...)
(...) perly 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 does not support grouping and breaking the results into pages. Summary The analysis of statistical data at individual steps allows drawing conclusions that can imp (...)
(...) reports for system tasks; it can be done on Portal or in Designer Studio. For the user’s convenience, both configurations look alike. There are numerous options for configuring reports and filtering their data. Also, every user can filter the reports to suit their needs and save their private view for later use. Thanks to this, you can provide your users with a default view containing the essent (...)
(...) hen specifying the attachment size – remember that the IIS server setting is the overriding limitation on the size of the added file. To do this, open the IIS manager and go to the Request filtering . Fig. 7. Internet Information (IIS) Manager - request filtering Select the Edit feature settings option. Fig. 8. request filtering option - Edit Featur (...)
(...) ith token-based authentication, we are able to use one of two custom connectors to easily load data from WEBCON BPS into Power BI. Handling this data is also less cumbersome, we are able to apply filtering to the data and select what we need at Power BI level. Since this is a new feature, there are certain limitations. The OData format that we use has been tailored specifically to work wit (...)
(...) dow opens in the program: Source configuration requires entering basic properties, such as Name or Connection properties. If a custom query kind is selected, it is crucial to enter a filtering Active Directory query that will return specific data source items. The source configuration also allows you to specify the primary Organizational Unit (OU) under which users will be searched, and (...)
(...) of a selected application, process, workflow, or even a step. Choosing the level of data presentation The above indicators can also be accessed from the selected application. The filtering is then automatically limited to that specific application, and the indicators prepared only on the basis of related statistical data. Statistics of the "Cost Invoices" application a (...)
(...) tion available in the admin panel. It is a view that enables users to display and modify (edit and delete) all active sharings regardless of their type (instance or task sharing). The view provides a filtering function for sharings, which is particularly useful when there is a large number of sharings to manage. Identity verification with security codes Starting from the 2023 R2 (...)
(...) ”, represents a unique value. It is the element most frequently used in SQL queries designed to filter results displayed in picker fields populated with values from a specific data source. Such filtering is often employed to exclude irrelevant information, presenting only what is of interest to the user in forms, reports, picker fields, and so forth. The previous approach – the (...)
(...) e CONCAT function within the LIKE function allows users to create precise queries containing text values, operators, and values of different form field types. This solution streamlines the process of filtering data sources and creating rules to automate work with large, complex and dynamically changing values and to manage multi-record databases more efficiently.
(...) ources for all existing form fields, the new system data source will be used by default instead. It contains all (active) elements from the CacheOrganizationStructure table. filtering this data source will filter the list of users available all across the system. The goal of creating this new data source and changing the Person or group field is to make it possible to create compl (...)
(...) the form using the keyboard Reports and their views In the case of table reports, users will find it simple to select Menu buttons, icons directly related to report configuration and filtering , report column headers, rows, Instance numbers leading to workflow instances, action menus, as well as elements of all related context menus. Similarly, users will be able to freely navigate through (...)
(...) n, all columns requiring authorization will become visible. Although columns requiring authorization cannot be used to configure grouping or additional filters in the report setup itself, grouping/filtering by such a column is possible from the view level after successful authorization. Limitations on Dashboards, Reports, and in Process Configuration In version 2025 R1, acc (...)
(...) hich the instance is located. The column is available for reports with both SearchIndex and SQL sources and can be used to configure Calculated columns, default filters, row coloring, dashboard value filtering , etc. Business rules and Form rules Workflow phase and Workflow actor variables are now also available in the dictionary of the Expression editor displayed when (...)
(...) WEBCON BPS reporting offers great functionality for sorting, filtering . It would great having the option to implement and configure a SDK extension for reports, which would allow to execute an action based on the current selection. In my case the SDK extension would receive the selected rows with all fields and generate an advanced Pdf report. Like configuring the mass action, there should be an option t (...)
(...) uery with an exact match (=) is 2% of the query cost. Due to the very high yield for the environment (large BPS instances), I propose to create a new type of selection attributes, where we give up filtering , and for columns intended for searching, we will add an additional search method parameter to the database: LIKE%, %LIKE%, exact match (=).