Location is not a standard field that is contain in the helpdesk queue, if your ticket has a location field the chances are it will be a custom field.
Go into your configuration and edit the queue to confirm if this is the case.
If it is a custom field you can manually add this to the SQL, just remember that the custom field value in the UI decrements by 1, so Custom_12 in the UI is HD_TICKET.CUSTOM_FIELD_VALUE11 in the database
Sign up today to participate,
stay informed, earn points and establish a reputation for yourself!