Daniel Krüger (Cosmo Consult)

Hi Rastafin, I'm sorry for the misleading reply. I wanted to ask you, to print the file via Excel as pdf. If it looks similar to the generated WEBCON preview you could test to define a different page layout and see, whether the preview would use this too. Best regards, Daniel

Hi Radek, maybe you can use the form rule "Mark required" instead of the field matrix / requirdness definition on the field. The form rules aren't applied to the REST API while the others are. Best regards, Daniel

Hi ruthw, unfortunately I don't have a 2023.1.1.56 environment. We just updated to 2023.1.2.44. It works without issues. Nevertheless I would recommend to use the id instead of the name. Just in case it changes. For example when you need to add another language. We have also a fixed value li

Hi Rastafin, Can you check whether printing the excel as pdf would look similar? Best regards, Daniel

Hi Karol, hi Maks, I'm running on WEBCONAPPS, so SQL and PowerShell actions are not available. What I could do is a slight modification of Maks idea of the csv. Instead of a csv file I could use multiline text fields to store the concatenated values, of the DET_ID, and totals. Outside the

Hi Karol, you have understood it correctly. I would like to use the idea as this would allow me to use a "filtered foreach loop" using "any collection". In my case it's not an option. I don't have another database I can write to nor can I create one. Best regards, Daniel

Hi everyone, I'm wondering what would be the best approach for the following use case. There may be between 300 and 500 active claim workflow instances. The costs for these claims are tracked in the ERP system. The total of the costs needs to be in the claim, so that it can be used in reports.

Hi, in an Azure Active Directory environment it would be great to add an option to the people field which would configure it, whether external /guest users are selectable at all. Default value should be false. A customer worked around this by limiting the selection to a BPS group and addin

Hi ruthw, the error messages refers to a boolean value. So, it should be the if condition. You are comparing the field value to the text value „yes“. The value is written in cursive so the system interprets it as text. If your field is a Boolean field you can either omit the comparison or you u

Hi Paweł, regarding how to "convert" the comments to a data table, you can take a look here: https://daniels-notes.de/posts/2023/comments-to-data-table-and-pdf In my case I used them in an HTML to PDF template scenario but this shouldn't make any difference. Best regards, Daniel

Hi Maks, the most conform way would probably be to mark the boolean as archived and Update the data using a global cyclical action as suggested. This way you would see the translated value in the current version and the original ones in the history. Marking the field as archive will also preve

Hi Dariusz, yes that's right. The "bps_user" without a login exists only in one database and you "can't" access another database with it. Even if you would have the same user name in two databases it wouldn't work. When I researched this a bit I came to a blog that this would be possible by

Hi, the API endpoint returns a list of all processes inside a appliation. /api/data/v5.0/db/{dbId}/applications/{idguid}/processes It would be great, if the result would contain a property to check, whether a process in the result is only a relation. { "processes": [ { "id

Hi Dariusz, the bps_user is a user without a login. Therefore you can’t give him a password. Changing this would probably cause errors when WEBCON wants to use the user. I'm copying a related error message for this situation when the bps_user is used for something, where it has no sufficient

Sorry for misusing the thread but I don't have another option. @Maksymilian Do you have an LinkedIn account? I've seen your Facebook and Twitter icons, but I don't have either one. Best regards, Daniel

Hi Roman, comments: The query is passed as it is, -- and /**/ are part of it. Even so single line comments seldom cause problems, it happens. If you enable the diagnostic mode, you can search the trace for a line from your query and see the executed one. That's far easier than my previous app

Hi, @Radek I'm sorry too. After coming back from vacation there was just not enough time. If you still have the issue you could check the following: No match found for: Xxx Is probably for a choose field which value does not exist in your source or is not unique. @Maksymilian Congrats

I would be fine with an overview which WEBCON BPS versions support which compatibility level. Since SQL Server 2014 will be supported for one more year, I doubt that the default setting will be changed. After all not all customers use the latest version. Of course it would be nice, if the late

Hi Andree, I would either do it directly in Excel or add a check whenever an instance is saved/the save path is executed. The validate form action would be something like this: select case when (Select Count(*) from WFElements where WFD_DTYPEID = XYZ and WFD_ID CurrentInstanceId and W

Hi Damian, as Maksymilian already mentioned, as of some version WEBCON uses a dedicated database user without login 'bps_user'. It has has limited read permissions in the database. I have seen that this is only added to "new" installations not updates. Maybe your DEV server already existed a whil