WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

Daniel Krüger (Cosmo Consult)

MVP

SQL report
18.01.2024 21:46

Hi, I'm sorry, but I don't grasp what you are asking. You can only display the columns/attribute selected in the column tabs. In the views you can define, which of these selected columns would be available. I don't see any relation to the filter. Maye reading through this post will hel

Hi Marco, we aren't using it and unfortunately I don't have time to check this out on my own. Maybe you can check out this approach. https://raluca.encorsa.ro/?p=107 The blog post mentions this project, check out the readme as there may be other options. https://github.com/Fody/Costura

Document viewer
18.01.2024 09:06

Hi Maria, the problem here is, that SharePoint Online doesn't allow to be hosted /embedded on all websites (domains). These need to be whitelisted. It won't make a difference how the iFrame would be added. By the way, the same applies to WEBCON BPS too. While I know that you can set these usi

Upload to Sharepoint Graph
17.01.2024 21:43

Hi, how is the Authentication tab configured? Is there any authentication setup or is this anonymous? If it's not this may cause the conflict as you are also defining an authentication header. Btw. have there been other issues, because you asked something similar in the past but using the Sh

Hi Nik, I don't know the use case, but it sounds strange. The only reason I can imagine you are using GUIDs is, that you are displaying the form in an iFrame and are passing the GUIDs via a message to the form. :) Nevertheless, I would use an HTML field in which a business rule returns a map

Document viewer
17.01.2024 21:31

Hi Maria, SharePoint only If these documents can be displayed in SharePoint for example Word documents, I would check the URL and see whether you could use this URL as the source of an iFrame. If this is possible, there may be security restrictions and I have no idea, whether you can change the

Hi Klaus, my first ideas have been to always update the old value with the current one. This doesn't work if the field doesn't change but the workflow instance is saved. At the moment I have two idea: 1. Requires JavaScript The "Change" rule will execute a JavaScript rule, which retrieves

Hi George, I put together my notes, when we updated from a 2022 version to 2023. This will be a good starting point. https://daniels-notes.de/posts/2023/updating-to-bps-2023 Best regards, Daniel

Hi Karol, this probably won't be realized as there's a more powerful option planned for BPS 2024. Best regards, Daniel

Hi Simon, I'm not sure whether you actually need the date diff function. Are you aware of the Timeout concept? https://docs.webcon.com/docs/2023R3/Studio/Workflow/Step/Actions/Action_Timeout/ One use case of these is to send "reminders" after x minutes/days/weeks. The only caveat is, tha

Portal Logged Users
10.01.2024 23:04

Hi, there's the report "Workflow Users" under license. This displays a last login date. https://docs.webcon.com/docs/2023R3/Studio/Reports/Reports_Licenses/Reports_WorkflowUsers I have no idea where this information is stored, but it must be there somewhere and I didn't have the time yet to

Hi, this is not possible. You could create a process which displays all applications, workflows and steps with empty descriptions or translations. Best regards, Daniel

Hi, as always when a new feature is provided, new requests will follow immediately. :) It would be great to see in the workflow history whether path authorization was used and which method was used. At the moment, it's not at all visible if path authorization was used at all. If the autho

Hi, it would be great to have the UTC time in a hover effect of a time. In the attached screenshot you see the same element but with different times. One browser is running on a server with a different time zone. Even so it's explain it can cause confusion. Therefore some way of displaying the

Hi, I really like the new path authorization feature and we will surely use it. The geolocation is also an interesting addition but if it's used in combination with the path authorization it will created unexpected results. I noticed that the geolocation of the browser is used, even if path au

Report restricition
08.01.2024 13:26

Hi, even so Maks already answered the question and I agree with him, that it should be done on the security level I have on other comment regarding filtering. If you want to have a fixed filter you can add this as an SQL filter. https://docs.webcon.com/docs/2023R3/Studio/Application/Pres

Item list rows limit
07.01.2024 20:59

Hi Kyle, even so you already have a solution you may want to look into this. I found this question quite interesting, and created a small post about hiding the "Add row" button when the limit of the item list rows is reached. https://daniels-notes.de/posts/2024/limit-number-of-item-list-rows

Hi, it would be nice if the view V_WFElements would not only contain the integer id but the GUID. I'm not sure whether using the view in a calculated column would be more performant or creating an own join, but only for one table. For example (select Count(*) from V_WfElements childs where

Hi Maciej, when you import the process the first time, than you can select which attachment database should be used. The default database, is suggested. If you haven't created any instance yet you can change the attachment database in the process. Maybe it's also possible to change it while the

Calculated column report
18.12.2023 20:34

Hi, whenever I have a problem with a calculated column, I activate the diagnostic mode, refresh the report and save the session. Afterwards I search vor wfelems. This is the query which is executed for the report. Then I would copy the query to management studio and look for the problem. T