Populate grid from another grid using foreach loop

Hi @jeffgrammer69 

Can you clarify what do you mean by one at a time? It is because each current Relation is copied into the custom grid (current one)? or you do a ForEach loop to copy the records doing Insert / Update validating if it exists or no?

Normally you have to deal with cache one record (DAC) at a time inserting or updating the cache.

Are you expecting something similar to SLECT … INTO like in SQL, kind of behavior?

I would have this in a function if you want an action to copy the grid

// This is a draft pattern that requires some adjustments
foreach (CRRelation item in items)
{   
    ARInvoice inv = ARInvoiceView.Search<ARInvoice.noteID>(item.TargetNoteID);
    if(inv != null)
    {
        ARInvoiceView.Current = inv;

        // Modify Inv with any update

        ARInvoice.Update(inv);
    }
    else
    {
        inv = ARInvoiceView.Insert(new ARInvoice { key fields })
        ARInvoiceView.Current = inv;

        // Set your object

        ARInvoice.Insert(inv);

    }
}
...
Base.Actions.PressSave();  // Please the real header object

...

@Leonardo Justiniano 
I realized I might need to clarify a little further.

In SQL code terms.  Below is exactly what I am trying to do inside of Acumatica and put the results into the “CAM Document Info” tab.  I do *not* want to save or store the results, only display them.
Does this make it more clear?

SELECT 
       ARInvoice.[RefNbr]
      ,ARInvoice.[DocType]
      ,ARInvoice.[CuryLineTotal]
      ,ARInvoice.[CuryTaxTotal]
      ,ARInvoice.[InvoiceNbr]
      ,ARRegister.[DocDate]
      ,ARRegister.[DueDate]
  FROM [dbo].[CRCase] CRCase
  OUTER APPLY (
     SELECT 
          [TargetNoteID],
          [DocNoteID],
          [RefNoteID]
     FROM [dbo].[CRRelation]
     WHERE [dbo].[CRRelation].[CompanyID] = 2
     AND [dbo].[CRRelation].[RefNoteID] = CRCase.[NoteID]
  ) CRRelation
    OUTER APPLY (
    SELECT
         [RefNbr],
         [DocDate],
         [DueDate],
         [NoteID]
    FROM [dbo].[ARRegister]
    WHERE [dbo].[ARRegister].[CompanyID] = 2
    AND [dbo].[ARRegister].[NoteID] = CRRelation.[TargetNoteID]
  ) ARRegister
  OUTER APPLY (
    SELECT
         [RefNbr],
         [DocType],
         [CuryLineTotal],
         [CuryTaxTotal],
         [InvoiceNbr]
    FROM [dbo].[ARInvoice]
    WHERE [dbo].[ARInvoice].[CompanyID] = 2
    AND [dbo].[ARInvoice].[RefNbr] = ARRegister.[RefNbr]
  ) ARInvoice
  WHERE CRCase.[CompanyID] = 2
  AND CRCase.[CaseCD] = '000161'

@jeffgrammer69  Can you please share the customization package for our review?

This is what @Django is talking about:

using PX.Data.BQL.Fluent;

// Data view
public SelectFrom<ARInvoice> CAMRelationsView;

// Data view delegate (where things can get really freaky)
public IEnumerable camRelationsView()
{
	var relations = new List<ARInvoice>();

	var items = Base.Relations.Select().FirstTableItems.ToList();

	foreach (CRRelation item in items)
	{
		ARInvoice relatedInvoice = SelectFrom<ARInvoice>.Where<ARInvoice.noteID.IsEqual<@P.AsGuid>>.Select(Base, item.TargetNoteID);
		relations.Add(relatedInvoice);
	}

	return relations;
}

@Naveen Boga 
Please forgive me for taking so long to respond.  I was traveling over the weekend.

Attached is the full customization package.  Note that I even have tried using AutoCall back on the screen grid to see if that worked.  It does not for fully populating the CAM Info grid.

Thank you,

@darylbowman 

AH!  Thank you.  These are the things I do not know about Acumatica coding.  
 

Well, that took me a bit closer.  Now it is failing with the following error on the SelectFromBase statement. 

I am sneaking up on it. 😀

\App_RuntimeCode\CRCaseMaint.cs(81): error CS0117: 'SelectFromBase<ARInvoice, TypeArrayOf<IFbqlJoin>.Empty>.Where<BqlOperand<ARInvoice.noteID, IBqlGuid>.IsEqual<P.AsGuid>>' does not contain a definition for 'Select'
\App_RuntimeCode\CRCaseMaint.cs(73): error CS0161: 'CRCaseMaint_Extension.camRelationsView()': not all code paths return a value
\App_RuntimeCode\CRCaseMaint.cs(81): error CS0117: 'SelectFromBase<ARInvoice, TypeArrayOf<IFbqlJoin>.Empty>.Where<BqlOperand<ARInvoice.noteID, IBqlGuid>.IsEqual<P.AsGuid>>' does not contain a definition for 'Select'

@darylbowman 

Thank you!  I will test this out.  I figured I had ‘kicked’ the code when I typed it in.  I try not to do “copy and paste” so that I can learn not simply logic, but syntax also.  So thank you again for your patience and help.

It did compile now; and will post back shortly what it does.

Sorry, I missed one more piece. This is the benefit of looking at the whole project in Visual Studio 😒

Replace the data view with this:

public SelectFrom<ARInvoice>.View CAMRelationsView;

Fantastic!

Yes, it should, as it is duplicating exactly what is shown in that view. Since it is using the same underlying record type (ARInvoice), this is relatively simple to do.