I am trying to run "runNamedQuery()" from a script. I want to use it like I would the following: data = system.db.runQuery(SELECT * FROM datatable) Then I would use data[0][1] or something similar throughout my script. When I try using data = system.db.runNamedQuery(queryName, params) I never …

runNamedQuery()

lrose February 16, 2024, 6:33pm 12

No need to apologize, it's much easier to help with proper details. Thanks for those.

Make sure you have configured the Named Query as scalar. Then what you need is:

reportValue = system.db.runNamedQuery("Select Report Number B", {})

No, its just in a different place now.

See this post:

3 Likes