Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not working. I've added a screenshot. If I use the field manually, I'm able to get that specific lin (...)
Hello, I have a workflow and a final step where i execute "On a timeout" automation. But sometimes, it is not executing because it says it is checked out by the user. WEBCON BPS Timeout ID (TIM_ID): 2 Message: The element has been checked out by user: Is there a way to prevent this thing? So you cannot edit the form on the final step?
Trying to update my current dev env to the latest version that is available on the website. I'm getting the error message below. not sure how to resolve this. Date Message 6/6/2023 9:16:07 AM Invalid column name 'S_LicenceServiceLocation'. It won't get past the error attached in this thread. It's happening on the "Components" section Upgrade- WebCon BPS WorkFlow Service. Current Version is WorkFlow 23.11.41 Portal 22.12.31 Search Server 1.0.29.0 Upgrade ver I'm attempting 20 (...)
At Webcon BPS, on the form's list of items, I have a checkbox field and a second field of dropdown(choose) type. The second filed - dropdown field retrieves data from a data base and allows for adding values outside of the database. The first filed - checkbox field determines whether the value in the second field is from the source or added externally. How can changing the value of the checkbox field affect the behavior mode of the second dropdown(choose) field?
Hi community! We need to add 'active' HTML elements to an item list, e.g. a button containing some Javascript to set a field value or a label with a custom tooltip on mouseover. Is that even possible in an item list, we didn't find any solution for this up to now? Thanks a lot for your input, Best regards, Nik
I'm having some troubles using OPENJSON to parse a nested JSON response from a REST API: Following the solution posted at https://alterpaths.com/json-nested-collection-handling-in-webcon-bps/ but I cannot get the query to work in Webcon. When copying the whole query from the Show window into SQL Studio it works just as expected, but in WebCon Designer studio the following error occurs (see screenshot). Any ideas how to proceeed here?
After upgrading WebCon to version 2022_1_4_204, a problem arose with synchronizing BPS users lists with Azure Active Directory. When synchronizing, the Event Viewer displays the following error. System.Memory Category: Exception Role: UserSynchronization System.IO.FileLoadException: Could not load file or assembly 'System.Numerics.Vectors, Version=4.1.3.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not matc (...)
I'm having trouble running the SQL subworkflow. The query entered during the configuration works fine in testing. However, when I try to run the subworkflow in the application, I receive an error message that says, "An error occurred while executing the start subworkflow (SQL) action at the path. (Step: Verify application, Path: Submit for review) Incorrect syntax near the keyword 'from'." What could be the cause of the error if the test query displays values correctly?
Hi, I want to use the action - Send a custom email and get email addresses from a Dictionary. I checked "Selecting addresses by SQL/CAML query" and as Data source: i chose my Dictionary When i write a SQL query it doesn't filter. It shows all columns and rows. In my workflow i have a choice field Vendor name (from a Dictionary - it contains Vendor Name, Vendor Email). When i pick that vendor, i want to send an email to that vendor. Can you help? Thanks.
Hi all, I would like to ask if anyone has configured or knows how to have a bulk update in a item list. For example, the idea is to have many lines and select the ones that will move from Project A to Project B and then all of those lines will create a subworkflow to request an approval from person X. Also, is there any option to select prior the lines that will be in the item list? Like a pop-up table with all the lines, and then only the ones chosen will be in the form. Thank you!
Hi there. before I search forever; has anybody a hint how I could define an action (Invoke REST Web Service) where I can read a picture from an URL ( e.g. https://qr.myurl.com/wp-content/uploads/qyrr/177/qr-code.png)via GET and store it in a picture field? Thanks in advance! Klaus
Dear Community, I have a question regarding serach option (Search everywhere on top in portal version). When I add permissions to the process (via permissions tab in BPS Studio) for some user / group of users (i.e. permission to all elements with attachments) how can I trigger any action to index it in Solr? From user perspective, when he / she search for particular document in search everywhere not all results are available. I can edit single document and save it, so it triggers Solr i (...)
Hi, Suppose I changed Webcon to a version without sharpoint. I have a PROD database and I would like to select the last year from the database and overwrite TEST, is this possible?
Hello. Have any of you done archived (completed)process migration from Sharepoint? Are there any built-in solutions? I would appreciate for any hints.
Hi all! I am really struggling with this action. I am trying to send JSON data to a REST web service. JSON string is generated by a business rule, which contains a JSON Query (FOR JSON). Testing this business rule works fine, also umlauts are shown. My configuration in request body is body type: Binary, which is the only way to send dynamic JSON data. Somehow my encoding (which should be UTF-8) gets lost. I am sending Content-Type:application/json in binary part headers, my ass (...)
Hi, I am attempting to change the number of decimal places in a floating point field. I am getting: System.NullReferenceException Message: Object reference not set to an instance of an object. Any ideas how to solve this? What can I do to give you more information? Thanks
Hi community! We have 2 choice fields, first one is a dropdown (field1), second one has behaviour autocomplete (field2). Dependent on selection in field1, datasource of field2 (which is an SQL query containing value of field1) changes. This is working as expected. Picker search mode of field2 is set to 'Contains', minimum characters = 3. Regardless of what is entered in field2, all available entries are shown and are not filtered. Any ideas why this does not work as expected? W (...)
Hi everyone, maybe we can gather all the changes anyone encounters when testing the new version in a single thread. It won't take much of your time and will potentially save you more when others do the same. I will start with this one: SQL command: Varriable WFCONCOL_ID : WFD_DTYPEID = {DT:12} and {WFCONCOL_ID:153} = {WFD_ID} has been "translated" to WFD_DTYPEID = 1 and dbo.ClearWFElemId(WFD_AttChoose1) = 2 and is now replaced by the Calculated field WFD_DTYPEID = 1 and WFD_AttCh (...)
UWAGA! Najnowszy pakiet 2023.1.1.41 w pliku instalatora WebCon.WorkFlow.Service.Installer.msi zawiera wirusa IL:Trojan.MSILZilla.11432 po instalacji wirus przenosi się z plikiem usługi do C:\Program Files (x86)\WEBCON\WEBCON BPS WorkFlow Service\WebCon.WorkFlow.Service.exe
Hi everyone! I am developing a document repository. Has anyone come to a solution on how to record each attachment access by a user? Users will access documents that are already in the archive (finish step) and will not be assigned to anyone. In some cases I would like to know who read a document in pdf attached to a process. Any ideas on how can this be accomplished?