(...) ount for Path ID This rule is slightly more complex than “Vote Count Total”. It requires creating one decimal parameter named “Path ID”, and using it in the WHERE clause to filter the results of the WFT_FinishPath column: The specific SQL text is: SELECT COUNT(*) AS [Vote Count] FROM WFElementTasks WHERE WFT_WFDID = {WFD_ID} AND WFT_Version = (SELE (...)
(...) s as an identifier and “Name” represents the displayed name. The first part, “ID”, 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 filter ing is often employed to exclude irrelevant information, presenting only what is of interest to the us (...)
(...) > and its effect on the Person or group form field from 2023 R3 onwards. The system data source <Users and Groups> (distinguished by the triangle brackets) is meant to act as a filter on top of the list of synchronized users - used to filter away unneeded accounts. In Person or group form fields, it is now possible to select a data source and config (...)
(...) list (System settings → Global parameters). Now, choose the BPS groups tab in the newly opened window. The tab window presents information in tabular form about all available BPS groups. You can filter the displayed groups by selecting or unselecting the Waiting for synchronization or Synchronized buttons. Click the Add () button situated on the right side of the table. The Add but (...)
(...) one of those issues is Magic Numbers. This post is rather for beginners, those starting their WEBCON journey. It focuses on the importance of using Constants instead of typing numbers directly in filter s, rules, and queries. This leads to easier maintenance and helps with understanding what some pieces of configuration do faster. If you want to learn why you should change this: to this: (...)
(...) bsp; The above example illustrates the cumulative effect of the action on a small sample of data. However, it is possible to configure it with the exact type of change expected, as well as using a filter to narrow down the values returned from the data source. Summary The actions on the Item list largely automate the work with this form field. Depending on the configured action, the a (...)
(...) cent activities using the keyboard Global search page and Form As part of the functionality, the global search results page has been made easier to navigate. This includes support for filter s and suggestions, as well as keyboard-based sorting of results. Fig. 6. Mouse-free navigation through the global search page On the form, users will be able to navigate editable inp (...)
(...) sources are created for the dashboard in future, this will help users to pick up the correct data source and associate with a given report). While in the Definition tab, also configure the Assignment filter by selecting the Active tasks value from the drop-down list, and the Predefined filter by choosing Created this month. As a result, the Head of the Department will get insight into tasks executed by (...)
(...) uch as global automations and business rules. These elements are grouped in a separate node and are visible only to system administrators. You can freely modify this default grouping method using the filter editor… option in the context menu that appears when you click the heading of any table column. In a similar manner, you can change the table's four default columns by selecting the Co (...)
(...) After successful authorization, all columns requiring authorization will become visible. Although columns requiring authorization cannot be used to configure grouping or additional filter s in the report setup itself, grouping/filter ing by such a column is possible from the view level after successful authorization. Limitations on Dashboards, Reports, and in (...)
(...) g. 5). As in the case of the workflow instance, the tagging menu is displayed after clicking on the icon with three dots. Fig. 5. Flagging in My tasks Moreover, after clicking the filter icon located in the upper right corner of the Tasks section (Fig. 6), the list of filter levels will be expanded. Selecting the Flag filter option will open another list. With this filter , the tasks (...)
(...) report, as determined by the step in which 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 filter s, row coloring, dashboard value filter ing, etc. Business rules and Form rules Workflow phase and Workflow actor variables are now also available in the dictionar (...)
(...) re constant, direct communication with multiple objects and structures. In such cases, a public REST API offers enhanced autonomy and more precise process control. It also provides greater ability to filter , paginate, and work on large data sets. In summary, if your integration needs primarily involve data recording, information retrieval, or basic operations within the scope of single processes or a (...)
(...) p; In this field, you must define an SQL query on the WFDataAttachmets table that returns the ID of the attachment to be signed. For this scenario, the query is limited to the current instance and filter s attachments from the To be signed category that have not been deleted. Fig. 9. Authentication configuration In the Authenticate section, select the previously created c (...)
(...) latest post I covered my personal No-Go's and their alternatives when using WEBCON BPS. The topics are: Fixed item lists and logic Dictionary data sources SQL Queries Always add a filter for the company Use order by, when using Top Build-in Users business rules Using the author field You can read up on those here. When you are starting with WEBCON BPS, I can (...)
(...) Hi, with the introduction of BPS Portal we got a few additional options were we can add "code" and where variables from the expression editor would be useful if not even mandatory. 1. Report - SQL filter , there are a few variables there already 2. Calculated field in Reports and BPS internal view, no option to use existing variables 3. Report - advanced formatting, no options to use existing variable (...)
(...) idea but not of much use, because it's lacking: a) possibility to fade the "Instance preview cards" out - this bar just uses way too much space that might be missing on the form then b) a chance to filter for workflows (and maybe other parameters)
(...) WEBCON BPS reporting offers great functionality for sorting, filter ing. 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 optio (...)
(...) ent's, but not always is good to see them all. When elements have many attachments the report is inconvenient and not look good. Where useful will be to set: - how many attachment's we wont to see - filter them by category or type of file on seconde side nice to have will be colapsing row to see only one attchment and after expand see more. The all will be very useful to do good reports ;)
(...) pi would be extended with methods to query datasources. There should be at least two methods: 1) getting a list of all available datasources (overall / by application) 2) query a datasource with a filter . To make it easier, the filter should be passed in as query string