latest posts

Hi everyone,

maybe someone has a good idea for this request.

One application will be migrated from WEBCON to another platform. The users should still be able to view the data but they shouldn't be able to modify it.

While this isn't a problem the process privilege level, the users didn't work correctly with the system and now have hundreds of open tasks. Which in turn means, the users with those tasks have also a personal edit privilege.

I haven't come up with a good way how to solve this. These are the options I thought about:
- Modify the privileges in the database directly
- Change the field field matrix to read only for all processes in the application
- Create a path enable quick path and reassign the tasks to service user.
- Unassign the licenses from the users

I want to refrain modifying the database directly and editing the process. I also can't unassign the licenses because it a perpetual license.

Does someone have a good idea for this request?

Best regards,
Daniel

Hi,

You can use the "Change values ​​of multiple fields" action using the same data source you used in the autocomplete file (and specify the fields you want to complete).

https://docs.webcon.com/docs/2025R1/Studio/Action/Form/Action_ChangeManyValues

How can i fill target fields of an autocomplete field when setting the autocomplete via an Action?
There is an action where i fill an autocomplete field via an action however the target fields are not automatically filled with it.
I would prefer if i do not have to fill them individually.

Hi Franz,

if you use the SQL query in the Merge Attachments action you are free to select whatever attachments you want.

https://docs.webcon.com/docs/2025R1/Studio/Action/Attachments/Action_MergeAttachments#4-sql-query

I haven't checked the latest 2025 Version but in the 2026 R1 version the issue is fixed, that the order of the SQL query has been ignored during the merge process.,

If you want to save the files from the database on a hard drive, I would use PowerShell. This would be a part of the solution

___
The query to get all relevant files and their length
___

___
Iterating over the result set
___
$fileLength = $row.FileLength

$fileContentQuery = @"
SELECT TOP 1 ATF_Value
FROM [$AttachmentDatabaseName].[dbo].[WFAttachmentFiles]
WHERE ATF_ATTID = $attId
ORDER BY ATF_Version DESC
"@

$fileContentResult = Invoke-Sqlcmd -ConnectionString $ConnectionString -Query $fileContentQuery -MaxBinaryLength $fileLength
$fileContent = $fileContentResult.ATF_Value
____
Define the file path / name
____
[System.IO.File]::WriteAllBytes($filePath, $fileContent)

Dear Franz,
could you please confirm whether you’d like to download / save all attachments returned by your SQL query as the original files?
If that’s the case, this article by Kamil Nędza might help you build a query that saves attachments directly to a specified path:
https://alterpaths.com/attachments-export-from-the-webcon-bps-database/

Hope this helps.

Hi,
is it possible, to use the action 'mergeattachment' not only for attachments in ONE form but also in DIFFERENT forms?

If not, is it possible via sql?
In the attached picture there is a screenshot of the following sql-query of the webcon-database:

select ATF_WFDID, ATF_OrginalName, ATF_OrginalValueHash from dbo.WFAttachmentFiles
where ATF_WFDID > 9620

how can I export the word-docs as real word-docs to the filesystem of the server?

Greetings
Franz Mayer

Thx Jacek, works fine, I created a menu button with a change value

Hi,
You can try copying this field not from the URL parameters, but, for example, using the "Change value" action on the element's save path.
You would have to pass the WFD_ID of the source element to the technical field and then use SQL to retrieve the image in the action.

However, this has the disadvantage that it will only be visible after the element is saved (of course, you can also pass the path to the element in the URL and save the element immediately).

Hi,

i use the "Hyperlink"-actiontype for copying some values of a filled form to a new form (see attachment). That works very fine.
But if I add a picture form field, the copy process failed with a message "HTTP Error 414. The request URL is too long"
Is there any other possibility to copy a picture from a filled form to another new form?

Thanks for reply

Franz Mayer

Thanks to you also, i will test you're solution. Have a great weekend. :)