columns = ["ActivityObjectId", "ActivityTimesheetLinkFlag", "ApprovedHours", "ApprovedOvertimeHours", "CreateUser", "CreateDate", "Date", "IsBaseline",
"IsTemplate", "LastUpdateDate", "LastUpdateUser", "ObjectId", "OverheadCodeName", "OverheadCodeObjectId", "ProjectId",
"ProjectName", "ProjectObjectId", "ResourceAssignmentObjectId", "ResourceId", "ResourceIntegratedType", "ResourceName", "ResourceObjectId", "Status", "TimesheetPeriodObjectId", "TimesheetStatusDate", "UnapprovedHours", "UnapprovedOvertimeHours", "WBSObjectId"]
response2 = client.service.ReadResourceHours(columns, "ObjectId = '27490316'")
因此,在本例中,客户端使用“ReadResourceHours”函数调用读取资源小时数。它需要几个参数,1)要从数据库中读取的特定列名,2)过滤条件,在本例中是具有指定值的ObjectId
我创建了一个名为“columns”的字符串列名列表,并传递了对象“columns”。这很好,程序可以读取
但是,在传递字符串文字的筛选条件中,如何将该值存储到变量中,然后将该变量传递到筛选条件中,而不是实际键入"ObjectId = '######'"
原始代码:
response2 = client.service.ReadResourceHours(columns, "ObjectId = '27490316'")
所需示例:
Filter_Condition_One = 27490316
response2 = client.service.ReadResourceHours(columns, "ObjectId" = Filter_Condition_One)
目前没有回答
相关问题 更多 >
编程相关推荐