Daniel Krüger (Cosmo Consult)

Hi Martin, the server is running in Azure with local accounts and the users use Azure AD for authentication. Even so I wouldn't do it in other cases I modified the data in the SQL Database directly since I didn't found another option. Best regards, Daniel

Hi Martin, this fails, without a detailed error. There's just a little error icon besides BPS ID. After trying it in the browser, I could guess, that it's the same error. :) Best regards, Daniel

Hi Nik, there's this function: webcon.businessRules.subelementAddNewRow Unfortunately you can't populate the new row with the same call. You need to find the latest /unpopulated one. General hint with a little trap: If there's a form rule for this, you can also do it with JavaScript, just

Hi everyone, does someone has an idea, how I can add a mail address to a local user account? If I want to add one, I get an error, that the existing BPS Id does not match the UPN format. background information: a customer uses a single server machine for running a test environment for WEBCO

I'm currently sitting in the train travelling to Münster and the internet connection is like a sidescrolling game where you jump to evade obstacles. It's quite fast and every time you hit one, the internet connection is down. :) It's interesting that the business rule removes the html tags. I

Hi Martin, is this a normal text field or rich text? The value looks like a normal one. In this case you have two options. a) Add some css so that the line breaks are preserved inside the HTML mail. In most cases they are ignored. b) Replace the Character 10 and 13 with the HTML line break

Hi Martin, also Pawel already mentioned all mandatory steps, I have one optional. Optional fourth step: Check any constants if the contain links /URLs or entity ids, like a database id. At least in my environment I have a few of those constants. :) Best regards, Daniel

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