Daniel Krüger (Cosmo Consult)

Hi Darek, you can achieve this by using the update related workflow instance action: https://community.webcon.com/posts/post/the-update-related-workflow-instance-action/81 You could execute this action during the sav trigger of the parent workflow. Regarding the "same field": All workflo

Hi Stanisław, the suggestion of Martin could be a start, a complete picture could look like this: 1. Use "Start subworkflow (sql) action and use a query like this select distinct director as RESPONSIBLE_Database_Column from WFelementDetails where DET_WFDID = INSTANCEID and DET_WFCONID = ITEM

Hi Nik, I stumbled about the "Throw error" operator which is only available inside a condition just the other day, see the attachment. :) Without it, I would probably have used the "Valide form" action which would also throw an error. Best regards, Daniel

A new knowledge base post has been added: Quote: "When installing BPS databases on SQL server higher than 2014, changing the Compatibility Level of WEBCON BPS databases from SQL Server 2014 to a higher level is not recommended." https://community.webcon.com/posts/post/compatibility-level-of-web

Hi rohans, I don't know where you life but in Germany for example the bank holidays depend on the region you are living or working in. So a simple table like the non-working dates isn't sufficient. That's probably the reason why the "Days off" data source template has been added. With this data s

Hi Klaus, in this case I would convert the origin data to a value which is excepted using sql. For example select Inserted, case when Inserted = '' then null when Inserted = null then null else convert(datetime,Inserted) end as InsertedDate from ( select '2022-01-01' as In

Hi Klaus, maybe I missed something but I didn't understand which action/method you are using for the data import. Are you using some external tool which uses the REST API, a start workflow (sql) action, import using excel in a dictionary or item list? Or is it something else? A screenshot c

Hi everyone, did someone came across an option to verify, whether the save has been triggered by the save button or by a path transition in a form field extension logic class? I did check to no avail: - Public properties - Non-public properties - Passing {CURRENT_PATH} inside the configurati

Hi, I'm not sure why you want to do an extra REST call which could fail, if you already have the exchange rate data. The only idea I have is that you really need the current rate. But this is beside the question. Which API do you want to use? Do you want to use the NBP API? Maybe I have overlo

Hi Martin, I haven't used the OCR, yes there are thinks I don't know. :) If you really need this, it could be an option to use the Azure Cognitive Services to extract table data via REST: Enhanced Table Extraction from documents with Form Recognizer https://techcommunity.microsoft.com/t5/a

Hi Stanisław, if you want to rename all occurrences in all application you have an option. There's the BPS Translator which provides an option to easily translate values of the user interface. https://community.webcon.com/posts/post/translation-of-webcon-bps-portal-user-interface-content/102

Hi Fabian, interesting idea. I will remember this for another use case. :) I would have gone done another road. I would have tested to get the current/previous comments from the history and compare the string. SELECT [WFH_ID] ,[WFH_OrgID] ,[WFH_Description] , [WFH_Version]

I did it wrong. :) Config class public class Config: PluginConfiguration { [ConfigEditableTranslationsList(DisplayName ="Translatable texts")] public TranslatableTexts Translations { get; set; } } public class TranslatableTexts { [ConfigEditableTranslation(DefaultTran

Hi Nik, it seems, that only the first column is available in the for each query. One alternative would be to create a data source. Of course this could lead to a lot data sources which are only used ones. But I don't see an alternative right now. Maybe it will be improved in a later versi

Hi Fabian, I'm not aware of an official statement, but I noticed some time ago this config entry: SELECT [PRM_Name],[PRM_Value] FROM [BPS_Config].[dbo].[GlobalParameters] where PRM_Name = 'CloudComponents' There disabled components are listed. I'm not copying the value since I can only gu

Hi Stanisław, there's a function "Add Date" where you can choose to add a month and provide a negative value. If you need a text instead of the "date" you can use the "format date" function. Best regards, Daniel

The log entry is in table: [BPS_Config].[dbo].[AdminWFEventLogs] It seems that this attribute can note be used with version 2022.1.2.31. I've created a support ticket. I will update this thread, ones I have an answer to my question. Best regards, Daniel

Hi everyone, did someone use this attribute and has an sample how to set this up? I've probably used a wrong type for the property. Like it happens when one copy & pastes and changes the attribute name to Bool but the property is still string. :) Meanwhile I will search for the log table in

Hi Fabian, thanks for the update. So the reason was due to the character limitation. It's kind of obvious, after you found the reason. :) Best regards, Daniel

Hi Fabian, I wasn't aware of this limitation. Even so you are already live, I would opt for changing this to an item list, especially if this isn't the only case with so many selected items, which aren't even sorted alphabetically. My, untested, idea would be: 1. Add item list 2. Migrate th