按日期显示每个任务的最新记录
按日期显示每个任务的最新记录
提问于 2015-11-30 19:56:32
我想显示每项任务的最新更新记录。目前，我只得到最新的所有记录，无论是什么任务。
这是前端代码
<asp:SqlDataSource ID="GrabAssignedTasks" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>"
SelectCommand="SELECT Backlog.Story, Tasks.Task, Tasks.EstimatedHours, Tasks.UserStoryTaskID, Tasks_Log.TaskLogID, Tasks_Log.HoursLeft, Tasks_Log.ModifiedDate
FROM Backlog
INNER JOIN Tasks ON Backlog.UserStoryID = Tasks.UserStoryID
INNER JOIN Tasks_Log ON Tasks.UserStoryTaskID = Tasks_Log.TaskID
WHERE (Tasks.OwnershipID = @UserID) AND (Tasks_Log.ModifiedDate = (SELECT MAX(ModifiedDate) AS Expr1
FROM Tasks_Log AS Tasks_Log_1))">
<SelectParameters>
<asp:SessionParameter Name="UserID" SessionField="loggedInUser" />
</SelectParameters>
</asp:SqlDataSource>
</div>
<header class="jumbotron hero-spacer">
<asp:Button ID="BackToTasks" runat="server" Text="Back" OnClick="BackToTasks_Click" CssClass="btn btn-primary btn-large" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="GrabAssignedTasks" Height="179px" Width="829px" OnSelectedIndexChanged="HoursChange_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="Story" HeaderText="Story" SortExpression="Story" />
<asp:BoundField DataField="Task" HeaderText="Task" SortExpression="Task" />
<asp:BoundField DataField="EstimatedHours" HeaderText="Estimated Hours" SortExpression="EstimatedHours" />
<asp:BoundField DataField="UserStoryTaskID" HeaderText="UserStoryTaskID" SortExpression="UserStoryTaskID" InsertVisible="False" ReadOnly="True" HeaderStyle-CssClass="hidden-field" ItemStyle-CssClass="hidden-field"/>
<asp:BoundField DataField="TaskLogID" HeaderText="TaskLogID" SortExpression="TaskLogID" InsertVisible="False" ReadOnly="True" HeaderStyle-CssClass="hidden-field" ItemStyle-CssClass="hidden-field"/>
<asp:BoundField DataField="HoursLeft" HeaderText="Hours Left" SortExpression="HoursLeft" />
<asp:BoundField DataField="ModifiedDate" HeaderText="Last Updated" SortExpression="ModifiedDate" />
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
</header>在C#代码中，我没有这方面的特定内容。
这是我正在使用的数据库中表的图片。数据库表
回答 1
Stack Overflow用户
回答已采纳
发布于 2015-11-30 20:16:22
您没有将表Tasks_Log与Tasks_Log_1连接起来，因此无论任务如何，只返回修改日期与"30/11/2015“匹配的Tasks_Log中的条目。在WHERE子句中为Tasks_Log_1添加一个条目，以确保在正确的TaskID上也匹配：
SELECT Backlog.Story, Tasks.Task, Tasks.EstimatedHours, Tasks.UserStoryTaskID, Tasks_Log.TaskLogID, Tasks_Log.HoursLeft, Tasks_Log.ModifiedDate
FROM Backlog
INNER JOIN Tasks ON Backlog.UserStoryID = Tasks.UserStoryID
INNER JOIN Tasks_Log ON Tasks.UserStoryTaskID = Tasks_Log.TaskID
WHERE (Tasks.OwnershipID = @UserID)
AND (Tasks_Log.ModifiedDate =
(SELECT MAX(ModifiedDate)
FROM Tasks_Log AS Tasks_Log_1
WHERE Tasks_Log_1.TaskID = Tasks_Log.TaskID))页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/34006855
复制相关文章
相似问题
腾讯云开发者
