To create a new SQL search on your Proclaim system, you will need access to SQL maintenance to do this:
Open SQL maintenance
Select the case type you wish to search in on the top left
Click the New button at the bottom right
Type the code that you wish to associate with the SQL search in the first box
Type the description of what it does in the second box
Click save
Select the criteria tab
Click update at the bottom right
Click the plus icon to add criteria
Select a field to base the criteria on, E.G client address line 1.
Then choose what you want to search against the criteria such as a question: What is the clients name?
Click save
You have now created an SQL case search.
If you have any further issues or do not have access to SQL maintenance, then please raise a new case online and reference the title of this article.