Skip to main content
hamzas0003
May 7, 2025
Question

process goes infinte while looping a record

  • May 7, 2025
  • 3 replies
  • 0 views

I have created a process to loop through each row in a record, and for each row, I have defined a set of instructions to execute. However, I'm encountering an issue where the process enters an infinite loop.

In the "Get Script Task," I am using a simple query to retrieve data from a record. I attempted to save the query result in a multiple variable, hoping it would allow me to loop through the rows correctly, but it still results in an infinite loop.

the problem is im not able of retreiving a single value of a frild form the record , its concatenating all the values in the output  inside the variable ,and not one by one which cuases this infinte loop ,

and this what im passing for codice progetto : 

pv!ImprotPregressoPC['SC Import Pregresso PC.fields.codiceProgettoConnessione']

how can i make it retieve one by one every loop?

3 replies

stefanhelzle0001
May 7, 2025

I hope you are aware that processing larger volumes of data through a process is not a good idea.

OK. So your intention is, to fetch only a single item at a time. Did you check your query to do exactly that?

davidj137213
May 7, 2025

As Stehpan suggests, create an expression rule for testing your code.... 

May 22, 2025

Suggestion for  column selection by Stefan wither in PM or expression is something which always needs to considered and if you want to iterate over the fields try with "a!keys()",
after which you can index each row in a loop.


docs.appian.com/.../fnc_informational_a_keys.html