CA Clarity PPM Data Providers Used for CA Clarity PPM Web Parts › Using Studio Queries as Data Providers for CA Clarity PPM Web Parts › Restrict a Studio Query to Execute on a Particular Project

Restrict a Studio Query to Execute on a Particular Project

You can include the following WHERE statement to restrict queries to run on particular project in CA Clarity PPM. The WHERE statement has the following format:

project ID = @WHERE:PARAM:USER_DEF:INTEGER:SP_PROJECT_ID@

project ID

Any valid SQL expression that can represent the ID of the CA Clarity PPM project.

The right-hand side of the statement retrieves the associated project ID for the CA Clarity PPM project site. The statement retrieves the associated project for the Web Part in a non-CA Clarity PPM project site.

Note: You can include the WHERE statement multiple times in the same query. Use multiple WHERE statements in a query that includes UNION expressions or WHERE statements.