Can we get record counting at processing pages?

Hi @NikaKakhetelidze  Pages/Number of Records count will be shown in the native Acumatica.

For the Processing page, can you try like below and verify.

https://asiablog.acumatica.com/2018/07/page-number-on-acumatica-grid.html 

Hey thanks

protected virtual IEnumerable oRders()
        {
            if (PXView.RetrieveTotalRowCount)
            {
                yield return new PXResult<SOShipmentFilter>(null)
                {
                    RowCount = 
                };
            }
        }

How will this code work out?

Hi @NikaKakhetelidze  Pages/Number of Records count will be shown in the native Acumatica.

For the Processing page, can you try like below and verify.

https://asiablog.acumatica.com/2018/07/page-number-on-acumatica-grid.html 

 

 

Naveen,
That article seems to refer mainly to page count. Any idea how to get the actual record count taking into account the UI filters?

@Dmitrii Naumov

@NikaKakhetelidze to implement the record count in the select delegate you need to have two modes:

1. Normal mode that just returns all the records 
2. ‘Record Count’ mode

So, the full view select delegate code would look something like that:

public IEnumerable records()
{  
    if (PXView.RetrieveTotalRowCount)
    {
        int startRow = 0; 
        int totalRows = 0;

        PXSelect<SOShipment, Where<...>>.Select(null, null,
                               PXView.Searches,
                               Records.View.GetExternalSorts(),//Get sorting fields
                               Records.View.GetExternalDescendings(),//Get sorting direction
                               Records.View.GetExternalFilters(),//Get filters
                               ref startRow, 
                               PXView.MaximumRows, //Get count of records in the page
                               ref totalRows)();
        yield return new PXResult<...>(null)
            {
                RowCount = totalRows
            };
        }

        int startRow = 0; 
     else
     {
         foreach(var record in  PXSelect<SOShipment, Where<...>>.SelectWithViewContext())
         {
              yield return record;
         }
     }
}

//public virtual IEnumerable filter()
       {
            PXCache cache = Base.Caches[typeof(SOShipmentFilter)];
         SOShipmentFilter filter = cache.Current as SOShipmentFilter;
           var cmd = Orders.View.BqlSelect; //Add an aggregate function

           int startRow = 0;
           int totalRows = 0;
           var records = new PXView(Base, false, cmd)
               .Select(PXView.Currents, PXView.Parameters, PXView.Searches, Orders.View.GetExternalSorts(), Orders.View.GetExternalDescendings(),
                Orders.View.GetExternalFilters(), ref startRow, 0, ref totalRows);
           Base.Filter.Cache.Clear();
            filter.GetExtension<SOShipmentFilter, SOShipmentFilterExt>().UsrRowCount = totalRows;
            yield return cache.Current;
        }

-------------------------------------------------------------------------------------------

So at first I tried this approach and it was working but only after I was refreshing whole page, after that record was cached and new value appeard only after Reload page.

I decided to add Action button and when I click that Value assigned to field,

Mention that Orders View I have Copied in Extension class couse Orders.View.GetExternalFilters() was not working(it was null from Base.Orders)

------------------------------------------------------------------------------------------

[PXProtectedAccess]
    public abstract class SOInvoiceShipment_Extension : PXGraphExtension<PX.Objects.SO.SOInvoiceShipment>
    {
        [PXFilterable(new Type[]
        {

        })]
        public PXFilteredProcessing<SOShipment, SOShipmentFilter> Orders;

        [PXProtectedAccess]
        protected abstract PXSelectBase GetShipmentsSelectCommand(SOShipmentFilter filter);

        #region Actions
        public PXAction<SOShipmentFilter> Refresh;
        [PXUIField(DisplayName = "Refresh", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]
        [PXButton(CommitChanges = true)]
        public virtual IEnumerable refresh(PXAdapter adapter)
        {
            var cmd = Orders.View.BqlSelect;

            int startRow = 0;
            int totalRows = 0;
            var records = new PXView(Base, false, cmd)
                .Select(PXView.Currents, PXView.Parameters, PXView.Searches, Orders.View.GetExternalSorts(), Orders.View.GetExternalDescendings(),
                Orders.View.GetExternalFilters(), ref startRow, 0, ref totalRows);
            Base.Filter.Current.GetExtension<SOShipmentFilter, SOShipmentFilterExt>().UsrRowCount = totalRows;
            Base.Filter.Update(Base.Filter.Current);
            return adapter.Get();
        }
        #endregion
    }