データアクセスのファインチューニング

次のプロパティを使って、Azure DevOps から返されるデータをより詳細に制御できます。

• Catalog: Specifies the catalog to be used.
  • If you want to query data for a specific project, set Catalog to either Project_projectId or Project_projectName. For example, to query data in a project named dev with the ID 2ee729d6-804d-4ece-84af-d5befa94abe8, you can set Catalog to either Project_dev or Project_2ee729d6-804d-4ece-84af-d5befa94abe8. To get a list of project IDs and names, execute a SELECT query against the Projects table.
  • If you want to query information that is independent of a specific project, set Catalog to CData.
• Schema: Specifies the schema to be used.
  • If Catalog is set to CData, the only schema available is Information.
  • If Catalog is set to a project catalog, you can set Schema to either Analytics, Project, or one of the Repository schemas. If you want to query data for a specific repository, set Schema to Repository_repositoryId. For example, to query data in a repository with the ID 3ee729d6-804d-4ece-84af-d5befa94abe8, you can set Schema to Repository_3ee729d6-804d-4ece-84af-d5befa94abe8. To get a list of repository IDs and names, set Schema to Project and execute a SELECT query to the Repositories table.