Multiple iterators and the cache

Question

I have a customization that will travel through the lines of a sales order.

There could be two groups of SOLine records that I need to process on the same SO.

I have one main var to look at the SOLine records:

var lines = SelectFrom<SOLine>.
            Where<SOLine.orderType.IsEqual<SOOrder.orderType.FromCurrent>
            .And<SOLine.orderNbr.IsEqual<SOOrder.orderNbr.FromCurrent>>>.
            View.Select(soOrderEntry);

Then I’m using:

foreach(SOLine line in lines)
{
   //A bunch of code here
}

If I need another iterator to go through SOLine records on the same SO within the foreach loop and write (can I have multiple iterators on the same PXSelect?):

foreach(SOLine lineTwo in lines)
{
   //A bunch of code here
}

If I update lineTwo with:

soOrderEntry.Transactions.Update(lineTwo);

Will that update the proper record or will having multiple variables confuse the cache?

icon

Best answer by Naveen Boga 24 August 2022, 07:23

View original

Naveen Boga · Accepted Answer

Hi @ddunn I don’t think two foreach loops are required.

You can use the single foreach loop with your logic like below and update the cache.

foreach(SOLine line in lines)

{

// execute the first logic and assign the respective values to the line object

Eg: line.CuryUnitPrice =100;

line.Qty = 2;

//execute the second logic and assign the values to the line object

Eg: line. CuryDiscAmt =10

//Finally you update the cache, which will update both logic values.

SOGraph.Transactions.cache.update(line);

}

Multiple iterators and the cache

1 reply

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded