Home > Forum > Actions > Operator 'ForEach'

Operator 'ForEach'

0

02.06.2022

08:15

Hi all!

I personally think the operator 'ForEach' is a great addition to version 2022.1.2.31,
thanks to Webcon Team.

Unfortunately I do not find any documentation on that, especially how to iterate over 'Any Collection' and access columns in custom action.

If I select 'Any collection' and put some SQL statement in there, is there a way to access specific table columns from generated table result?

If I take a look at the configured XML I only see {ANYCOLLVALUE} macro.

Hope the question is clear enough,

Thanks in advance, Nik

02.06.2022

09:23

Hi Nik,

it seems, that only the first column is available in the for each query.

One alternative would be to create a data source. Of course this could lead to a lot data sources which are only used ones. But I don't see an alternative right now.

Maybe it will be improved in a later version. :)

Best regards,
Daniel

Solution (0)

Helpful (0)

Wrong answer (0)

02.06.2022

09:35

In reply to: Daniel Krüger (Cosmo Consult)

Hi Daniel!

Thanks a lot for the answer.

There is always room for improvement ;-)

I tried to use a datasource, and added some columns from this datasource to a custom action, which writes content to file and the result is empty, so I personally don't think the new feature has been finished.

Maybe Webcon Team could shed some light on this topic and clarify, if there will be some improvements / fixes on this new feature?

Best regards, Nik

Solution (0)

Helpful (0)

Wrong answer (0)