Problem to Execute SQL query on Roster type Calculated

Ignition
1

Hello, I'am executing a SQl query when alarm is actived but it is not working.
This the syntax that I'am using.
system.db.runNamedQuery("SELECT username FROM wind_users WHERE status = 2","DB")
I noticed this when I put a loger after this line of code.

In fact, the lines of code that follow do not execute.

I test on console : system.db.runNamedQuery("SELECT username FROM wind_users WHERE status = 2") it is workin.

but on calculated roster not working.

2

You are passing what looks like an actual SQL statement instead of the name of one of your saved named queries.

I think you should be using runPrepQuery not runNamedQuery. runNamedQuery is for running predefined named queries that are saved in your project.

2 Likes
3

thank you @ryan.white I just tryied all two function. but nothing is happen

4

Look at the documentation for these functions for the syntax requirements for the scope you need. Gateway scope (pipeline execution) is not the same thing as Designer scope.

2 Likes
6

Specifically, for Gateway scope, it seems that database the name is required, but you're not providing it.

Edit: Additionally, you will need to provide a list of arguments as well (even if it's an empty list in this case).

https://docs.inductiveautomation.com/display/DOC81/system.db.runPrepQuery

I wonder if there's any error message logged to the Gateway about this.

Anyway, the following:

system.db.runPrepQuery("SELECT username FROM wind_users WHERE status = 2", [], dbName)

should be the correct syntax.

EDIT 2: corrected typo in post, should be runPrepQuery not runPredQuery.

7

I get that on log:


Logger	Time	Message
NotificationBlock	05Dec2023 21:22:45	Unable to parse calculated roster.
org.python.core.PyException: AttributeError: 'com.inductiveautomation.ignition.common.script.Imm' object has no attribute 'runPredQuery'

at org.python.core.Py.AttributeError(Py.java:178)

at org.python.core.PyObject.noAttributeError(PyObject.java:965)

at org.python.core.PyObject.__getattr__(PyObject.java:959)

at org.python.pycode._pyx177.calculateRoster$1(:19)

at org.python.pycode._pyx177.call_function()

at org.python.core.PyTableCode.call(PyTableCode.java:173)

at org.python.core.PyBaseCode.call(PyBaseCode.java:306)

at org.python.core.PyFunction.function___call__(PyFunction.java:474)

at org.python.core.PyFunction.__call__(PyFunction.java:469)

at org.python.core.PyFunction.__call__(PyFunction.java:459)

at org.python.core.PyFunction.__call__(PyFunction.java:454)

at com.inductiveautomation.ignition.alarming.pipelines.blocks.NotificationBlock.getEvaluatedRosterFromScript(NotificationBlock.java:233)

at com.inductiveautomation.ignition.alarming.pipelines.blocks.NotificationBlock.sendNotification(NotificationBlock.java:131)

at com.inductiveautomation.ignition.alarming.pipelines.blocks.NotificationBlock$EvaluationContext.onEvaluate(NotificationBlock.java:374)

at com.inductiveautomation.ignition.alarming.pipelines.blocks.AbstractEvaluationContext.evaluate(AbstractEvaluationContext.java:78)

at com.inductiveautomation.ignition.alarming.pipelines.SingleThreadAlarmPipeline$QueueEvaluator.run(SingleThreadAlarmPipeline.java:187)

at java.base/java.lang.Thread.run(Unknown Source)
8

Looks like a typo, should be system.db.runPrepQuery(

1 Like
9

Oops, I need to proofread these posts before I send them.