Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


This feature is new in Ignition version 7.9.6
Click here to check out the other new features

Description

This clears the caches of all named queries in this project.

Client Permission Restrictions

This scripting function has no Client Permission restrictions.

Project Scope Syntax

system.db. runNamedQuery(path, parameters )

  • Parameters

String  path  -  The path to the named query to run. Note that this is the full path to the query, including any folders.

PyDictionary  parameters  -  A Python dictionary of parameters for the named query to use.

  • Returns

Object The results of the query. The exact object returned depends on the Query Type property of the Named Query: typically either a dataset when set to Query, an integer representing the number of rows affected when set to Update Query, or an object matching the datatype of the value returned by a Scalar Query.

  • Scope

All

Gateway Scope Syntax

system.db. runNamedQuery(project, path, parameters )

  • Parameters

String  project The project name the query exists in.

String  path  -  The path to the named query to run. Note that this is the full path to the query, including any folders.

PyDictionary  parameters  -  A Python dictionary of parameters for the named query to use.

  • Returns

Object The results of the query. The exact object returned depends on the Query Type property of the Named Query: typically either a dataset when set to Query, an integer representing the number of rows affected when set to Update Query, or an object matching the datatype of the value returned by a Scalar Query.

  • Scope

All

Code Examples
Simple Example - Without Parameters
#This example will run a Named Query without any parameters in the Project scope.
#The second argument in the function is NOT optional, so named queries that do not require a parameter must still pass an empty dictionary as an argument.

#Request the Named Query with an empty dictionary as the second parameter. 
system.db.runNamedQuery("folderName/myNamedQuery", {})
Gateway Scope Example
#This example will run a Named Query without any parameters in the Gateway scope.
#The last argument in the function is NOT optional, so named queries that do not require a parameter must still pass an empty dictionary as an argument.

#Request the Named Query to execute. 
system.db.runNamedQuery("ProjectName", "folderName/myNamedQuery", {})
Simple Example - With Parameters
#This example will run a Named Query while passing some parameters in the Project scope.
#The Named Query is assumed to have two parameters already defined on the Named Query:
#param1 : A string
#param2 : An integer

#Create a python dictionary of parameters to pass
params = {"param1":"my string", "param2":10}
 
#Run the Named Query
system.db.runNamedQuery("myUpdateQuery", params)
  • No labels