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]>><>, its actual KM is <<[KM]>>
The CAR ID is <<[_THISROW].[CAR]>>
But the SELECT() part it’s not showing nothing, any thoughts on this?