system.db.clearAllNamedQueryCaches

Deprecated by system.db.clearQueryCache in 8.3

Click here to learn more about system.db.clearQueryCache.

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

Vision Clients

Syntax - Shared Scope

system.db. clearAllNamedQueryCaches()

Parameters

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

Returns

No Return Value

Scope

Gateway, Perspective Session

Code Examples

Example - Clear All Named Query Cache for a Specific Project

# 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 All Named Query Cache

# 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()