endo

Hi.

I am trying to make a report that lists all incidents from a particular department. But I am not succeeding 100 %. I am not able to get the whole history (comments) for each incident.

Can anyone point me in the right direction???

This is what I have so far:

SELECT T0.[workitem_number] AS 'Incident number',
T0.[workitem_created_on] AS 'Created on',
T0.[assigned_to_worker_name] AS 'Assigned worker' ,
T0.[contact_name] AS 'Contact name',
T0.[workitem_title] AS 'TITLE',
T0.[workitem_comment] AS 'Comment'
FROM [HD_workitem_current_view] T0
WHERE T0.[contact_department] LIKE '%Asset Management%'
ORDER BY T0.[workitem_number] ASC

dominique

Depending how far back you want to go you might want to use the "details" view instead of the "current" view. You have a lot of history information stored in this view.

thanks

__________________
Thanks
Dom
http://www.altirigos.com

"Helping somebody else may help you"

endo

OK. I actually want to see incidents created for this year (2008). So how do I do that?

Will all the history of the incident return when using the other view?

JMoreno28

Send me your email (Private Message) and I'll try to send you a report that may fit your needs.