If we want to use "When an item is modified (V2)" to send an email, should the related table includes a timestamp coulmn

[johnjohn123]

We have an SQL table and we want to use the "When an item is modified (V2) SQL" to send am email when an item is updated. now i am a bit confused if we should create a timestamp field inside the table or not? in other words currently our table has these fields:-

ID --> PK

Name

Type

Quantity

so will the "When an item is modified (V2) SQL" connector be able to send an email when a row is modified? or to do so we need to add a field of type timestamp? if the answer is yes >> then should we use a specific name for this column?

[eric-cheng]

Hi @johnjohn123 ,

As you already mentioned, you will need:

Rowversion is a data type so I dont think the name matters.  Please read here for more info.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[johnjohn123]

@eric-cheng  so Rowversion  is the same as timestamp?

[eric-cheng]

Hi @johnjohn123 ,

This should clear it up for you.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[johnjohn123]

@eric-cheng  but inside our SQL server database 2017 we do not have a datatype for RowVersion.. we only have timestamp..

[eric-cheng]

Hi @johnjohn123 ,

Please refer to this for SQL 2017 depending on how you are creating your column.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn