A new tool has been posted to the MapInfo marketplace: Multi Search Tool.
This is the first version of a tool that can help you search your tables or locate specific records in a table through a wildcard search dialog.
Wildcard Search allows you to search for specific values in a configured setup. This would typically be addresses or properties but is not limited to this. Below you can see how the Wildcard Search dialog can look. In this example, the dialog has been configured to search in 3 columns. It can also search in just one or two columns.
Search All Columns is another feature of this application. It was added through a request here in the community. It allows you to search through all columns in a table for a specific value. Below you can see how this dialog allows you to control what to search for, in what table and what column types.
Finally, the tool adds four useful features to the context menu of all browser windows. These allow you to zoom to the extent of your current selection, pan to a single selected record, filter the browser based on a selected value, and create a group by query for the selected column.
@John Ievers gave the Wildcard Search of the Multi Search Tool a spin with the UK Addressbase Core dataset containing around 34 million addresses in the UK.
As John mentions in his video below, with this amount of data to search, it's important that the first column you have set up to search is using the "equal to" operator as a Like search will take minutes.
If you have fewer records, it's not that important but there will still be a difference. With 3.5 million records, the difference is around 30 seconds. It takes 30 seconds if you don't include for example a postcode in your search.
John used the full postcode in his search. You can also use for example just the District Code or Sub-District Code to filter down the results.