Sometimes you just need to be able to search all of SQLWorks at once – so SQLWorks’ Global Search function has been built to allow users to easily search anywhere (or everywhere) for that elusive file, record or entry.

Pressing the keyboard shortcut ‘Ctrl G’ (or ‘Cmd G’ on Apple devices) opens the Global Search window (1), from which users can select sections of SQLWorks they want to search through using the checkboxes in the top left (2) (e.g.: ’CRM’, ‘Stock’ etc, or simply ‘All’).

Type the intended search term in the text field, and specify the terms of the search: ‘Begins With’ the search term or ‘Contains’ the search term, using the radio buttons, and click the magnifying glass or press return to begin the global search (3).

Global Search will list any and all results in the List Menu below, including where those entries were located. As always, right clicking a list option and click ‘Get Info’ to see more information about that entry.

Double clicking a list item opens that entry from the relevant part of SQLWorks, wherever it has been found.

 

For more information, contact our team today: 01271 375999

Lineal SQLWorks Custom Search is designed to help you manage even the largest of business databases quickly and efficiently, so being able to find what you need easily is vital.

When a simple search isn’t quite cutting it, trying using SQLWorks’ ‘Custom Search’ tool for a more targeted search. This can be found by clicking the small dropdown arrows beside the ‘Search’ Field on the Search Bar, and selecting ‘Custom Search’ at the bottom of the list. This opens the ‘Custom Search’ window (pictured below.)

From here users can search different attributes of list entries in the left hand field, using a search criteria in the middle column (such as ‘contains’, ‘begins with’ etc.) relating to the text typed in the right hand field.

By pressing the (-) or (+) buttons on the right, users can also add or subtract extra conditions to build a more complex and specific custom search query, helping to find the needed entries.

‘Search for all records matching’ chooses the criteria searching, such as ‘Any’ or ‘All’ of the chosen terms, and by using the ‘Saved Searches’ dropdown menu users can set Custom Search to the ‘Last Search’ or save a custom search for next time.

Press ‘Search’ and SQLWorks will narrow down your list to the chosen custom search terms. Happy hunting!

 

For more information, contact our team today: 01271 375999