WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Top rated

top rated

MVP

Hi everyone, I had the requirement to calculate a reminder date based on a due date. This should be x days before while respecting the working day calendar. SQL Command for calculating a date _after_ the base date, attachment (1): select Top 1 [CAL_WorkingDate] from ( -- Top: number of working days before the base date SELECT TOP {BRP:13} [CAL_WorkingDate],[CAL_IsWorkingDay] FROM [dbo].[Calendars] where [CAL_WorkingDate] > '{BRP:14}' and CAL_IsWorkingDay = 1 orde (...)

Hello Everyone, We have a process by which we send e-mails, but at the same time I'd like to save the e-mails sent as attachments. Does someone know a way to do so? Thank you!

Hello, I tried to import some templates from DEV environment to TEST environment and when I uploaded the .zip archive the following error occured on the .xlsx report: "Value cannot be null. Parameter name: securityProvider" Does anyone know why do we get this error? Thanks!

Hi All we have a large report build in one of our processes (list of all invoices which contains >350k items) which is now not loading for users. we have rebuilt it in SOLR and it is fast like TGV train but we had some calculated columns based on item lists which we need to rebuild. Is there any manual, KB article that describes this or anyone having expierience?

Dear Community, is there any method to hide history of an element/task from a specific group of users? KR, InnFlow Team

MVP

Hi everyone, let's be honest the search option is more of an autocomplete. Nothing wrong with this since you can still get some useful information. Nevertheless, I prefer searching this site using a major search engine. Since I don't like to do repetitive tasks I put together some JavaScript which speeds this up and can be executed on any (public) site by clicking on a bookmark. Unfortunately gifs aren't allowed so I attached a screenshot: 1: Search results from the community 2: Executing the (...)

Is there a way on a new record to prepopulate an item list with static rows? The idea is for each new workflow started, an item list would have 6 rows already setup to have other data entered. Nevermind, I found it :) https://webcon.com/item-lists-repeating-data-done-right/

MVP

What would be the best method to get the attachments of an instance inside an SDK plugin in order to make use of them in C# code?

Hi, On the form, I am using the Chart data field. I am wondering whether it is possible to use the chart field in the Word printout report. Is there an alternative way to draw a chart based on the form data in the report? Maybe in HTML report. I was also thinking to put chart into the Picture field that is supported in Word templates. Any insight on how to approach this would be appreciated. Best regards Aleš

Hi everyone! This is not my first installation of WebCon BPS, but it is the first time I experienced this error. Everything worked fine until Users list configuration step. When I try to configure the local AD as source for synchronization, I receive the error "The parameterized query '(@Email nvarchar(4000),@DisplayName nvarchar(4000),@BpsId nvarch' expects the parameter '@DisplayName', which was not supplied." I assume, that for one of my service accounts the property display name is not se (...)

Hello All, Big project regarding to reservation system is ahead of us. And one of the very useful feature will be gantt chart on the form and as web part as well. So is there any plans to implement Gantt charts in next Webcon BPS versions? Or maybe there is posibility to prepare Gant Chart in HTML attribute? I mean off course Gantt charts in Modern Webcon BPS, because we wouldlike avoid to built new app on classic SharePoint, where gantt charts are available.

Hi! So I have this Item List in "Orders app". Lets say it has 10 columns. 6 Of those columns can be editable depending on subprocesses or other proceses. So there is a query, that if returns 1 it means that column can be edited by a user, if 0 then the column in this row is blocked. For that I am using "Column edit restrictions" from the "Permissions" tab in the studio. And it works great. For few rows. If there are more rows it works really slow. I made some analitics. The query is executed (...)

MVP

Hello, in the 2023.1.3.29 version, we have apparently identified a reproducible bug. In our case we are using a text field to store a time value. The goal is for this to automatically replace a period ('.') with a colon (':') after input (Style and behavior). The error occurs when we attempt to replace every period ('.') with another character using STRING REPLACE, specifically in the case of "15.00" where we want to replace each period ('.'). Instead of just replacing the periods, ALL (...)

MVP

Hi, I encountered the following error. I have an action that sets a value in a choice field. I set the choice field through the value of the ID. When I enter the form, the value is correctly set, and it displays the name corresponding to the set ID. However, when I enter the report, in that column, I see the value of the ID instead of the name. I tested by setting the value in the choice field as follows: id#name, and I no longer encountered the problem. Why does it behave differently (...)

If I have tasks assigned to me in a given application, are they always listed from the newest to the oldest? Can I somehow make a given application stand out so that it is at the top of the to-do list?

Hello, I have a simple workflow that is translated from fields to steps and paths. When I change the language from the portal the preview picture of the workflow does not change. Should the language of the workflow preview change based on the language of the logged user? Regards

Dear Community, Microsoft recently announced that the new default font for Microsoft 365 applications is changing from Calibri to Aptos: https://support.microsoft.com/en-gb/office/new-office-theme-e7bbfe02-d1fb-4c4d-b3b7-6a47f0cefd3f If you already have this font on your device, give it a try in WEBCON BPS. In my opinion, it looks really good in WEBCON BPS Portal. If you want to test it, just set global CSS style in your configuration: body {font-family: Aptos} This may not be the b (...)

Hi everyone! We are currently using BPS 2023.1.2.44 in our office. Is it possible to exclude certain report columns from an Excel export? We need to display the columns in the Web report, but don't want to show them in Excel. Best regards, Christoph

MVP

Hi, The name of the virtual machine where the service was installed has been changed. Does anyone know the required steps to get WebCon working again? Thanks, Raluca

MVP

I've noticed that when I import from the development environment to the test or in production environment, custom visibility configurations for reports or start buttons don't get imported. For instance, I've set a button to be visible only for a certain group; the configuration remained as custom visibility upon import, but the group disappeared. The groups were created in the development environment and imported into the other environments. Thanks, Raluca