Query all Customers

[Former Member]

Hi all,

I'm trying to loop over all Customers in an absl script, but for the standard business object Customer there is no QueryAll, only a QueryById.

Does someone have an idea if there is a way to query all Customers?

Or is it that obvious and am I missing something here?

Thanks in advance!!

[Former Member · Accepted solution]

Hi Sander,

Fred Is correct you can user comment by Fred

Or

Try this

import ABSL;

import AP.FO.BusinessPartner.Global;

var query = Customer.QueryByIdentification;

var resultData = query.Execute();

In resultData you can get all Customer and you can navigate in association as well.

I hope this will be helpful to you.

Regards,

Mithun

[Former Member · Accepted solution]

Thank you Fred and Mithun!

It was indeed an obvious and quite easy solution!

[former_member200567]

Hi Sander,

          You can query all customers by QueryByID.

           var queryResult =Customer.QueryByID.Execute();

That will give you all the customers.

Best Regards

Fred