most commented
Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Klaus
Hi Guys I need your help. I start tasks based on a workflow but attachments do not transfer. If I do it manually as a action on path then the attachments move to subworkflow and its ok. But if I use a cyclical action to call the same action -> "create SQL subworkflow", tasks are created but without attachments :/ Example in the attachment, I trigger the same action: Uruchom zadanie TEST (en: Run the TEST task) I use version 2022.1.4.223
Hi All! Does anyone have experience with integrating WEBCON with SAP Success Factors, particularly Employee Central?
Hello, I would like to build an app based on a parallel approval. (2 different tasks) 1. Approval for Manager 2. Approval for Economics The process must wait for those 2 approvals responses and then decide on condition. (continue process or stop process) Do you have any ideas / suggestions on achieving that? Thank you.
Hello everyone! I have an item list with a dropdown field where user chooses a WFD_ID value. I would like to execute an action (Update related workflow instance or Invoke REST web service) passing the WFD_ID chosen in the mentioned field to the action. Is something like that even possible? I can't find a solution myself. Thank you, M.
Hello, I have a short question. I want to generate an Excel file with my data from the BPS datasource. I created an Excel template with a worksheet(test) and a table(myTable) and a action create excel. I write the assignment like this: test!myTable and my data to the right cell. But I always get an error. (Invalid cell name) If I just want one data set and just write the cell names for each like test!A2, it works perfectly. What am I doing wrong? Thanks for some hints, Mario
Use case: We are using an offer process/workflow, where we fill in the costs in a table - e.g. columns "descripition, quantity, price per unit, total price." In case the offer is accepted and we'll need a change request of the costs we need a two separate process steps. The first step will start the change request, opening two additional columns in the table - "quantity for change request, total price for change request". This can be done for every existing row in the table. In the next wor (...)
Hello all, Is there any way to use the same data table field but having different filters in each step? For example, on the start, I want the info to show request's open for the requester In the approval step, I want to check the request's for the project code belonging to the approver Is there any way to do this without having three different fields to achieve this? Thank you!
There are two date fields in our workflow. To pass the process to the next workflow step, we use an action "on timeout". Checking for a date field works. However, we need a condition for the timeout that takes both date fields into account: If date field 2 is non-empty take this date for the timeout, otherwise take date 1 for the timeout. Can this be implemented with an "on timeout" action and if so, how?
Hi all, I was wondering what the best practice is when using SQL queries in Webcon with attributes, tables or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This means that after each transport from the Dev/Test to the Prod environment, the attributes, tables o (...)
23.06.2023
11:35
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 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 (...)
Hi We recently changed the version of Webcon from 2020 to 2022 and I came across this problem. In the report we used a calculated column to show comments: (SELECT ISNULL (dbo.f_clear_description(wfelems.WFD_SIGNATURE), 'None')) However, from what I can see in database, the comment format has changed and now when using this function I get an error: "Invalid length parameter passed to the LEFT or SUBSTRING function." In the attachment, I marked in green old comments, and those starting w (...)
Hi all! We are using the action 'Invoke REST Web service' a lot, but there are some limitations I am struggling with. I want to download an Excel file using this action, using an external REST service. My first approach was to store the response body into a multi-line content field. I am also using a HTML field with a download button, to save this file from content field to disk. This method is working very good with plain/text. After saving file from Content field to disk, Excel (...)
Hey there. What's your preferred way of hiding form fields on page load? In my scenario form fields should remain hidden, unless a form field rule from another field was triggered on value change that 'unhides' the target form field. I've been doing it the following way: 1. Make the field that should not be shown upon form load visible in the Field Matrix 2. Insert the 'Hide' JavaScript function into the main form behavior of the step 2. Create a form rule which shows/hides based on (...)
Hi all, does anyone know why this error is showing or how to fix it? It appears when I try to change the position of the fields in the form.
Hi, I'm having trouble converting the contents of an attachment to BASE64. On the system step I have a TimeOut that calls the transition path after a minute. In the traversal path, I have an action that calls a web service. The frame uses a business rule to convert the content of the attachment to Base64 (the business rule returns the text value of the last attachment). When the whole thing is handled by TimeOut, I get the error: Message=Error executing SQL rule Create Attachment Base64 (I (...)
Hello, I'm facing a challenge. I'm starting the workflows from a hotmailbox so I have no control over the attachments order. I'm also using the "Show first attachment on page load". I believe the system shows the attachment with the lowest ATT_ID. Is there any way to control which attachment is shown on page load? Thank you, Martin
Hello community! I’d like to pick your brain about something that has been bothering me for the last hour. :) Does anyone have a solution for this? User enters the date in the date picker field (AttDateTime) and hits TAB: - if the value is 8 digits, then SET(AttDateTime) = CONCAT(using values from AttDateTime) - if the value is 6 digits, then SET(AttDateTime) = CONCAT(using values from AttDateTime) - else do nothing I can't seem to find a way to do that. Is it even possible? Thank (...)
+48 12 443 13 90