Query Results - Incorrect information is displayed after request is submitted

Jarrett_Faulk

Hello Everyone,

I'm using the query results option to pull the user title from the User Advanced combination class.  I've set the Criteria to display the user title when it is not empty and i'm using the User Title as the display column.  I've set the do not show object details when object is selected and Add user-selected objects to template object as related items.  Here is the problem that I am facing.  
When I select the title and submit the request the query results is displaying the user's full name as opposed to the user's title. I've changed everything I can think of to try to display the title on the submitted request.

Has anyone overcome this issue before.

Thank you in advance for any assistance.

Brett_Moffett

Hi @Jarrett_Faulk
The Query result for a Request Offering selects a CI and associates that to the Work Item (SR or IR) that you are creating.
This will appear in two places:

1. The User Input results as a long complex field result
2. As a related item to the WI

This does not return just one specific field from the CI record but rather ALL of them in the form of a relationship to the full CI.
If you wish to pull out just one part of the User CI and place it in the Title or Description field then you will need to run a RunBook or some other piece of automation that pulls just the data you wish from the related User CI and places it back in the WI as text.

Even an Advanced Request Offering with the use of Multiple Mapping would not be able to gather this data and use it. This might be a good feature request though.....  

I hope this answers your question

Brett_Moffett

Hi @Jarrett_Faulk
The Query result for a Request Offering selects a CI and associates that to the Work Item (SR or IR) that you are creating.
This will appear in two places:

1. The User Input results as a long complex field result
2. As a related item to the WI

This does not return just one specific field from the CI record but rather ALL of them in the form of a relationship to the full CI.
If you wish to pull out just one part of the User CI and place it in the Title or Description field then you will need to run a RunBook or some other piece of automation that pulls just the data you wish from the related User CI and places it back in the WI as text.

Even an Advanced Request Offering with the use of Multiple Mapping would not be able to gather this data and use it. This might be a good feature request though.....  

I hope this answers your question