(...) 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 date DIFF(day,WFD_Attdate Time3,getdate ()) >0 then 0 when date DIFF(day,WFD_Attdate Time3,getdate ()) = 0 then 1 else 2 end) The second column should pick the number of instances that have the conditions date DIFF(day,W (...)
(...) Hello Experts, We're currently on BPS version 2021.1.2.143 (getting ready for upgrade) I try to invoke a REST API to update form fields, and I get a proper response from the service, however, it doesn't update the fields. I'm using OData Query to filter and expand the data, and load the response definition from the service. The action configuration and action log with response are on my pictures. (...)
(...) Hi I am looking for a good toturial and is it possible to create a list of items where the item contains many attributes, e.g. a date field, text field, one below the other and not only just next to each other? That is, the distribution of attributes vertically and not only horizontally in the items. Found only this: https://developer.webcon.com/docs/2019.1/sdk-custom-control/
(...) internal view. This would allow us to define the system and global fields which are available for every process. For example I really would like to have the option to see/sort/filter the modified date and business entity which is currently not possible. I'm writing this post right now because I just received again a "bug" description without a link or even an instance id. I have a good idea whi (...)
(...) generation steps. Unfortunately, it is not possible to overwrite an existing Pdf when converting a Word document to Pdf. So we usually have to delete the original, but I would prefer having an update d than a new Pdf. I would wish there was an option like the Mode in the "Generate/Update a Word file" to select whether to update an existing file or to create a new file. A feature even WEBCON (...)
(...) everything works perfectly at this stage. However, I encounter a problem in the subsequent step of my workflow. After making modifications to the Word document, I aim to generate a PDF from the update d file. I am using the 'Finish editing a file using OneDrive' action that i can create my pdf. If I do not make any changes to the Word file in OneDrive, the generation works flawlessly. But if I modi (...)
(...) omewhat helpful, we know the reason, but we don't know the version of the package, in case we would like to be able to use it there is a need to setup an environment with that specific version, and update it. So how do we find a version number in .bpe package? First let's start with extracting it. Did you know that .bpe is just zipped file? ;) Change that .bpe extension to .zip, and use any too (...)
(...) Hi guys, got element with over 17k versions in history - it has been update d every 30 mins with a cyclical action. I would like to remove it completely, but am not able to. Got timeout using [Delete] button on element, as in the attachment. Also tried the archive action in button (removing completely from the database) with no luck as well. Do not want to remove it manually from DB. Any ideas how to d (...)
(...) have three environments: PROD, TEST and DEV. My current WebCon BPS version: 2023.1.3.169. There was a global problem with business rules in the TEST environment (it also occurred before the system update , i.e. 2023.1.3.76) - it is not possible to introduce a single new rule because an error immediately appears, as follows: Typ: System.ArgumentOutOfRangeException ---------------------------------- (...)
(...) d environment (Azure) that will never have access to classic domain controllers I need a full user database on EntraID (AAD). I tried with the free online instance of WebCon togeter with quite outdate d manual. It requires restarting some services as soon as you add AAD authentication to BPM - I didn't even have a way to check if it works because I can't restart services on public cloud infrastruct (...)
(...) Hi, I have a date & time field. I want the timeout to execute one hour from the date and time set in that field. How can I achieve this? From my testing, it seems to only consider the date and not the time. Thanks, Raluca
(...) l forms (children). It's 2 level tree childrens are leafs, they can't be parents. On those children forms, there are validation rules, which depends on data from the parent form, and a path [Validate ] which checks for required fields. To make sure that children forms are filled properly - when I'm moving the parent form to further steps I'm invoking that [Validate ] path on all childrens to make (...)
(...) 023.1.3 the plugin no longer works. I haven't checked the WEBCON BPS JS code in 2023.1.2 but in the new version: 1. the change function in the plugin triggers controller.change 2. this calls validate CCValueModel 3. Since the hasCustomModel is undefined 4. The default validation is applied and this validation fails. In the "past" I returned a string and now it seems that an Object is expect (...)
(...) Hi. adding users to groups causes an update of the user properties which downloads objects from Azure AD. Depending on the environment it can take quite a long time. - (7/2/2024 2:33:46 PM) Step started: Download selected objects from Azure AD if required - (7/2/2024 2:35:44 PM) Step completed: Download selected objects from Azure AD if required (duration: 118687 ms) While this is not a (...)
(...) oblem. I have an items list with REST API as data source where user can pick and book tools for some time period. Time period property is not included in REST API so I'm using form fields for booking date s. Then I need to filter the items list using tools from REST API and date s from WEBCON database to exclude unavailable tools. Unfortunately i didn't find the way to do it using the REST API filter av (...)
(...) Hi I have a question. I want to return all weekend days in SQL for my form validation. This is my SQL Code that returns these days, but only for the current month: WITH date s AS ( SELECT CAST(date ADD(MONTH, date DIFF(MONTH, 0, GETdate ()), 0) AS date ) AS date Value UNION ALL SELECT date ADD(DAY, 1, date Value) FROM date s WHERE date ADD(DAY, 1, date Value) < date ADD(MONTH, date (...)
(...) e have a timeout defined that is using the Executed at specific hours options selected? I'm trying to set the timeout to run at midnight but eveytime that I save, it changes it for 11PM. I have a date field, I want to use that date as the Start date and then make the timeout run at date + 12AM. For example: 17/17/2024 12:00 AM Thank you
(...) e have a timeout defined that is using the Executed at specific hours options selected? I'm trying to set the timeout to run at midnight but eveytime that I save, it changes it for 11PM. I have a date field, I want to use that date as the Start date and then make the timeout run at date + 12AM. For example: 17/17/2024 12:00 AM Thank you
(...) again] all done tasks and all need to do task (step) again if path "ocena raportu" (next step) then all need to finish step .. [when was 1 of all - then validation works, but I would like to validate only if the user is one of particular group. another problem is if i do conditions on that validation then is validate for last person but it should ship validation and hold only particular use doe (...)
(...) //community.webcon.com/forum/thread/2811 Still, this does not refer to a report basing on SearchIndex. How can I achieve the same effect in my reports? Of course, I can create an attribute an update it in each step, but this is very time-consuming, as I would have to update it on every path. Is there any other solution?