search results

(...) Hello, I need to set up two columns to calculate some KPIs for a report. The first one will show the status based on Case statement and date difference: (select case when DATEDIFF(day,WFD_AttDateTime3,getdate()) >0 then 0 when DATEDIFF(day,WFD_AttDateTime3,getdate()) = 0 then 1 else 2 end) The second column should pick the number of instances that have the conditions DATEDIFF(day,WFD_ (...)

(...) Hi, I would like to propose the ability to use HTML formatted text in calculated columns of reports. Now HTML tags are displayed as plain text, e.g. we can use only one link in row or not able to split/format text into lines. I remember that there was such possibility in Sharepoint reports and I miss it :)

(...) Hi, I propose to unify and add a visibility option available on the standard attribute ‘Visibility on report independent of visibility on form’ to the visibility option on item list columns . Regards.

(...) x. We checked the documentation (https://docs.webcon.com/docs/2024R1/Portal/Reports/#id_7), but it appears to contain outdated screenshots. In version 2024.1.1.187, the tab previously labeled "columns available in reports" is now named "Dataset columns " under the "columns " section. As shown in the attached image, the "Default sorting" section is missing. It may have been relocated, but we need (...)

Hi, Does anyone know how I can add a calculated column to solr reports? Thanks, Raluca

(...) d like to suggest an enhancement to the user interface of Item List (tabular) form fields within the WEBCON BPS platform. [Current Limitation] At the moment, users are unable to freeze specific columns in Item Lists when scrolling horizontally. This often leads to usability issues, especially in wide tables, where the first few columns (e.g., item name or ID) get lost from view. [Proposed Impr (...)

(...) Please verify the possibility of adding calculated columns to the dictionary data source. Regards,

(...) Please verify the addition of the option to add additional columns in the "Fixed values list" data source

(...) try and a link to a user or group could lead to a profile page. The screenshot shows the green marked column with the standard link to the instance behind the entry of the report's row. The orange columns should have links to the objects in the form field value and not to the object of the row itself. Kind Regards Sébastien

(...) Hi, it's currently not possible to define translations for the selected columns . While the default translations are used for process fields, there's no way to define a translation for a calculated or a system column. It would be great to define those on BPS Internal view level, so that there's only one source. Best regards, Daniel

(...) Hi, I have a MSSQL data source with a column newHash that get's created by HASHBYTES and VARCHAR(64) in the SQL query of the data source over some other columns to check if there is a value updated. This hash gets stored in the dictionary entry together with all other values. In the same query I also add the column with the diHash of the associated dictionary entry. When doing a daily sync between (...)

(...) Hi, I have an automation with a for each and selected "item list" as collection type with an item list (let's say A) of the form. Now I expected to get all columns shown under "columns collection" in the "Values" tab. But there is no entry for it. After searching a while I found the entry of this item list A under "Form fields" as the only item list. Why don't you just keep the same logic as it (...)

WEBCON: Business Process Automation and Management as its best WEBCON develops the Low-Code Business Process Automation Platform, WEBCON BPS (Business Process Suite). This enterprise-grade system allows organizations to embrace digital transformation by digitalizing their workflows and building comprehensive, scalable, process-centric and future-proof applications applying t

(...) mber Demand in person-months -> testing Floating-point number Demand in person-months -> marketing Floating-point number Personnel Item list with columns as in Fig.2 Personnel -> development Item list identical to Personnel but with a filter on the data source and visibility only in the delegation step from the Development departmen (...)

(...) ble with data from the form.   Configuration The first field to define is the Item list.   Fig. 2. The item list in WEBCON BPS Designer Studio   Then, add four columns containing the order data to the list – two of them are choice field type, one – text field, and one – date. On the form, three rows showing the orders have been added:   (...)

(...) ’) Assigned to the same category/task type (Task type)   In the WFElements table there are workflow instances from all processes so you must add the conditions for the individual columns : the WFD_STPID column contains information about step where the form is located, and the WFD_DTypeID column defines the form type (the form type ID). For more information about th (...)

(...) modified field value from an existing document In the choice field configuration (Autocomplete and Pop-up search window) there is the ability of transferring values from the data source columns to the fields indicated on the form. The limitation of this solution is the ability of transferring only the exact data that is in the source. If you want to modify data to be transferred, use the SQ (...)

(...) eById – comparing identifiers pickerCompareByName – comparing names   Each function takes a variable that refers to the picker column or one of the special system columns in their first argument. The second argument is a string of the id#nazwa form. When it comes to picker fields in multiple choice mode, these values should be entered after a semicolon e. (...)

(...) mation about tasks in the appropriate database table – WFElementTasks. By querying this table and narrowing it down to the instance ID (from the example), you get the following result (selected columns were downloaded in the query):   Fig. 9. The table contains information about tasks in the system   The WFT_FinishedByAdmin column informs you that the task has been comple (...)