To add a new column to a SQL search you will need access to SQL Maintenance.
Note: If you or your system administrator don't have access to SQL Maintenance, please ask a question in the MyAccess Portal Digital Assistant and ask to "Speak to a human" to be put through directly to our support team.
You can add the column by following these steps:
Open SQL maintenance from your Proclaim Toolbar
Select the Case Type at the top left
Select the Columns tab
Select the search you wish to amend
Click Update
Click the Plus icon on the left side of the screen
Select the field you wish to include on the SQL query
Press close when finished
Click Save at the bottom right
You have now added a new column.