By David Crowther
Question:
How do I do a Simple Search e.g. Planning App Number for PostGIS data?
Answer:
In this previous blog - https://www.cadlinecommunity.co.uk/hc/en-us/articles/360002583337-MapThat-Create-PostGIS-Search-Layers – we explored how to create a MapThat PostGIS Search Layer using a List of Unique values. Using the syntax below we can now create a Simple Search which allows users to search by App Number/Name etc…
Search Syntax
Having created your Search Layer, use this syntax in the Layer SQL Statement box:
Select * from planningapps4326multigeom where name like '%:name%'
- planningapps4326multigeom – is this PostGIS Tablename
- name – is this Search Parameter Name as shown below
Search Parameters:
As per normal you will also need to add the Search Parameters.
In this example we will allow the User to search via the name field and present the results as a COMBO box where the user can start typing and the list of results are filtered as the User types.
Note – PostGIS is very case sensitive, so be wary when defining the Table/View and the Column values.
Simple Search:
Ensure that you tick the Used for Simple Search in the Data Layer edit form so that the Search Layer runs as a SIMPLE search.
Projects Searches:
Finally ensure that the new Search Layer is exposed in your Project using the Project - Project Searches Tab to add the new Search Layer.
Now within MapThat you can run the new PostGIS Planning Apps Search by App Number/Name. As the User types their value, the list of records are filtered to match the values being entered.
As this is a Simple Search, the results are shown as a Simple list below the Search criteria. Select a record and zoom into the map over the blue pin to find the feature.