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 › How to Write Useful Studio Queries for Microsoft SharePoint

How to Write Useful Studio Queries for Microsoft SharePoint

Use the following hints to write useful queries to use as data providers for CA Clarity PPM Web Parts. Or, to display important project information on the sites that you create. More hints are included in other sections of the guide.

• Filtering the items in a list by using a Studio query is generally faster and better than retrieving all of the items and then filtering the list in the SharePoint view. Therefore, consider writing Studio queries to filter down large lists.

  Example: If Work Breakdown Structure has a large number of tasks, use a query to retrieve only key or current tasks.

• Write and use NSQL queries that use the WBS Level attribute to filter a task list to show tasks that are at the top level of the work breakdown structure (where WBS Level equals 1).