Daniel Krüger (Cosmo Consult)

Hi Andreia, you can use this query to initialize the number of rows, where you can replace 3 with your field. SELEct TypeId as MonthNumber FROM [dbo].[DicFieldDetailTypes] where TypeID between '3' and 12 I would choose a multilingual picker field for the Months with the following sample q

Hi, you are almost there, choose the right information from your screenshot. :) In case someone using the Designer Studio version installed from the portal. The server name won't be displayed. It's only available if the Designer Studio communicates directly with the SQL Server and not via REST

Hi Darek, I don't have a suitable data at my end, so I will write this query without the option to test it. DET_ID can be used as the "unique value" to update the rows, and DictionaryEntryExists can be used for your column. Best regads, Daniel select DET_ID, case when Exists( select

Hi Darek, this would be easy, if you could do this check with a "wizard" step. Then you could either use: - Change item list values, to update all rows using a SQL query - Use the for each operator introduced with BPS 2022. With this you can select the item list and use the 'change value of si

Hi Ralf, you have a point there. I was focused on the fact that less experienced users will read this and may do something which cause undesired side effects. On the other hand, non experienced users won't be able to use the procedures. I'm wondering whether this would be possible with R3

It's there: WEBCON BPS 2022 R3 Introduced the ability to use Azure SQL Managed Instance as a database engine. Users can now select Azure SQL Managed Instance as a database server in the WEBCON BPS installer when configuring database connection parameters.

Hi Ralf, while I'm glad that an experienced partner joined the community I'm baffled by this suggestion. I'm currently on vacation so I can't check it but those procedures I had a look at, did exactly what the name implied. Insert/Update/Delete of an entry in the table. I assume it's the same

Hi Nik, I also would like to have a "Add new row with values" function but I haven't had the time yet to look for a solution. Regarding the initialize option. I'm using this in a similar situation. The source of an item list may be changed over time and the item list has to reflect these chan

Hi Denckert, there's not any difference in populating a drop down via a REST data source or any other. Once the REST data source is defined you are good to go. This is explained here: https://community.webcon.com/posts/post/rest-data-sources/173/27 Regarding logs, where does it fail? Does

Hi Raluca, sorry, I didn't read this correctly. We are running 2022.1.2.31 and we don't have any problems. So it's may be the best to create an official support ticket. Best regards, Daniel

Hi Andreia, did you use a statement similar to this? select null as Empty I'm not sure whether you can map the same column multiple times. If this is not possible, you can just number the columns. Best regards, Daniel

Hi Nik, this looks totally legit to me. I've used the same setup in multiple situations. The only problems I had were: - I had the workflow instance checked out while testing it. The timeout couldn't execute in this case - There was an issue with the actions on the path I could solve everyt

Hi, just one comment: This would hide the icon across all workflows. If you want to hide it on a single workflow you can use an html field/attribute with button#HistoryToolbarButton {display: none;} and display it in each step. I hope there's no typo in the above. :) Best regards

Hi Martin, we may be able to hide the download button at the bottom, but the other action bar comes from the installed tool which displays the content. Excel and probably Word documents are converted to pdf and your PDF reader renders it. Take a look at my screenshot, I have a completely differ

Hi Denckert, since this forum doesn't display the number of views of a thread, one doesn't know, if the thread was "ignored" or viewed but without somehow who could help. I for my part wasn't in the situation where I needed to connect to a BC SaaS environment. I had either the opportunity to u

Hi, if I understand it correctly the field should spend on the step the workflow moved to. I would accomplish this by using the OnEntry trigger of the step to change the filed value. This would be achieved by setting up the choce field to use an sql statement for providing the values us

Hi, based on the message I somehow doubt, that it is actually a problem with WEBCON BPS. Maybe it's a coincidence or it wasn't noticed, that there were issues before? Regardless, I would try to send a mail with the same settings using PowerShell from the server: https://docs.microsoft.com/e

Hi, while I would wise against using any kind of insert/update/delete statement against a BPS database, I also didn't find an alternative. In the SDK you only have the option to add read all existing comment and add a new one. There's no option to remove old ones, so there's no supported way.

Hi, I hope it's not to late. You can achieve this by storing the already selected ids in a (technical) field and adding a where condition, that these are not part of the data source. You can see in my attached screenshot, that 2,3 and 6 have been selected and when I wanted to select 2 again

Hi, this one is interesting. I played a around a lot and even so I created a long entry: @AdditionalMessage=N'Single value: The value of field "Picture" was set to "". The image wasn't deleted. But I was able to set other images with the 'Change single field value' action. So only the nul