I have a query that is designed to search for multiple criteria for an incident. The search and sorting work fine for all fields except for one. The field is the incident status title. When sorting by this field I receiving the following error.
There has been an unexpected error. Click Continue to return to the previous page.
Invalid column name 'T1_lc_title'.
The field name itself is lc_title so I am not sure why it is appending the T1_ to the field when trying to sort.
Any help is appreciate.