Search

Xano offers robust search capabilities, commonly referred to as fuzzy search, that you can utilize while querying records in a function stack. This includes normalization of words (ie. party vs parties), case-insensitive support, flexible expressions (words, phrases, and negations), and weighted priorities (ie. title vs description) for relevance.
The following demonstrates how to set up search in your database, the logic behind the search functionality, and best practices for utilizing search queries.
Creating a Search Index
First, create an index. Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. An index is used to define which fields of the database table you want to search. You can even build multiple search indexes on the same table to build different search criteria. For example, if you have both public and private data in the same table, you can build a "normal user" and an "administrator" search.
To create an index, click Indexes at the top of the table you would like to build search for, and then click Create Index.
Choose search as the index type, and give the index a name. Next, specify the language for the data you are searching, the fields you are searching, and the ranking order of the fields being searched.
An example of creating a search index.
In this example, we created a new search index on a database of movies called search_movies, in English, and are searching two fields in that database: title and overview. The title field will rank higher than data in the overview field in the qualified search results. 
Once ready, click Save and Xano will build your index. This can take a few minutes depending on the volume of data of the table.
Building a Search API
After generating the index, it can be implement it into a query in the function stack. Use the Custom Query feature in the Filter tab of the Query All Records function. 
When adding a custom query, the newly created index is available in the expression builder, noted by the $ symbol. It is also labeled as search underneath the name.
Look for the $ symbol as well as the word search to easily find your search index when configuring your query.
Next, set the operator to search and specify the search query. In this example, we are using an input called search_query. 
Setting the operator to Search and specifying our search query.
Congratulations! 🥳 You've just implemented super-fast search inside your function stack.
Ranking
You can implement a ranking system and sort the search results by this rank for more precise search results. To do this, go to the Output tab of the Query All Records function, add an eval on the search index, and apply the search_query filter. This tells Xano to "use my search index to generate a ranking score of my results based on my search query".
Create and Eval on the search index by applying the search_rank filter so we can sort by ranking.
After, add a sort to the query using the newly created eval (in this example, called "rank"). You may also consider to enable paging especially on larger queries.
Add a Sort to the Query by clicking on the Return portion of the Output tab.
Order by in descending order will provide the most relevant search results first.
Different Search Methods
Search queries can be written in different ways to fulfill specific search requirements. 
1.Words separated by a space imply an AND.
Example: A query of "toy story" means search for toy AND story
2.Exact phrase searches are possible using escaped double quotes.
Example: If you wanted to search for "Toy Story" as an exact match, your query would be "\"Toy Story\"".
3.Negation of specific words is possible by using a - character.
Example: If you wanted to search for movies that have Toy in the title, but not Toy Story, your query would be "toy -story".
4.You can also use a combination of these to get even more specific.
Example: Searching for "\"toy story\" day -night" would mean search for the phrase Toy Story and the word day, without the word night.
5.Single vs Plural is supported.
For example, "toy" will also return results that contain "toys".
Stop Words -- are commonly used words such as articles, pronouns and prepositions. For example: is, and, an, or, the. Stop words are not included in your search query.
Search Results
Search results are returned just like any other API response and the data works just like any other variable inside Xano.

Working with data - Previous

Dot Notation

Next - Working with data

Functions

Last modified 1mo ago

Copy link

Outline

Creating a Search Index

Building a Search API

Ranking

Different Search Methods

Search Results