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

Daniel Krüger (Cosmo Consult)

MVP

Hi Ahmed, it's interesting to know that business rules are executed/replaced in a calculated column. This is probably an unsupported feature, at least I have never read anything about it. :) Did you already test, whether the id is replaced when you transport the application to another environm

XML
04.09.2024 08:04

Hi Mario, if you don't have an attachment database, you can simply use your content database. If you execute your statement in SQL management studio, I would guess that it is working. You are probably receiving an error, because you use "Current connection". This uses the "bps_user" which, in my

Hi, when you want to add a new new report tile with a link to the "details" in WEBCON BPS 2024 you have to: 1) Choose a data source 2) Choose an existing report The current implementation forces us to create the data source twice. While the effort for the data source creation may be neglect

Hi Ahmed, how does it solve your problem? - Did you find a variable for the language code? - Do you have different reports/views for different languages? - Is the report not available and linked somewhere and you are passing the language as a URL parameter? Best regards, Daniel

Hi Igor, from which part of the application did you have taken the screenshot? Is this the insert condition of the timeout or somewhere in the automation? If this task is assigned to a single person, I think that you could make your life a lot easier. A task will only be completed if a p

XML
03.09.2024 17:18

Hi Mario, yes, your idea can work. - You can extract the text from a plain text file and store it in a field and maybe in an automation parameter: https://daniels-notes.de/posts/2024/importing-applications-using-an-application#business-rules - You can then use "for xml" in an sql command http

We have a similar setup. The reason for this is not that they are large projects but we have regulatory "requirements": - Development Breaking and fixing stuff :) - Informal test We can easily deploy changes from dev here - Formal test / Validation: Deployment and tests needs to be documented

Hi Ahmed, the only solution I see is to save the value in a standard choose field which is marked as technical. We can not use a calculated column as we don't have the user language. At least there's no official documentation. Best regards, Daniel

Hi, at the moment the column "ElementName" is used as a category /subfolder while the column "Category" is used to display the filename. select Top 3 ATT_ID , ATT_FileType as ElementName , ATT_Name as Category I'm not using these option very often but each time I'm looking at the name

Hi Klaus, you are right, an element is checked out, when it is opened in edit mode. Similar to the document checkout in SharePoint. If you cancel the editing the checkout will be revoked immediately. If you only close the tab or navigate somewhere else the checkout will remain a while. The syste

Hi Maks and Jack already described where you can set it. I just want to point out, that this is part of the official developer documentation https://developer.webcon.com/docs/registration-and-authentiaction https://developer.webcon.com/docs/scopes-and-permissions https://developer.webcon.com

What is "Att_isSecret" ?
29.08.2024 21:38

Hi Mihai, I also noticed this field in the last days, but I have no idea, how it is utilized. The database documentation doesn't contain much information either: https://developer.webcon.com/2023/resources/db/?PageSpeed=off Is DataAttachmet secret I would assume that this is for inter

Hi, In the screenshot you passed the client id "Bearer GUID". You need to fetch an auth token first and then you can use this as the value for authorization. Here are a few locations where you can find more information: The developer page would be the first place to go: https://develop

Hi, besides the swagger site there's the developer site with an example on how to start an instance. https://developer.webcon.com/docs/basic-operations I can also recommend this PowerShell module, I use it a lot to read /write data to Excel. It's really great because it doesn't use Excel. ht

Vertreter-Funktion
27.08.2024 10:08

Hi Lina, wenn die Konfiguration gleich ist könnte noch die Vertretung generell deaktiviert sein. Das kann ich mir aber nicht wirklich vorstellen. https://docs.webcon.com/docs/2024R1/Studio/SystemSettings/GlobalParams/#substitutions-enabled Was hat der Screenshot zu bedeuten? Die Abfrage kom

Last comment on reports
26.08.2024 22:50

Just in case someone is finding this post via the search, here's an option to display those without updating to 2024. https://daniels-notes.de/posts/2024/show-comment-in-reports

Delete rows
26.08.2024 20:35

Hi Andreia, in your case I would use this sql statement: select DET_ID from WFElementDetails where DET_WFFID = {WFD_ID} and DET_WFCONID = ItemListId -- Condition to define which rows should be deleted. and FIELDDatabaseName > 0 If you use the DET_ID for the unique value, all rows wil

That's a question I've yet to answer for myself. Which kind of "code" is SQL. Most of the time it is "low code" for me but not "no code". :) There's also the option to use the "Advanced search", where you could return the WFD_ID of the latest workflow instance. Best regards, Daniel

Delete rows
24.08.2024 10:37

Hi Andreia, which version are you using? Depending on the answer the SDK will either not work and may be obsolete anyway. With 2023 R1 or R2 an option was provided in the update item list action to remove rows. https://webcon.com/docs/2024R1/Studio/Action/Form/Action_UpdateItemListValues

I don't mind where, but I ___need___ the raw value. :)