This Question is Assumed Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
1 Replies Last post: Dec 2, 2008 10:31 AM by Stephano  
Christina Karlsson   27 posts since
Aug 20, 2007
Currently Being Moderated

Dec 2, 2008 8:55 AM

Check which item type that is used?

i know it has been possible to see which item type that is used to an item set, but I can't find the way how to figure it out now. Anyone who knows?

Stephano   167 posts since
Jan 14, 2008
Currently Being Moderated
1. Dec 2, 2008 10:31 AM in response to: Christina Karlsson
Re: Check which item type that is used?

We are looking to impliment this feature in the near future (2.5 release).  Currently the only way would be to use a custom report, or just run a query directly from the DB.

 

SELECT dg.id AS SET_ID,
dg.display AS 'SET',
p.name AS PROJECT,
dt.id AS SETTYPE_ID,
dt.name AS SETTYPE
FROM documentGroup dg
  INNER JOIN documentType dt ON dg.documentTypeId = dt.id
  INNER JOIN project p on dg.projectId = p.id
WHERE dg.active = 'T'
ORDER BY p.name

 

Plugging that query into BIRT will give you a reusable display of all your sets by project; set type included.  Version 2.5 will be out in the first part of 2009.  In the mean time, I hope this helps.

More Like This

  • Retrieving data ...