Sales Price Maintenance...how to apply grid level user defined filters to select

Question

I've got some code on the Sales Prices (AR202000) that updates values. Right now, it works that it only changes the records in the grid based on the header search. If I, for example, quick search on the grid to limit to "starts with '24'" I still get all the records. I'd like the select in the code to limit to the user defined grid filters as well (I'm probably not calling those the right thing, picture below).

Code to cycle through looks like this:


    foreach (ARSalesPrice price in Base.Records.Select()) // I assume this needs to apply the grid filter
        {
             //Do Stuff
        }

I'm pretty sure this is possible with the filters, I just can't work out the details.

Thanks in advance.

Check this out: https://stackoverflow.com/questions/52870442/how-to-retrieve-the-filtered-records — Deetz, Nov 16 '20 at 16:21

score 0 · Accepted Answer · answered Nov 16 '20 at 22:30

0

The answer using the link in the comment...

        foreach (ARSalesPrice price in Base.Records.View.Select(null, null, PXView.Searches, Base.Records.View.GetExternalSorts(), Base.Records.View.GetExternalDescendings(), Base.Records.View.GetExternalFilters() ?? new PXFilterRow[0], ref min, 0, ref totalRows)) //Base.Records.Select())
        {
              // Do Some stuff
        }

answered Nov 16 '20 at 22:30

T-Rav

67
9

Now that's some nice easy cred :) – Deetz Nov 19 '20 at 16:07

Sales Price Maintenance...how to apply grid level user defined filters to select

1 Answers1