Skip to end of metadata
Go to start of metadata


This feature is new in Ignition version 7.9.6
Click here to check out the other new features
This function is used in Python Scripting.

Description

This clears the caches of all Named Queries in a project. If called from the Shared Scope (i.e., Tag Event Scripts, Alarm Pipelines, etc.) then the name of the project must be passed as a parameter.

Client Permission Restrictions

This scripting function has no Client Permission restrictions.

Syntax - Project Scope

system.db. clearAllNamedQueryCaches()

  • Parameters

none

  • Returns

No Return Value

  • Scope

All

Syntax - Shared Scope

system.db. clearAllNamedQueryCaches()

  • Parameters

String  project The Project that contains the named query whose cache needs to be cleared.

  • Returns

No Return Value

  • Scope

All

Code Examples
Simple Example
# Calling this simply clears all Named Query Caches. 
# This is assumed to run in the Shared Scope, so the name of the project must be included.
system.db.clearAllNamedQueryCaches("myProjectName")
Example - Clear Custom NQ Calls
# If multiple Named Queries with varying parameters are called in a single script, then clearAllNamedQueryCaches can be used to free up the memory used by all of the newly created caches. 
# This example is assumed to run in the Project Scope, so the project parameter may be omitted. 

# This creates one cache.
params = {"param1":"A"}
system.db.runNamedQuery("myUpdateQuery", params)

# This creates a separate cache.
params = {"param1":"B"}
system.db.runNamedQuery("anotherUpdateQuery", params)

# Clear all of the caches from the current project. Note that all caches are cleared, including those generated from elsewhere on the Gateway. 
system.db.clearAllNamedQueryCaches()
  • No labels