I have a custom SQL trigger that used to work before I upgraded to Platform 2017. The query is: Nodes.LastSystemUpTimePollUtc 1 where ToBeDeleted is a Yes/No custom property. When I validate the query it fails. Can anyone suggest a reason that it does not work now? Thanks for any help.

Custom SQL trigger does not work in Platform 2017!

I have a custom SQL trigger that used to work before I upgraded to Platform 2017. The query is:

Nodes.LastSystemUpTimePollUtc < DATEADD(DAY,-10,GetDate()) AND ToBeDeleted <> 1

where ToBeDeleted is a Yes/No custom property. When I validate the query it fails.

Can anyone suggest a reason that it does not work now?

Thanks for any help.

That's not a query.

Try this instead:

SELECT Nodes.NodeID, Nodes.Caption FROM Nodes WHERE Nodes.LastSystemUpTimePollUtc < DATEADD(DAY,-10,GetDate()) AND Nodes.ToBeDeleted <> 1

1) have you tested the query in SQL to see if the syntax is still valid?

2) if you're calling that view name in your statement at all, it should be called everywhere... try this:

Nodes.LastSystemUpTimePollUtc < DATEADD(DAY,-10,GetDate()) AND Nodes.ToBeDeleted <> 1

If that still isn't working, please come back with a full screenshot of the entire alert trigger.

For reference, I have verified that Nodes.LastSystemUptimePollUTC still exists in Platform 2017.1

The query fails when testing using Database Manager:

I tried removing the space before and after the '<' after the LastSystemUpTimeUtc and that didn't work either. Ideas?

That's not a query.

Try this instead:

SELECT Nodes.NodeID, Nodes.Caption FROM Nodes WHERE Nodes.LastSystemUpTimePollUtc < DATEADD(DAY,-10,GetDate()) AND Nodes.ToBeDeleted <> 1