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

Previous Topic: Query Requirements for Use in Microsoft SharePoint

Next Topic: How to Write Useful Studio Queries for Microsoft SharePoint

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 project ID that the CA Clarity PPM project site is bound to. For a CA Clarity PPM Web Part in a non-CA Clarity PPM project site, the project to which the Web Part is bound.

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