Hi,
I am new to Ignition, Can anyone help me out.
I am trying to bring email id from database and sending email with Script block in pipeline.I am getting error massage as Error executing scripting block in logs. I am triggering script block with Switch block then Script block will start executive and have to send email to the user.Can u please tell me can i send email with Script block without notification block for dynamic users.
The following is Script which is written in Script block.
query = system.db.runScalarQuery(" SELECT email_id FROM database.userlist where user_id = 2")
recipients = [query]
body = “Hello, this is an email”
smpt = “smpt.gmail.com:465:tls”
system.net.sendEmail(“mail.gmail.com”,"myemail@gmail.com", “Here is the email!”, body, 0, recipients)
It looks like this part is where your error is. For scripts, I'd recommend using the script playground tool to get them working first.
This should instead be something like this (not in front of pc to check):
#edit: this won't work, need to convert query to a pydataset, or use an incrementer and then val.getValueAt(i,0)
recipients = [Val.getValueAt(0) for Val in query]
Thanks you for your respond.
Actually i am working in Alarm Notification Pipeline.
Yes i was tested in Script console.But i am unable to get dataset from database.
I am getting like this in Script console.
Traceback (most recent call last):
File “”, line 2, in
AttributeError: ‘int’ object has no attribute ‘getRowCount’
Actually, you were right in your first post: the scalar function just returns a single value. Go back to that but include the database name as the 2nd argument.