This page guides you through creating and querying your first fulltext search view.
- A Macrometa account with sufficient permissions to create search views.
addressescollection created during the first two steps of the Quickstart.
1. Create a Search View
- Log in to your Macrometa account.
- Click Data > Search Views.
- Click New View.
- In the Search View Name field, enter
- In View Type, select Fulltext Search.
- In the Collection list, select addresses.
lastNamein Field and then select text_en in the ANALYZER list.
- Click Add Collection twice.
- Perform steps 6 and 7 again for the
- Click Create.
Your three address collection key values are indexed in the search view and ready to query. Macrometa distributes this search view to every location in the global fabrics. If you're curious about the locations, click Dashboard to see the default GeoFabric locations.
2. Query the Search View
To query the search view, you can create a query in Macrometa to run it as needed or save it as a query worker.
On the side menu, click Compute > Query Workers.
If the code editor is not empty, then click New Query.
The code block below is a search query that will allow you to pass in a query parameter to search the search view. Copy and paste it in the code editor on line 1.
FOR contact IN addresses_view
BOOST(STARTS_WITH(contact.firstName, @searchTerm), 3) OR
BOOST(STARTS_WITH(contact.lastName, @searchTerm), 2) OR
BOOST(STARTS_WITH(contact.email, @searchTerm), 1),
SORT BM25(contact) DESC
RETURN UNSET(contact, ["_id", "_rev"])
Enter the word
nemoto the searchTerm value to the right of the editor window.
Click Run Query. Macrometa displays query results below the row of buttons.
(Optional) Click Query Info in the Query Result to see what the query did and how long each step took. Pretty cool if you're into performance metrics.
3. (Optional) Save the Query as an API Endpoint
When you save a query worker, you can access it via REST API from anywhere in the world in under 50ms.
- Click Save Query.
- Name the query getContactBySearchTerm and then click Save. This saves the query so you can use it again.
- Click Run Query.
- Click API Endpoint.
This query requires a value to be passed with each request, so you must enter one in the bind parameters or else the query will fail with an error.