Trouble running an alarm notification block named query

Ignition
1

I have two projects with one containing all my scripts, named queries, etc. I am trying to get an alarm notification block calculatedRoster running using a named query from the parent. I see the query within the child project that was inherited from the parent. when i run the same script in the console it returns the results I am expecting. I put essentially the same into the calculatedRoster script and I get no errors in the script. When I try to test the notification block I get the following issue:
org.python.core.PyException: java.lang.IllegalArgumentException: java.lang.IllegalArgumentException: Project name required for script execution: the Gateway Scripting Project is not set.

I went into the gateway and made sure the gateway scripting project was set to the parent. I have also tried changing my runDBQuery to include and not include the parent in the path..including "Parent/namedquery" and also "Parent", "namedquery".

What am I missing?

2

The script console is Vision scope. Notification pipelines are Gateway scope. The function argument requirements are different. Look closer at the docs.

3

Are you talking about the system.db.runquery function?

4

No, because that doesn't run named queries.

5

I meant system.db.runNamedQuery

6

Yes. Look closer at the docs, in regards to scope.

7

Thanks. I did. I no longer get that message because I included the project name in the query. I now get a error telling me its getting a string instead of a dictionary.

8

You'll now have to share your code. Please format it for readability.

(Please see https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831.)