Send email notification using pipeline blocks

Ignition
21

I put a logger after this line users = system.db.runNamedQuery("getUserStatus")
I can't see logger message.

SQL request is not working. This is a mistakle for me because it is working on console

22

Console and pipeline are not in the same scope. You'll need to use the gateway scope syntax, where you pass the project name too.
I'm really surprised you don't have errors in the logs because of this... Or maybe you looked over them ?

1 Like
23

j'ai testé ligne par ligne et j'ai constanté qu'il faut ajouter le nom du projet sur la requette.

system.db.runNamedQuery("TurbineV520","getUserStatus")