What is the ticket submitter value if I am querying from a custom field?
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!