# BPM: Can this be combined into one LINQ query?

**URL:** <https://www.epiusers.help/t/bpm-can-this-be-combined-into-one-linq-query/61682>\
**Category:** Epicor ERP 10\
**Tags:** linq, bpm\
**Created:** [November 8, 2019, 7:32pm UTC](https://www.epiusers.help/t/bpm-can-this-be-combined-into-one-linq-query/61682 "2019-11-08T19:32:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Randy](https://www.epiusers.help/user_avatar/www.epiusers.help/randy/32/51539_2.png) [@Randy](https://www.epiusers.help/u/Randy)\
**Post date:** [November 8, 2019, 7:32pm UTC](https://www.epiusers.help/t/bpm-can-this-be-combined-into-one-linq-query/61682/1 "2019-11-08T19:32:58Z")

</div>

I can’t help thinking I could make it more efficient by combing the code below into one LINQ query. I don’t know it well enough to know for sure. I can get a BAQ to do this in one, but I’ve tried several things in code but everything errors out. As you can gather I’m working on a BPM for a custom Aging Hold process, the stock won’t work for us and with the number of customers we have I want to have the code as efficient as possible.

Any help appreciated

```auto
///#1 - Get List of customers with AgingLimits not currently on AgingHold 
var result = (from c in Db.Customer.With(LockHint.UpdLock)
              join ad in Db.AgingCredit.With(LockHint.NoLock) on new { c.Company, c.AgingCreditCode } equals new { ad.Company, ad.AgingCreditCode }
              where c.Company == Session.CompanyID && !c.AgingCreditHold
              select new { c, ad.AgingDays }).ToArray(); 

foreach(var cust in result)
{

///#2 - Get oldest Open AR Invoice for the Customer, ie: (max(InvcHead.DueDate)
    var maxDue = (from ar in Db.InvcHead.With(LockHint.NoLock)
                  where cust.c.Company == ar.Company && ar.OpenInvoice && ar.Posted
                  && (ar.InvoiceType == "MIS" || ar.InvoiceType == "SHP")
                  && cust.c.CustNum == ar.CustNum
                  select ar.DueDate).OrderBy(x => x).ThenByDescending(d => d).Min();

///#3 - Count the days from Today to maxDue, ie: datediff(day, InvcHead.DueDate, getdate()) )
int aging = ((TimeSpan)(DateTime.Today - maxDue)).Days;

///#4 - Check IF AgingDays > days(maxDue) 
///#4a IF ture: Set c.AgingCreditHold to TRUE and (then loop through their open orders **not linked to Jobs or POs** to OH.CreditOverride = FALSE)

```

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [November 9, 2019, 3:38am UTC](https://www.epiusers.help/t/bpm-can-this-be-combined-into-one-linq-query/61682/2 "2019-11-09T03:38:13Z")

</div>

Why not run the BAQ with a dynamic query? I’ve found that to be very reliable. Once you get the template down for how dynamic query works, it’s very similar every time you use it.

---

<div class="post-metadata">

**Author:** ![Randy](https://www.epiusers.help/user_avatar/www.epiusers.help/randy/32/51539_2.png) [@Randy](https://www.epiusers.help/u/Randy)\
**Post date:** [November 11, 2019, 3:07pm UTC](https://www.epiusers.help/t/bpm-can-this-be-combined-into-one-linq-query/61682/3 "2019-11-11T15:07:51Z")

</div>

Not a bad idea I guess, I’ve not yet setup a BPM to call a BAQ before so interesting idea.