Issue with Data Disappearing in Custom Tab Grid after I hover the mouse over the grid header

Hi, ​@PraveenBeo 

I noticed in your code that you are not calling the base method in the RowPersisted event. Since SOOrder has overridden persist logic, it's better to include that.

Also, you are creating a new instance of SOOrderEntry, but you're already inside that graph, so there's no need to create it again. You can directly use the current graph to insert the data.

 var graph = PXGraph.CreateInstance<SOOrderEntry>();

That should help keep the grid data in sync with the UI.

Thanks!!!

Using the RowPersisted event is not a good place to do what you’re doing. Acumatica can handle this situation for you.

1. Add a foreign key type to SOOrder on your MyOrder DAC:

   public static class FK
   {
   	public class Order : SOOrder.PK.ForeignKeyOf<SOLine>.By<orderType, orderNbr> { }
   }

   (where orderType and orderNbr are the BQL property types of your MyOrder DAC)

2. Add a PXParent attribute to *one* (not both!) of your MyOrder DAC key fields:

   [PXParent(typeof(FK.Order))]

3. Then add [PXDBDefault] to the foreign keys of your MyOrder DAC. Acumatica will set these values when they become available:
   [PXDBDefault(typeof(SOOrder.orderType))] for OrderType
   [PXDBDefault(typeof(SOOrder.orderNbr))] for OrderNbr

​@Saikrishna V  

protected void _(Events.RowPersisted<SOOrder> e)
     {
         SOOrder row = (SOOrder)e.Row;
         if (row == null) return;

         if (e.TranStatus.ToString() == "Completed")
         {
             var myorder = new MyOrder
             {
                 Ordertype = row.OrderType,
                 OrderNr = row.OrderNbr,
                 Description = "Hardcoded Test Data"
             };
             Base.Caches<MyOrder>().Insert(myorder);
             Base.Actions.PressSave();
         }
} Changed Like this. But it will make an Infinite loop because of the   Base.Actions.PressSave(); If we remove Base.Actions.PressSave(); It does not work . Thank you for your time .

​@PraveenBeo 

As per ​@darylbowman  suggestion, you can try setting up the PXParent child relationship for your custom grid tab. This approach should help prevent the data from being wiped out by properly establishing the parent-child link between your custom DAC and the SOOrder.

Thanks

​@darylbowman  

  #region OrderNr
  [PXDBString(50, InputMask = "")]
  [PXUIField(DisplayName = "Order Nr")]
      [PXDBDefault(typeof(SOOrder.orderNbr))]
      [PXParent(typeof(SelectFrom<SOOrder>.
  Where<SOOrder.orderNbr.
  IsEqual<MyOrder.orderNr.FromCurrent>>))]
      public virtual string OrderNr { get; set; }
  public abstract class orderNr : PX.Data.BQL.BqlString.Field<orderNr> { }
  #endregion

I have already given the PXParent attribute for OrderNr. as shown above . If RowPersisted is not a good place , can you please suggest a suitable event from where can I call my api and update child DAC as per the result from api .  Thank you for your time 

​@PraveenBeo 

As far as I know, you should consider using the RowUpdated or RowInserted events.
For the [PXParent] attribute, make sure to include both OrderType and OrderNbr. Here's a sample:

[PXParent(typeof(Select<SOOrder, Where<SOOrder.orderType, Equal<Current<orderType>>, And<SOOrder.orderNbr, Equal<Current<orderNr>>>>>))]

​@Saikrishna V For make it simple I removed OrderType  from DAC . 

And moved to RowUpdated event .

public SelectFrom<MyOrder>
    .Where<MyOrder.orderNr.IsEqual<SOOrder.orderNbr.FromCurrent>>
    .View MYOrder;

protected void _(Events.RowUpdated<SOOrder> e)
{
     var row = e.Row;
     var myorder = new MyOrder
     {
         Description = "Hardcoded Test Data"
     };
 
     MYOrder.Insert(myorder);
     Base.Document.View.RequestRefresh();
     MYOrder.View.RequestRefresh();
} 

On save The orderNr is correctly inserted in database (I think the PXParent works) and data is shown in the grid inside the tab. But still on mouse over to the grid header the grid become empty .

The grid is shown correctly after save . But on mouse over to grid header shown below . Thank you for your time and effort