Item Attribute History Report

You’re right – the Item Attribute History report can only do one part at a time.  I wonder if there’s ways to run this report automatically using a list of items (perhaps a WSX?)
Nonetheless, this is ultimately possible using a SQL/connect factory type script but it’s pretty advanced.  You’d tap into the ITEM_HISTORY table where ITEM (column) = ITEM_NUMBER from the ITEM table and ACTION (column) = (whatever number Agile assigns to Modify field), then return the Details column.  That’ll show you all the times an item was modified and then you’d pull that for a bunch of item numbers.  Obviously sounds advanced, which it is and will just give you a bunch of rows of text, rather than the formatted Item Attribute History Report you’re used to seeing.

Thank you for your answer Matt.  
I figured the best way was to use SQL but yes, I believe it is a complicated report to write to get it in a columnar format we’d like to see. I wonder if anyone has done it and is selling it!?

Your first answer was interesting too – unfortunately I’m not familiar with WSX.  Is that like a macrro?

Thank you,
Laura

I was referring to a Web Service Extensions.  Not sure if it’s useful or possible in your case, but they have their own functionality and here it would extract Agile data and present it to the user a bit better format than a database inquiry would.  I haven’t done my own WSX either yet, so I’m not as familiar with them either but the Agile 9.3.x SDK Developer guide has a whole chapter about them.

Laura,
Here is a SQL query example that may be use. In my case I was only looking for history of change-controlled changes on a subclass we named ‘Raw Material’  The Action ID in our case (‘Modify Change Controlled’) was 615.  I probably looked that value up somewhere, but don’t recall where at the moment.  This query takes the DETAILS string apart to get some useful info.  Obviously, you’ll have to tweak it to suit your needs.

Steve

Select I.Item_Number
, I.Description
, Substr(H.Details,Instr(H.Details,’:<‘)+2,Instr(H.Details,’>WAS’)-1-Instr(H.Details,’:<‘)-1) ATTRIB
, H.Details, H.Revnumber, H.Timestamp, U.Loginid
, Substr(H.Details,Instr(H.Details,’WAS<‘)+4,Instr(H.Details,’>IS’)-1-Instr(H.Details,’WAS<‘)-3) Value_Was
, Substr(H.Details,Instr(H.Details,’IS<‘)+3,Instr(H.Details,’>’||Chr(1)||’H’)-1-Instr(H.Details,’IS<‘)-2) Value_Is
From Agile.Item_P2p3 I
inner join agile.nodetable N on (I.subclass = N.id)
Inner Join Agile.Item_History H On I.Id = H.Item
Inner Join Agile.Agileuser U On H.User_Id = U.Id
Where 1=1
And Action = 615  –ID FOR ‘Modify Change Controlled’
And H.Details Like ‘%Page Three.%’
and n.description = ‘Raw Material’
  order by 1;

Thank you for your answers Steve and Matt! I really appreciate it!