CData SSIS Components for Microsoft Project 2019J - Online Help

TimeSheets

CData SSIS Components for Microsoft Project 2019J - Build 19.0.7354

Query TimeSheets entries.

テーブル固有の情報

Select

フィルタが指定されていない場合は、次のクエリは、すべてのTimeSheetPeriods からのTimeSheets を返します。

SELECT * FROM [TimeSheets]

TimeSheetPeriodId をWHERE 句に指定すると、他のフィルタが本製品 のクライアント側で実行される一方、本製品 はMicrosoft Project API を使用してTimeSheetPeriodId による結果をフィルタリングします。例えば、次のクエリはサーバー側で実行されます。

SELECT * FROM [TimeSheets] WHERE TimeSheetPeriodId='bb8df57b-0e66-e711-80db-00155dc4ab09'
SupportEnhancedSQL をfalse に設定すると、クライアント側の実行をオフにできます。その場合、その他のカラムに基づく検索条件でエラーが発生します。

Columns

Name Type Description
Id [KEY] String The unique identifier of the timesheet.
TimeSheetPeriodId [KEY] String The unique identifier of the timesheet period.
Comments String The timesheet comments.
Creator String The timesheet creator.
EntryMode String The timesheet entry mode. Examples of entry mode include Daily and Weekly.
IsControlledByOwner Boolean A value that indicates whether the timesheet is controlled by the owner.
IsProcessed Boolean A value that indicates whether the timesheet is finalized and should not be changed.
Name String The timesheet name.
TotalActualWork String The timesheet total actual work.
TotalActualWorkTimeSpan String The time interval for the timesheet total actual work.
TotalNonBillableOvertimeWork String The timesheet total non-billable overtime work.
TotalNonBillableOvertimeWorkTimeSpan String The time interval for the timesheet total non-billable overtime work.
TotalNonBillableWork String The timesheet total non-billable work.
TotalNonBillableWorkTimeSpan String The time interval for the timesheet total non-billable work.
TotalOvertimeWork String The timesheet total overtime work.
TotalOvertimeWorkTimeSpan String The time interval for the timesheet total overtime work.
TotalWork String The timesheet grand total of all work.
TotalWorkTimeSpan String The time interval for the timesheet grand total of all work.
WeekStartsOn String The day of the week on which the timesheet starts.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0