It's all about the answers!

Ask a question

Report of all the assets with a particular submitter


iRAM Administrator (3152156135) | asked Nov 03 '10, 1:19 p.m.
We need to pull a report of all the assets with a particular submitter(not owner). Is there any way to get such a report(probably by querying the database)?

3 answers



permanent link
Rich Kulp (3.6k38) | answered Nov 04 '10, 2:44 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Hi,

What is your definition of submitter:

a) The person who originally submitted the asset, and thereby created
it. This would be the original owner. The ownership may of been changed
since the original submission.

b) The people who have "submitted" updates to the asset since the
creation (original submission) of the asset, including just changing states.

c) The last person who "submitted" an update to the asset or changed the
state of the asset.

--
Rich Kulp
Rational Asset Manager developer

permanent link
Matt Vestal (5131) | answered Nov 05 '10, 2:19 p.m.
JAZZ DEVELOPER
Using the search input field, you can search for assets from a submitter using:
{_submitter_:(USER NAME)

For instance, searching for assets I have submitted:
{_submitter_:(Matthew J. Vestal)


You can then use the search shortcut to use the reporting URLs to get the asset data:
/reporting/asset:shortcut=ramSearch:(1txt%2C{_submitter_%3A(Matthew+J.+Vestal))

permanent link
Rich Kulp (3.6k38) | answered Nov 05 '10, 2:39 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Matt,

To be clear, the definition of "submitter" that you are using here is
someone who submitted OR updated an asset? Or is it just the original
submission?

--
Rich Kulp
Rational Asset Manager developer

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.