Home > Forum > General > [solved] Item list action after update from 2022 to 2024 stops working [1st Item list as filter for source to fill 2nd item list by automation]

[solved] Item list action after update from 2022 to 2024 stops working [1st Item list as filter for source to fill 2nd item list by automation]
0

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 startujący: Ankieta po Audytowa
Wiadomość: System.NullReferenceException: Object reference not set to an instance of an object.
at WebCon.WorkFlow.BusinessLogic.Automations.Engine.AutomationEngine.RunErrorFlowCollectionAsync(AutomationEvaluationParameters parameters, AutomationWithParameters automation, AutomationRuntimeResult currentFlowResult, CancellationToken cancellationToken)
at WebCon.WorkFlow.BusinessLogic.Automations.Engine.AutomationEngine.RunAutomationWithoutResultCleanAsync(IAutomationWithExecutionContext automation, AutomationEvaluationParameters parameters, CancellationToken cancellationToken)
at WebCon.WorkFlow.BusinessLogic.Automations.Engine.Evaluators.AutomationEvaluator.EvaluateAsync(CancellationToken cancellationToken)

--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 by variable.

I did save to text attribute in form to see what is put as input to next automation ....

I don't know why in 2024 is not working .. in 2022 was working :/

In reply to: Paweł Tołoczko

--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 by variable.

I did save to text attribute in form to see what is put as input to next automation ....

I don't know why in 2024 is not working .. in 2022 was working :/

-- 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)" niedostępna w obecnym kontekście wykonania "
"Action "Change item list value (1415)" not available in current execution context"

In reply to: Paweł Tołoczko

-- 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)" niedostępna w obecnym kontekście wykonania "
"Action "Change item list value (1415)" not available in current execution context"

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 that means ?

I check change attribute - works .. but only issue is item list ....
- I changed right from (java) to edit .. no change ...

--edit ---

all action I have on path .. should I move them on enter ? - checked the same problem ... I don't know why I can't do any action on Item list .

--edit --
I was checking the proper data enters sub automation .. yes data is directed .. but item list is not "moving" , if filter is empty - still no progress.

In reply to: Paweł Tołoczko

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 that means ?

I check change attribute - works .. but only issue is item list ....
- I changed right from (java) to edit .. no change ...

--edit ---

all action I have on path .. should I move them on enter ? - checked the same problem ... I don't know why I can't do any action on Item list .

--edit --
I was checking the proper data enters sub automation .. yes data is directed .. but item list is not "moving" , if filter is empty - still no progress.

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 'Pytanie'
FROM WFElementDetails T1
INNER JOIN WFElementDetails T2
ON T1.{DCNCOL:1165} = T2.{DCNCOL:1188}
AND T1.{DCNCOL:1164} = T2.{DCNCOL:1190}
WHERE
T1.DET_WFCONID = {WFCON:3730} -- "Słownik"
AND T2.DET_WFCONID = {WFCON:3762} -- "Źródło danych"
AND T2.DET_WFDID = {WFD_ID}
[/CODE]

on first test is working ... but
I need to check is gona work on patch action where I update "flter" item list and other item lists ...
...

I'm internally wondering webcon low code/no code in my scenario went into code ... :|

MVP
In reply to: Paweł Tołoczko

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 'Pytanie'
FROM WFElementDetails T1
INNER JOIN WFElementDetails T2
ON T1.{DCNCOL:1165} = T2.{DCNCOL:1188}
AND T1.{DCNCOL:1164} = T2.{DCNCOL:1190}
WHERE
T1.DET_WFCONID = {WFCON:3730} -- "Słownik"
AND T2.DET_WFCONID = {WFCON:3762} -- "Źródło danych"
AND T2.DET_WFDID = {WFD_ID}
[/CODE]

on first test is working ... but
I need to check is gona work on patch action where I update "flter" item list and other item lists ...
...

I'm internally wondering webcon low code/no code in my scenario went into code ... :|

Hi Paweł,

it's great that you found a solution yourself and that you updated the post with your findings. Maybe it will help others.

I also often wonder whether SQL is low code or not.
If a low-code tool would require drag& drop than the way we are creating the SQL statement is not strictly low -code
At the same time SQL is a "fourth" level programming language, which "hides" a lot of the complexity which of "lower" level programming languages.

So you could argue that it is "low code". :)

Regardless, without the flexibility of defining SQL statements, WEBCON wouldn't be what it is. :)

Best regards,
Daniel