Skip to main content
Solved

Rename data field in a Generic Inquiry

  • April 8, 2021
  • 2 replies
  • 1396 views

What do I need to do in a GI to replicate the functionality I would use in SQL for example to have

SELECT Contact.DisplayName [Contact Name] from Contact where ContactType = ‘LD’

I want my GI column name to be Contact Name and not DisplayName.

Thanks

Best answer by hollyclark25

If I understand your question correctly, On the Results tab of the Generic Inquiry, there is a column called “Caption”.  You can ‘alias’ your column using this field:

Caption to ‘alias’ the column heading

Hope this helps!

Holly 

2 replies

  • Freshman II
  • Answer
  • April 8, 2021

If I understand your question correctly, On the Results tab of the Generic Inquiry, there is a column called “Caption”.  You can ‘alias’ your column using this field:

Caption to ‘alias’ the column heading

Hope this helps!

Holly 


  • Author
  • Freshman I
  • April 8, 2021

RATS! That was sickeningly easy. I didn’t think to look in the column configurator….Thank you Holly, have a great rest of your day