Issue
Some complex searches are easier to achieve, to filter your collision records effectively, by performing a simpler search on a sub-set of the records.
Solution
Sometimes the solution to simplify a search is to perform what is effectively a “nested query”, or a search on a search. This kind of search can be very complex to define and, whilst the Search Wizard in KeyACCIDENT provides a simple way to define searches, this can sometimes limit what can be achieved.
You have the option to enter full Structured Query Language (SQL) search, but a rich knowledge of SQL is needed.
The best way to perform a search on a sub-set of records is to add the sub-set as a new database.
Note - To do this you will need to have an empty (or temporary) database for the collisions from the first search. If you don’t have such a blank database it is very easy to create one. Unless you have been given elevated permission, you will need IT support from the server administrator to do this.
Once you have performed your first search, the results can be written to a file using the ‘Export’ step in the Search Wizard. Select the KAML or KAMZ format. You can specify KAML or KAMZ (a compressed KAML file) from the dropdown option for Save as type:
Once exported, you can switch to the blank database and use the ‘Add Records’ function to add the records into the blank database for further searches and analysis.