topic Filtering a search to 10 customers in Community Chat

Filtering a search to 10 customers

Nesh — Fri, 14 Jun 2024 16:34:08 GMT

I have a recipe where I am pulling invoices from the past 2 years. I want to add a condition where it will only pull records for 10 customers. I have not been very successful in setting up a formula using customer ID's. I have attached a copy of the condition I have currently. Any help is greatly appreciated. Thanks!

Re: Filtering a search to 10 customers

kkamal — Sat, 15 Jun 2024 08:12:36 GMT

equals usually takes a single value for comparison. (as you have provided 2112)

What are other options for operator selection other than equals ? if there is an option "IN" that might give you further a way to put multiple customer ids and you could use 10 customer ids.

Your questions seems incomplete. a bit more context would've been helpful.

Re: Filtering a search to 10 customers

Nesh — Thu, 20 Jun 2024 18:49:29 GMT

Thank you for your help! The only operator options I have are below (see screen shot)

So basically, in this recipe, I am pulling past due invoices for all customers in our ERP system dating back two years from today. However, for the first initial testing phase, I want to add a condition/filter where only 10 customers' data is retrieved. This is where I need some help.

Re: Filtering a search to 10 customers

pavan-narayan — Wed, 10 Jul 2024 07:23:29 GMT

Hi @Nesh ,

Just keep an if condition after for each if list of Index equals to 9 then stop job in this way you can have only 10 records pulled for your intial phase testing.