/bundles/itninjaweb/img/Breadcrumb_cap_w.png

I am trying to show all the assets that belongs to the user who submitted a ticket inside the ticket.

I have setup a custom field query as the following:

CUSTOM_2 Multiple Select query: select NAME from ASSET where OWNER_ID=***

The *** should be the submitter ID for the ticket, I have tried all SUBMITTER_ID and SUBMITTER_ID.HD_TICKET and HD_TICKET.SUBMITTER_ID but none of them did work.

If I put a number there (i.e 791 is an ID for a user who got some assets), the ticket will show the correct assets.

 

Please advise, thanks!

0 Comments   [ + ] Show comments

Comments



Answers

This content is currently hidden from public view.
Reason: Removed by user request
For more information, visit our FAQ's.

0

I think the issue may have been due to the lack of a JOIN statement to pull data from the HD_TICKET table.  See if this might work:

select NAME from ASSET A JOIN HD_TICKET T on (A.OWNER_ID = T.SUBMITTER_ID) where A.OWNER_ID=T.SUBMITTER_ID

John

 

Answered 06/30/2012 by: jverbosk
Red Belt

  • Sorry for the late reply, I am afraid it still doesn't work, it pulls out all the assets and not the ones specific to submitter .. any other suggestions?