Daniel Krüger (Cosmo Consult)

Hi Phil, these are just wild guesses. :) 1. You did change the address in the word addin? 2. Do the users have at least Metadata access privileges on application level? https://community.webcon.com/posts/post/webcon-bps-designer-studio-privileges/44 Best regards, Daniel

Hi Andreia, I should have checked my reply on the PC. There's no need for the brackets and outer select anyway. select TypeId as {DCNCOL:554}, '{ISO:3888}' as {DCNCOL:557} FROM [dbo].[DicFieldDetailTypes] where TypeID between {3887} and 12 This should bring you the same result. Best

Hi Andreia, your union would do the following: 1 2 3 4 Date But you want 1, 2022-02-02 2, 2022-02-02 So it should look similar to: select MonthNumber as {DCNCOL:554}, '{ISO:3888}' as {DCNCOL:557} from ( select TypeId as MonthNumber, null as Dates FROM [dbo].[DicFieldDetailTy

Hi Ingo, can you check whether the WEBCON BPS event log contains any other information? There's an own event log for WEBCON BPS. Maybe there are multiple entries. Is the search service running? Off topic: As far as I can tell the customer isn't listed as a reference so you should probabl

Hi everyone, have you ever imported a process and thought, damn I forgot to tick this or untick the other field? In my case this has happened more than I want to admit. Most times everything works fine but know and then you get disturbed and you make a mistake in the selection. Of course one

Hi, export/import is only available for processes of type "Dictionary" and "Document template" . The later one may be an option for this situation. Just because it's named "Document template" doesn't mean, that it has to be a template used in combination with Word or so. There's one alternat

Hi, it's may be to late for this question but it may help others. I've come around to test and write a post about "debugging" such situations. My example uses also Business Central with a picker field.. But I am using a user with a web service access key is used. I know it's deprecated, but t

Hi, if you simply want the number of days you can take a look at this thread: SUBTRACTION TWO DATES ON A FORM https://community.webcon.com/forum/thread/469 If you want to ignore weekends it will get a little trickier. Best regards, Daniel

Hi Andreia, this time you need to pick the value from values tab since you want to use the current value from the form and not some value saved in the database. At least is my assumption, since the database column is displayed. Best regards, Daniel

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