search cancel

An overview of NSQL's and its use in Clarity


Article ID: 50806


Updated On:


Clarity PPM SaaS Clarity PPM On Premise



NSQL queries are read-only operations; they do not change data, they only retrieve it.

Only SELECT statements that specify which rows and columns to fetch from one or more tables are permitted. NSQL statements will fail with an error message if a statement does not start with SELECT. This means that UPDATE, INSERT, and DELETE operations cannot be performed in NSQL. NSQL should not used for reporting or for stored procedures.

Anything in the database can be used to call stored procedures.


When you define an NSQL query, you will identify the query segments and then designate them as metric values, dimensions, dimension properties, or parameters.

With NSQL, you can access data in the Clarity database and create queries in Studio and use them to create new portlets. Since queries are not directly associated with a single portlet, the same query can be used to produce multiple portlets.


Component: STUDIO


Please Update This Required Field

Additional Information

Please also look at:
And the manual for NSQL