Pulling Job short text in Ad Hoc query

[Former Member]

Hi All,

I want to pull the 'short text' field defined in Job into my ad-hoc query. If we select the Output as 'Text only' for Job in IT0001 the output is always the long text e.g. Director of Human Resource. I want to output the short text e.g. DIRHR in my ad hoc query. Both short text and long texts are defined in IT1000 while creating a new Job however the queries from infoset PNPCE only pulls the long text. I can pull the short text in ad hoc query from a OM infoset but for the business requirements we have to use PNPCE. Is there a way to achieve this?

Thanks for your help.

Sanghamitra

[Former Member]

You have to create a custom field and can fetch the short text in the output selection.

By having short text in Output selection will not make any changes to your original infoset.