WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > User profile Christian Amler > Forum messages

Christian Amler

User

Reports - SQL Function
11.01.2022 13:45

Yes. see this: https://community.webcon.com/posts/post/using-calculated-columns/196

Hi, I have created a report, in which i am only interested in showing the Year-portion of a datetime-field. This works good until i try to group for the shown values in there. The groups are not built by the years in this case, but still on the entire value. It would make more sense to group acc

Hi Robert, thanks for asking! I would be very interested in this as well. After recent update to 1.4.36 the bigger SQL-reports are very slowly loading, for some users they won't load at all and throw an exception. I have rebuilt them as SOLR reports, but am missing info on how to get columns ca

Hi all, we created a new workflow, mainly to store information about our companies and important documents for them. To make sure the users attach a structured set of documents, I created a dictionary of document types, along with translations for them which are defining which document is attache

I would use Exist query. If exists (SELECT field1 from table1 where condition) select 1 else select 0 Will return 1 if there is at least one result line for your query, and 0 if it gets no matches.

Hi Thomas, might be related to what we experienced with adding attachment to unsaved instances: https://community.webcon.com/forum/thread/932 Cheers Christian

Hi Pawel! Thank you for your quick reply as always. We are running modern forms since 2020 on Sharepoint 2016 foundation. Thanks! Christian

Hi, we just updated on Friday to Version 2021.1.4.36. Just now a user called and showed me that she is getting an unknown exception error when trying to add an attachment to a manually created new instance. She has the rights to do so, and can add attachments as soon as the instance is manifeste

See https://community.webcon.com/forum/thread/40/15 it is actually 999 lines and one line for the header ;) Webcon tagged the request with "not now". We had the same issues. I guess it has something to do with server ressources, and users being able to crash the server when exporting huge data-s

Hi Darek, in the configuration of creating a sub-WF there is an option to write the Sub-WF WFD_ID to a field you can specify. Hence you need to create such a field (most likely technical), and then choose it as target for sub-WF-ID on the advanced tab of start SUB-WF configuration . After the acti

Yes, please! And if possible not only in the Formfield configuration, but also in the OCR-Templates.

Hi Michał, I have the same on our DEV-System with 205. The field that generates the value-list is in an item list somewhere on top of the form. Although I couldnt force it to throw an error and it always pops in place after like 1-2 seconds. Thanks for letting us now. BR Christian

Hi Przemysław, thanks for confirming, we will just wait until the fix is out before going live with the new version. Unfortunately the load of information in the data source requires it to be picker, so people can use it's filter capabilities and bigger pop-up. If you could also have a look in t

Hi, despite the bug described in this thread: https://community.webcon.com/forum/thread/555/46 having been removed in 2021.1.3.143 (tested, worked fine), something similar is happening in 2021.1.3.163 when you use a picker field in an item list, and map it's data source-columns into other colu

Hi everyone! I was just evaluating the latest version (2021.1.3.163) on our DEV system, and wanted to prepare new functions for my processes. I had issues when trying to save a rule that included the new "select values" function to check if a collection of values from an item list is not empty. I

Thanks Daniel! I just found out I can't issue a support ticket, not sure what to do now - I think I have to inform our partners so they can inform Webcon. Will do tomorrow. Thanks for your effort!

Hi, we recently upgraded our DEV-Environment to latest 2021.1.2.136. Today i was evaluating the new version with our existing processes, and stumbled upon something that didn't occur to me in the past. I have a crucial picker field in an item list, that has target fields from some of the columns

Copy Past a table in Webcon
21.05.2021 01:29

Hi Andreia, if the data they get from the application is an excel with always the same column-structure you could build an item list and use the import function webcon offers in the item list configuration. To do so you need to create the same columns as in the export from the booking-application

Thank you Daniel! I have built quite a few rules to get that behaviour for the most problematic fields, having it out of the box would improve things a lot! :)

Hi again, problem most likely is that always one field is empty, which will cause trouble with date functions. so you need to make sure you only calculate the datediff when both fields have values. Didn't think of that :) See screenshot below.