如何通过SQL获取任务信息 [英] How to get the Task information by SQL

问题描述

Hello,All:

         我想通过SQL获取列表数据.我已经通过以下SQL获取TaskId.但是我不知道如何通过SQL获取任务详细信息?

          I want to get the list data by SQL. I have already get the TaskId by the following SQL. But I don't know how to get the task detail information via SQL?

SQL:

SELECT     D.Username,D.Delegate, I.SiteID, I.WebID, I.ListID, I.ItemID, I.WorkflowID, I.WorkflowName,I.WorkflowInitiator,I.WorkflowInstanceID,I.StartTime, M.TaskId,M.Title, HW.ApprovalData,HW.Outcome
FROM                  dbo.DelegationHistory AS D INNER JOIN
                      dbo.HumanWorkflowApprovers AS A ON D.ApproverID = A.ApproverID INNER JOIN
                      dbo.HumanWorkflow AS HW ON HW.HumanWorkflowID = A.HumanWorkflowID INNER JOIN
                      dbo.WorkflowProgress AS P ON P.WorkflowProgressID = HW.WorkflowProgressID AND P.ActivityComplete = 0 INNER JOIN
                      dbo.WorkflowInstance AS I ON I.InstanceID = P.InstanceID INNER JOIN
					  dbo.HumanWorkflowApproversMetadata AS M ON A.ApproverID = M.HumanWorkflowApproverId

任务列表:

推荐答案

SharePoint不支持直接从SQL数据库访问列表数据.相反，我会使用REST或list.asmx Web服务来访问数据.

Accessing list data directly from the SQL database is not supported in SharePoint.  Instead I would use REST or the lists.asmx web service to access the data.

这篇关于如何通过SQL获取任务信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！