Overriding PXSelectOrderBy Sorting

Hi @mgygi76,

Have the same Bql with changing order by with same view Name in extension graph.

@mgygi76  If you wanted to see in the ascending order like in the old version 20 R1, it is not required for any overriding of PXSelectorOrderBy<>.

It requires a small piece of customization that you need to extend the “ARDocumentEnq” graph and have the same view with ascending order like below. 

    public class ARDocumentEnqExt : PXGraphExtension<ARDocumentEnq>
    {
        [PXFilterable]
        public PXSelectOrderBy<ARDocumentResult, OrderBy<Asc<ARDocumentResult.docDate>>> Documents;
    }

Hope this helps!

I did try this and we are on the right track, however now the grid will not filter when you use the selectors on the form.  It also now pre-populates the grid with all results, instead of waiting for the filters to be populated first.  Any thoughts?

Thank you so much that did the trick!

Awesome @mgygi76  Thanks for sharing the update!

Boosting for visibility, ​@Naveen Boga to the rescue as always!

I ended up using a similar approach to get some dynamic date math into a view definition on a custom graph. Does anyone have a better way to get only results from the last day (or week/month/year) in a BQL query? From what I have seen, it is not possible, since BQL does not support runtime calculations?

Below is my workaround based on the approach in this thread, but I would not want to use this for a large result set...If anyone has a better solution, I would love to know about it!

    public PXSelect<AKSOClonerHist,

                Where<AKSOClonerHist.orderNbr, Equal<Current<SOOrder.orderNbr>>>,

                  //removing filter, as we can apply other conditions in the override.

                  //And<AKSOClonerHist.isCreatedSuccessfully, Equal<False>>>,

                OrderBy<Asc<AKSOClonerHist.isCreatedSuccessfully, Desc<AKSOClonerHist.lastModifiedDateTime>>>> DetailsView;

    public PXSelect<AKSOClonerHist,

                Where<AKSOClonerHist.orderNbr, Equal<Current<SOOrder.orderNbr>>>,

                  //And<AKSOClonerHist.isCreatedSuccessfully, Equal<False>>>,

                OrderBy<Asc<AKSOClonerHist.isCreatedSuccessfully, Desc<AKSOClonerHist.lastModifiedDateTime>>>> FilteredDetailsView;

    [PXOverride]

    public IEnumerable detailsView()

    {

      DateTime threshold = PXTimeZoneInfo.Now.AddDays(-1);

      foreach (AKSOClonerHist row in FilteredDetailsView.Select())

      {

        if (row.IsCreatedSuccessfully == true && row.LastModifiedDateTime < threshold)

        {

          yield break;

        }

        yield return row;

      }

    }