Daniel Krüger (Cosmo Consult)

This is just an information: WHERE DATEPART(dw,DateData) NOT IN (1,7) The numbers of Sunday (1) and Saturday (7) may be different depending on the localization: https://learn.microsoft.com/en-us/sql/t-sql/functions/datefirst-transact-sql?view=sql-server-ver16 Always make sure, whether they

Hi Krystian, I'm not sure that I understand what you mean with "single table". 1. Should the data of the existing tables be merged into a single table but there should be one table in each database.? 2. Should the five tables be left as they are but there shouldn't be duplicates in the other

Now it is even more interesting. It seems, that the transaction was still running and that's the reason why I didn't see the workflow instances. Neither in the Portal nor in SQL Server Management studio. I didn't think of making a dirty read. I checked this morning and now they show up. It just

Hi Karol, I have thought about it and also making the action asynchronous. It should work in theory but I'm having second thoughts about it because of a theoretical problem. If the synchronization doesn't finish before the workflow instance is updated again, the user may get added twice to the B

Digging deeper: The parent workflow was executed at 15:29 UTC (17:29) (1) I joined the LOG_WFDID column with the WFElements table. While the LOG_WFDID column has a value the WFD_ID column is null and new log entries are created for "new workflow" at this moment. (2) This is really strange.

Something interestingly happened. I wanted to create a few hundred BPS groups to test something unrelated to this topic. I already had a process for creating the groups and assigning the users. I wanted to utilize it by creating another process with an item list, populate this via excel, and

Hi. adding users to groups causes an update of the user properties which downloads objects from Azure AD. Depending on the environment it can take quite a long time. - (7/2/2024 2:33:46 PM) Step started: Download selected objects from Azure AD if required - (7/2/2024 2:35:44 PM) Step com

I overlooked something. The action triggers the synchronization of the group and afterwards the synchronization of the added user. This started a download from Azure AD which causes the delay. - (7/2/2024 2:33:46 PM) Step started: Download selected objects from Azure AD if required - (7/2/202

Hi everyone, maybe someone of you has a guess what we can do. - We have an environment with 6 content databases - We have a process which manages the members of a BPS group. - We use the Add/Remove single user to BPS groups to add a single user in synchronous mode (1) - Even so the action t

Hi Jack, I noticed that I didn't communicate my thoughts well. I'm using your example: 1. choice at the first step 2. step two - after entering (no change or error) 3. Go to step three 4. Error because the selected value from step one is no longer part of the source. At least this is

Hi Joanna, I doubt that it will be the case in this case, but if the field are editable in the other steps the source needs to return the selected values, otherwise you will get an error. Best regards, Daniel

Hi, even so this is solved I wanted to add two comments: SaaS You don't have privileges to modify the database. The action for executing SQL or PowerShell are not available. Adding functions views to the database This is something you do at your own discretion and sometimes it's necessa

That's for sure. :)

A neat little trick for this: Copy the output to Notepad++ and use the "Remove empty lines" action. :)

Hi, It's great to see, that other's are using the same approach. Even so it's only a minor addition, but we added also a business rule to simplify this even more. For example we are using this, in the insert condition of a timeout. We have different timeouts depending on the environment. :)

Maybe it will be there in BPS 2024. At least it is in the backlog. :) https://community.webcon.com/forum/thread/4134?messageid=4134

Hi, I would like to add the following: I'm assuming that the "Privileges" and "Timeout execution statistics" actions don't change the workflow instance itself. It would be great to have these available in view mode. Especially during testing it happens, that the workflow instance is checked ou

Hi, as Karol mentioned, the data for one dictionary entry is limited by the columns. Here's also a post about this: https://community.webcon.com/posts/post/limiting-the-number-of-form-fields/70/3 There's no software limit regarding the number of entries (workflow instances). There may be phys

Hi Richard, is this an old environment? I haven't seen this format as a default settings since years. Unfortunately I don't have an environment with which I can fiddle, but there is a setting in the GlobalParameters table of the config or content database which defines this. I forgot the name

Hi Paweł, you can update a local or related attachment column by setting the ID of the attachment. Local are attachments which are limited to the attachments of the current workflow, while you can choose the source of the related attachment in the configuration of the column. I have to admit