Customize Worker Incident View - Linked Incidents
Updated: 22 May 2010 | 2 comments
I am trying to either sort or filter the list of linked child incidents in the Worker workitem view (template : WorkItemView.ascx). I'd like to either sort such that the incident that are NOT in a Closed status, are listed first or somehow displayed differently so they stand out.
I've been tyrying to find where the SQL is generated to simply add an 'order by' clause. Haven't found that yet.
Any ideas?
discussion Filed Under:
Comments
Nobody...?
Hi,
aram name="id" ItemDataField="workitem_number" />

Here's my take on this:
THese lines are probably the lineked items:
<UL>
<aw:repeater id="rptLinkedTo" runat="server" DataMember="LinkedToWorkItem" DataSourceName="WorkItem">
<ItemTemplate>
<li>
<aw:HyperLink id="hlLinkedTo" ItemDataSource="<%# Container.DataItem %>" ItemDataField="workitem_display_title" runat="server" Command="viewItem">
<aw
</aw:HyperLink>
(<aw:Label id="lblLinkedToStatus" ItemDataSource="<%# Container.DataItem %>" ItemDataField="workitem_status_lookup_value" runat="server" />
</li>
</ItemTemplate>
</aw:repeater>
</UL>
You can see that the DataSource is WorkItem and that the field within that source is LinkedToWorkItem.
The Workitem DataSource is created way ay the top of the file like this:
Dim w as WorkItemDataSet
w = new WorkItemDataSet(id)
DataStore("WorkItem") = w
So as you can see there's no exposed SQL for this. We'd have to know more about the available methods of the DataSource itself! Of which I have no idea. Maybe someone else has more experience with this.
Dan
Would you like to reply?
Login or Register to post your comment.