Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Customize Worker Incident View - Linked Incidents

Updated: 22 May 2010 | 2 comments
DRowland's picture
0 0 Votes
Login to vote

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

DRowland's picture
09
Feb
2009
0 Votes 0
Login to vote

Nobody...?



Shobud's picture
10
Feb
2009
0 Votes 0
Login to vote

Hi,

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">

<awaram name="id" ItemDataField="workitem_number" />

</aw:HyperLink>

(<aw:Label id="lblLinkedToStatus" ItemDataSource="<%# Container.DataItem %>" ItemDataField="workitem_status_lookup_value" runat="server" /&gt

</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