forum
Hello everyone! Have u stumble upon this error when u make a request through the action and map the body on a field? In the body field as mentioned in the picture should be the body , the json but, is shown the type of collection ( System.Collections.Generic.Dictionary`2[System.String,System.Object] )
Hi all! I need to create an email alert that will be triggered if a Task Assignment Workflow is created for a specific user. My goal is to check if that user is a User Cal (has a Webcon licence) and if not send me an email so I can give the user the access required. I've created a Send custom email and I'm trying to define the execution rule that will be checking the previous statement. My query is the following: SELECT UCL_BpsID FROM WFElements JOIN CacheOrganizationStructure as G O (...)
Hello, I am trying to clear the contents of a technical itemlist which I use to put data into a word document. This itemlist works as a buffer and takes the rows of another itemslist which have with a YES/NO field selected as YES. The source itemlist always has different values so i need to refresh the buffer. I need an easy way to clear the contents of the buffer itemlist. Also, the buffer itemlist has to be COMPLETLY empty. I have found a solution but it leaves me a row with no data in it. (...)
We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from table Country) and 'City' So in City table, we have one foreign key that shows on Country table. (...)
We are about migrating content to WEBCON BPS. I would like to have at least the last modifying users migrated as well. How could i achieve this? Was thinking about setting a technical field to the last modifying user and then doing an SQL Update on the element after migration. Sure this is not the way that is officially supported. But is there another way?
I have a structure where a meeting (parent workflow) has many Agenda Points (Subworkflows). On each Agenda point, I have (inter alia) two fields that I would like to include in Meeting Minutes (an item list on Meeting), where each line item corresponds to one Agenda Point. When I finish an agenda point I would like to create a line item in the items list (meeting minutes). SELECT '{1805}' AS {DCNCOL:253} , '{1891}' AS {DCNCOL:254} , '1' AS {DETCOL:1910} FROM WFElements WHERE WFD_ID = {WFD_W (...)
Hi all! We are currently using the Google Maps field with address-based (dynamic) mode for registration of clients, which is in my opinion very user-friendly. The problem is, this mode shows the correct position on the map, but it doesn't store anything in the workflow item. We want to store Longitude and Latitude (e.g. in 2 extra fields of the process/workflow) along with Street, Zip and City (which is already happening). I hope you know, what I mean. Is this even possible without develop (...)
I'm banging my head on the wall... I'm sure there is an easy solution but can't figure it out at the moment. I would like to prevent users entering duplicate values in a field when starting a new workflow and I don't want to use the Instance Number to achieve that. I have a process ABC with field WFD_AttText1. How do I prevent the user to enter a value that already exists in the field WFD_AttText1 of the process ABC? Thank you.
Hello, I hope you can help with this! I need to guarantee that a file in the attachments is checked-in (so the version will be different than 1) before moving the workflow to the next step. In the validation form, I don't have the attachments system so that I can construct a query to verify this. Does anyone have an idea? Thank you!
I am using Exchange events action to add a meeting request to the meeting participants. Everything works fine, but it is not possible to add parameters isOnlineMeeting, onlineMeeting, and onlineMeetingProvider. I tried to resolve this by updating the calendar entry via MS Graph API – Calendar/events. From the Exchange identifier, I was able to determine what would the id of the event be (everything behind #), but when trying to update the event with two additional parameters (isOnlineMeeting, a (...)
Hi all, i hope you are well. We have moved our PROD-Environments Databases to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old databases are offline. Currently there is still an alias configured, that routes traffic that might go to the old SQL-Server to the new one, which is okay, but nothing we want to (...)
I try to read/load in an xml-file in the Webcon application about the attachment section. Then I build myself a choice picker, where I can chose the selected file. After that I want to run an SDK action, where I get the data from my xml-file. In my code I implemented something but the file path is static at the moment and compares the file names. Normally every read in file gets an ID in the database but I don't know how to access this data. Has anyone experience with this and kno (...)
Wondering if it is possible to open the attachment preview dialog by using javascript only. Does anyone already tried to do this? There is the possibility to open the latest attachment, but that's not the solution i'm looking for.
Hello everyone! I have two questions. 1. Did anyone use the absence process template as the time schedule for the employees? My client has many different shifts for employees and I was thinking of presenting the data with the mentioned process. Any ideas would be appreciated. 2. At this point my main problem are the colors presenting the vacation type (which in my case would be the shift). The Vacation Type data source has only 6 available colors. I need more than that. Does anyone know if w (...)
I try to implement a ConfigEditableItemList in a custom action in C#-code. When I go over the ConfigEditableItemList I get the message: "The class with the item list configuration must implement: IConfigEditableItemList". I implemented an example but when I upload the SDK into Webcon I get an error that there is the implementations missing and I can see nothing from the SDK. Has someone experience with the ConfigEditableItemList and can give me a better example? Photos from the case are (...)
By having a copy of a external file as attachment instead of only having a link to it, we can take advantage of the great preview functionality. How ever, having copies of a file increase the risk of having multiple versions and loosing track of the relevant document. In my case, we have customers who wants to link to files in SharePoint and other dms. So I'm wondering, how you guys solve this challenge. I'm currently thinking about a simple itemlist having a hyperlink column to store the lin (...)
I haven't found any documentation how to access the current form data. What I know is, that all the formdata is kept in a json property called liteDate.liteModel as a json-object as you can see when calling /api/nav/db/{dbId}/app/{appId}/element/{wfdid}/desktop I guess that this liteModel must be available via javascript. I'm wondering, because there is this form from the offical 2021 release paper (see below) with the nicely presented workflow steps on top of it. And I believe that this a (...)
Hey everybody! Does anyone already created an action to add news values in an item list? I'm trying to add a new line in one item list but one of the field I'm copying into is a Person/Group one and it doesn't get the value. I'm using the following query: select '{WFCONCOL:1769}' as {DCNCOL:105}, 'Requester Manager' as {DCNCOL:104} from WFElementDetails where DET_WFDID='{WFD_ID}' and DET_WFCONID={WFCON:1652} with the unique value set to be the row identifier Anyone with idea (...)
Hello, I'm trying to start a subworkflow from an item list. My item list will have the candidate for Positions and it will not be filled at the same time, each time there's a candidate for an offer, the user creates a row. To start my subworkflow I'm using as conditions having the candidate name as not null and a flag set to true and i'm using this as an execution condition with the following SQL: if exists ( select 1 from WFElementDetails where DET_WFDID={WFD_ID} and DET_WFCONID={WFCO (...)
During the latest webinar Mike mentioned the GitHub Tool for bulk data loading. Does anyone know where I can get it? I didn't find it on the WEBCON-BPS page on GitHub. Thank you in advance for your answers.
+48 12 443 13 90