Searching for customers by delivery area next delivery date

Ideas & feature requests
1

We plan our sales calls and emails for the week according to which delivery runs we are doing that week. As we have a mix of weekly, fortnightly and monthly delivery runs, its gets quite complicated.

On the delivery zones page, there is a column of ‘Next delivery date’, but I can’t seem to be able to filter using BrewwQL to bring up a list of customers of ‘Next delivery date’ = next week for example.

Is this something that can be implemented?

1 Like
2

Thanks for the great suggestion, Robin.

I’m please to confirm that we’ve exposed the next_delivery_date field on delivery areas via BrewwQL now :tada: This means, that when filtering Customers using BrewwQL, you can now search like this:

delivery_areas.next_delivery_date = "14/04/2025"

For more on how dates are handled in BrewwQL, please see our BrewwQL Dates help guide. Hopefully this covers what you need, but please let us know if you have any questions :smile:

1 Like
3

Hi Luke,

Amazing news! I will report back later today to double check its working properly.

Cheers

Robin

1 Like
4

Hi Luke,

This does look like it is working as expected, although I need to get my head around using BrewwQL date parameters. It seems that using “This Week” is too vague. Currently I’m using the >=“This Monday” and <=“This Friday” to constrain the week. Is there a better/easier way to do this?

1 Like
5

That’s the right way to do it :+1:

BrewwQL date filtering is always based on a specific date. “This week” isn’t a specific date; it’s a date range (e.g. 14th April to 20th April), this is why you cannot use:

delivery_areas.next_delivery_date = "This Week"

but you can use:

delivery_areas.next_delivery_date >= "This Monday" and delivery_areas.next_delivery_date <= "This Friday"

Hopefully that makes sense.

You can save lists to prevent you from having to enter the BrewwQL filter every time. Then, as long as your filter uses “relative dates” (like “This Monday” rather than “14/04/2025”), the saved list will always be the list for “this week”.

1 Like
6

Hi Luke,

That’s great, thanks for the clarification.

Cheers

Robin

1 Like
7

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.