SELECT on EMAIL BODY TEMPLATE not showing results

[Ccuadros]

I have this tables:

Maintenances with this columns: [ID], [CAR], [KM]

Work_Shifts_Details with this columns: [ID], [INSPECTOR], [CAR], [WORK_SHIFT], [KM]

Then i have a bot for sending an email when Work_Shift_Details record is updated

So the Email Body Template goes like this:

The Car <<[CAR].[NAME]>> has surpassed the maintainance KM scheduled to <<Start: SELECT(Maintenances [ID], [CAR]=[_THISROW].[CAR])>> <<[KM]>><<End>>, its actual KM is <<[KM]>>

The CAR ID is <<[_THISROW].[CAR]>>

But the SELECT() part it's not showing nothing, any thoughts on this?

[Joseph_Seddik · Accepted solution]

---

@Ccuadros wrote:

<<Start: SELECT(Maintenances [ID], [CAR]=[_THISROW].[CAR])>>

---

Try with [CAR]=[_THISROW-1].[CAR]