MapInfo Pro

 View Only
  • 1.  Multi Search Tool

    Employee
    Posted 09-21-2022 02:23
    Edited by Peter Møller 09-22-2022 09:29

    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.

    Features

    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.


    The tool comes with documentation with more details.

    Source code

    The source code for the application can be found on GitHub: MultiSearchTool.

    Questions, requests, and ideas

    If you have questions about the tool, post these as comments to this article.
    Ideas and requests for improvements can be posted as comments too. You can also report these as Issues through Github.

    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------


  • 2.  RE: Multi Search Tool

    Employee
    Posted 03-07-2023 03:19

    @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.



    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------