Best answer

Ordering SQL source data by Ascending

  • 24 November 2020
  • 1 reply
  • 67 views

Hi All, first post so go easy one me :)

I have several Zaps up and running perfectly from SQL to Salesforce, and have a good uinderstanding of how to set up a Zap etc.

My question is, can I change the ORDER BY in the trigger to work in Ascending order rather than Descending?

icon

Best answer by Troy Tessalone 24 November 2020, 19:10

View original

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

1 reply

Userlevel 7
Badge +14

Article: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15

My trigger of New/Updated Row isn't picking up any of my updates

You'll need to specify ORDER BY by a date/time field such as date_updated or last_modified.