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 (...)
Hi, i would like to disable links on raports on LookUp Fields, is it possible?
Hi, We have been getting more and more timeouts in our processes lately. For example, we are getting Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out. What could be possible reasons? Where can I start researching? Thank you!
Problem with synchronization exchange rates from NBP (404 - Not - Found)
Hi there, I'm unable to delete a step in the Workflow Designer window. It says (see screenshot). I can find the step in the db: SELECT * FROM WFSteps WHERE WFSteps.STP_ID = 95 But no associated Wf instances with it: SELECT WFSteps.STP_ID, WFSteps.STP_Name, WFSteps.STP_Description, WFSteps.STP_IsFinish, WFElements.WFD_ID FROM WFElements JOIN WFSteps ON WFSteps.STP_ID = WFElements.WFD_STPID WHERE WFD_STPID= 95 It's not an option to use the admin tools to delete all instances f (...)
In the last 2 weeks several customers have asked me if it would be possible, that if a comment is required for a path and the error windows pops up, the comment can be entered directly in the popup window and the path transition can be done from there? When trying to set the comment using JS the path transition validation won't recognize it and still trigger the error. Has anyone of you an idea of how to solve this or maybe already solved it? Thanks Pasquale
Dear Forum I am trying to remove SharePoint list items in one of actions. It works well when I pass a sharepoint item ID, but I do not have this available in webcon. I would like to delete an item based on other column that I have. I tried CAML query below, but it does not work. Tried different columns, tried "" and '', tried contains but it does not work. Any ideas how to do it properly? <Where> <Eq> <FieldRef Name="Project Code"/> <Value Type="Text">3153</Va (...)
Hello community! The question is not strictly Webcon related. Does anyone have experience with SAP, specifically how the sending of IDOC works? I need to receive the file but am banging my head against the wall how this works. Any ideas/tips would be much appreciated! Cheers, Martin
Hi Guys, I'm wondering if anyone else has been having this problem. When i try to add (upload) a file to an item list using a local attachments column there seems to be a hard 4MB (4096kb) limit. When i delete the line, save my process and then link an existing attachment it works fine but for my purposes this is not acceptable behaviour. Is there any way around this? Thanks for your feeback Pasquale PS: I'm using 2022.1.4.61 Update: It seems that it has to do with the limita (...)
Hi, I'm trying to update an existing instance or create a new instance with REST API. I'm using api version 3.0 and Postman. I want to put data to choice field, but I know only name from data source. It's possible at all? I tried to put a value in two ways: "formFields": [ { "guid": "c2e37260-5d57-410e-997c-1f19bb12a4c0", "svalue": "USD" } ] System always trying to fit value "USD" to Id, but ID is different, (...)
I've got a contract database workflow. One of the fields on the form is Project/Department field which is the same as user department in AD users list. Two users: Adam and his boss John. Is it possible to: 1. show in the report only these records, where current user login (account) department is equal to Project/Department felds. 2. on the app home show instances not only created by the current user but all instances created by John's team? At he moment John is seeing Adam's data but this n (...)
Hi community! We have a customer who wants to deny access to the landing page in Webcon (/). Users should be redirected to their application (there is only one), also navigation tree on the left should be hidden. Is that even possible or maybe planned for a future release? Looking forward to your inputs. Thanks in advance & best regards, Nik
Hello all, I know this as been asked in the forum, but I have an issue with the action Move workflow. I've read the answers for another user, but I think I can't use the example on the https://alterpaths.com/massive-update-of-sub-workflows-in-webcon-bps/ because for my case I have 5 different chains in the Child workflow and each of them as their own Complete and Cancel step. This was working prior for the cancelled but I'm wondering if this only works if you have one final step (either (...)
I need to add custom header to the soap message, e.g. i need to pass formfield value to the header section. How can it be done? Thanks in advance. W