Michal Ciesiolkiewicz

Hey, you can use js function which press buton when user close tab/window: window.addEventListener('beforeunload', function() { var button = document.querySelector('#EditToolbarButton'); if (button) { button.click(); } });

Hey, look for the article: https://kb.webcon.pl/zaawansowana-obsluga-podobiegow/ (in polish, i guess you are from Poland too ;) ) If information in this article is not enough for you - let us know :)

You can easily find info about changes and who and when changed the lock of enviromnent select CHD_ID AS [Change_Id] , CHD_CFCID [Changed_object_code] ,case when CHD_OldValue = 0 then 'Unblocked' when CHD_OldValue = 1 then 'Blocked' end as [Old_value] ,case when CHD_NewValue = 0 then 'Unblo

Hey, You can do it in two steps: 1. Add calculated column with query (case when DATEDIFF(DAY, GETDATE(), WFD_AttDateTime1)> 10 then 2 when DATEDIFF(DAY, GETDATE(), WFD_AttDateTime1) < 10 then 1 else 0 end) Of course, you can change values, columns name etc 2. Add rows formatting like on

Hej, this is query for you: select TSK_User, TSK_WFDID, TSK_WFHIDTaskFinished from ActiveTasks where tsk_WFDID = X Webcon adds information to HistoryTask once a job is completed by each user; however, this query returns details about the users who have completed their tasks, even if not all

So, are you looking for people who finished their tasks or not?

Hey Krystian, in your code, you need to determine the number of rows to send. Do you have any ideas on how to make your code independent of the number of rows in the item list?

I haven't used this action yet, but if you have enabled Active Directory connections in WEBCON, there are some actions available that might help you.

Your solution works in my case too, thanks :)

Did you try build your link with escape quotes?

Jeśli chodzi o samo czytanie - nie ma z tym problemu, ta treść zostanie przeczytana. Znajdziesz ją potem zapytaniem SELECT [ATF_ID] --ID elementu ,[ATF_WFDID] --id elementu gdzie występuje załącznik ,[ATF_ATTID] --id w tabeli [WFDataAttachmets] ,[ATF_FRData] --treść odczytana

You can try two methods: 1. As chatGPT wrote - change collation for Polish_CI_AI 2. Add 'N' letter before tour value - change collation too - " AND d.{DCNCOL:1132} = N'{3205}' "