By TOP i mean SELECT TOP(for example 50) SomeColumns, OriginalIDColumn FROM YourTable WHERE OriginalIDColumn NOT IN ( SELECT WFD_AttributeWithOriginalIDColumn FROM WFElements WHERE (logic to catch only documents from your process/workfllow/doctype)) It requires you to add te
I'll add third approach - you can use global cyclic action with start subworkflow action. Basically you write the select for data you want to import with mappings which column from your source is which field in Webcon. Add some identifier field in webcon, and filter out those that are already
Hello, I'm not 100% sure, but it might not be possible. I've tried once sending request with nested arrays with SOAP action, but i got an information there, that's not supported - not sure if thats case for REST response.
You can use SQL Command with that query: SELECT CEILING(RAND() * 3) It should return value from range 1,2,3
Hello, In case of flowchart resetting paths layout - i'm having same behaviour in 2021.1.5.367, and from what i remember it worked like that. I just stopped using it right away, after first reset. I'm trying to deal with it by changing start/end point of path on the step blocks. Never had pro
You could download ready template from here: https://community.webcon.com/online-store/app/absence/7, and make a quick look how it works. Also at knowledge base there are those articles: https://community.webcon.com/posts/post/absence-plans/262/20 https://community.webcon.com/posts/post/absence-r
Hello, it depends what kind of reports you want to create. Should it be a word/pdf/excel document, should it be built in report table/graph view? You can create cyclic action, which will be executed every x time -> https://community.webcon.com/posts/post/cyclical-actions/106 I'm using it to
A simple change, there is a button 'Ask a question' on both Forum and User Voice, lets make it different :) 'Ask a question' is good for forum, that's what forums are for. For User Voice maybe change it to something like 'Make a suggestion' or 'Share an idea' ? - it will be clear what kind of
Let's start with a use case. I'll be working soon on a process for ordering buisness cards, which will include graphic, who is responsilbe for preparing files which are sent to printing company. On the buisness cards there should be QR code with vCard data. We want to avoid manual process of co
It'll propably be a detail, but cast it to INT, as ClearWFElemID returns NVARCHAR.
Within your select, you can rename DET_Att5 to COM_ID, as written in context help (see screenshot). It should override whatever you have typed in Default configuration tab. @Edit Seems like Karol was faster, and i havent refreshed my browser :)
Hello everyone, In this case i'd consider just conditional task assignment. As Daniel already pointed out, you can use Buisness Rules for that. On the form you could add a dropdown with 2 values: * Order for IT * Order for Economics And in the Buisness rule you just go with IF Order for I
Hello, you can change it in two ways: * Per workflow In the navigation tree go application -> process -> workflow -> default form, there will be a dropdown on left side, above form subtypes, 2nd from bottm. * Per workflow step (this one breaks inheritance) In the navigation tree go applicat
Hello, I've faced the same problem - API we've been using was returning Content-Type: application/download, and Content-Disposition: attachment. Ended up creating SDK action - took less time to write, than testing all the creative ways to do it with 'Invoke REST Web service'. I'll be glad too s
Hello, you can check each element history through web ui. Then using Admin privileges you can look into action log.
I'd love to have something like that, for signatures and for acronyms as well. Even with not so many applications it's easy to get conflicts.
How about changing direction of communication - it seems that Mailgun have endpoint to get stored email: https://documentation.mailgun.com/en/latest/api-sending.html#retrieving-stored-messages You could periodically check for email from webcon perspective, it's not as clean though.
Thanks for response, unfortunatelly in that case i'm dealing with 2021 (forgot to mention earlier), but upgrade is on the way so i'll for sure give that a look :)
Hello, is there a possibility to use existing SOLR as Data Source? I had an idea to show users SQL grid, which would show similar items found in database, based on text typed in regular TextInput field. That lead me to Levenshtein Distance algorithm, which might be slow in SQL, but i've found th
There is already User Voice for Dark Mode in Designer Studio here: https://community.webcon.com/forum/thread/2190/15. Make an upvote there :)