Question

MYSQL Query? I thinnk that's what I need

  • 28 October 2020
  • 3 replies
  • 57 views

Userlevel 1

I have an MYSQL database connected to Zapier.

It’s my order table

Each order has a order_id

I’d like to only search the last 200 lines

For a specific  order for order_status that equals the number 20

Then, send an email via my connected GMAIL to a colleague

 

Is that possible?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Only possible in zapier if there is one such row. If there are more, then the query will not retrieve all the information.

Userlevel 7
Badge +12

Hi, @IcarusZaps! If you were able to find the query that you needed for this, we’d love to hear about it 🙂

Userlevel 7
Badge +9

Hello! Yes - It should be possible - Are you running into any particular problems here?