Paweł Tołoczko

In other place I needed to add your suggestion "N" and it works ... In other place I found I need that as business rule where I check if user have BPS account or not (in item list). [CODE=SQL] SELECT COS_DisplayName AS 'Podwładny', COS_ManagerDisplayName AS 'Manager', COS_ID AS

IF will be no "space bar" then Webcon in template (doc) will ignore "check box" present in template. when we add space bar then expected "check box" will appear .

ChatGPT generated sql code: [CODE=SQL] SELECT T2.DET_ID AS 'Id wiersza elementu', T2.DET_WFDID AS 'ID elementu', T2.DET_WFCONID AS 'ID listy pozycji', T2.{DCNCOL:1188} AS 'Wymaganie / Norma (filtr)', T2.{DCNCOL:1190} AS 'Punkt Pytania (filtr)', T1.{DCNCOL:1166} AS '

Akcja "Wyczyść listę pozycji (1420)" niedostępna w obecnym kontekście wykonania Action "Clear Item List (1420)" not available in current execution context OK, if I do in 2nd automation (any action related with Item list then I have error related with "current execution context" what the h**k t

-- edit --- OK, I see in webcon 2024 there is a problem with local variables (in my scenario) I skipped assign to variable and I put value direct to automation input .. and I have new error .... [now just 1 line ... I see progress (irony) "Akcja "Zastąp wartości listy pozycji (1415)" niedos

--update--- I found place with error I have action for each from item list and then: I save Column category "Kategoria" to 1st. local Variable (text) I save Column category "Punkt" to 2nd local Variable (text) and then I use 2 variables in another automation as input where I filter source

in webcon 2022.1.4.404 - automation with action start sub flow was working in webcon 2024.1.1.130 - is not working ... I have error: Komunikat błędu akcji podobiegu Nazwa automatyzacji: >> [podobieg] Start Ankiety (ID: 890) Nazwa akcji: Uruchom podobieg Audytowani (ID: 1351) Proces st

Thank you (All) for help and direction I checked on 2 versions of Webcon 2022.1.4.404 and 2024.1.1.130 in bout it doesn't work ... so it is: a) SQL / Webcon language/coding configuration on my site (my IT case) b) no one is compares Text vs. text in webcon ;-) .. all use ID vs. ID ;-p b)

Thx, I did another analyses and I had few column mismatch (not used - just displayed) - I fixed that.

screen

I genereted SQL (chat GPT) SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL:1135} AS 'Sygnatura Audytu', d.{DCNCOL:1132} AS 'Tytuł raportu 8D', LEN(d.{DCNCOL:1132}) AS 'Długość Tytułu z listy pozycji', LEN('{3205}') AS 'Długość tekstu do porównania', d.{DCNCOL:1132}

[Webcon 2024.1.1.130] (i thin it was working in 2022.1.4.404 - but I need double check] I have action to update item list where source is Parent Item list. The sql query is working but filters .. works if there is no polish letters :| so: [code='SQL'] SELECT d.DET_WFDID AS 'ID el

Thank you, I was worried it is not possible :/ because any webcon help (file) did not describe it. At the moment I will stay with (group visibility) and maybe later move to tech attachment process ...

[Webcon 2022.1.4.404] I Have Process A [Main] where I start sub-processes B [child] from process B I copy attachments to process A by: Daniel's solution https://daniels-notes.de/posts/2023/copy-attachment-to-other-workflow and put them to Item list A or Item list B as linked attachments (o

Works great Thank you.

I try to find option to trigger refresh button in "data table" . OK I can click arrow .. but I would like to refresh to have no data ... So I have form rule when some field value is changed (deleted) then is clearing fields but not reloading whole form ... so because data is not saved or the fu

I did - result = zero ... I removed "AND a.DET_IsDeleted = 0 -- Optionally, to skip deleted rows" thank you.

Hi, thank you for help and direction. I don't know why, but "STRING_SPLIT" is not working ... (did not recognize function ect. .. with declare I have got the same problem ... - maybe not set proper rights in database .. I don't know) but dbo.SplitToTable works :D any way in my scenario

I have got Item list with 2 columns 1. Category (A) 2. Points (B) Column A and B use dictionary process where if is set A then filter B to A value and in column (A) I can pick Value then >> in column (B) points I can pick more than 1 value . so I can have: (A) >> (B) A >> a,b,c,z B >> a,

The error "409" Appears only if element where you want to copy Attachment is in Edit mode - if you cancel edit mode then error is not appearing :D and all works fine :D