Time for action – creating a Dynamic Query

You will learn to create a dynamic query using the Lucene syntax and promote the related temporary index to permanent.

1. In the Management Studio, select the Indexes tab to display the Indexes screen.

2. Click on the Dynamic Query button to display the Query Index screen.

3. Click on the Dynamic/ list and select the Orders collection.

4. In the Query area, enter the following code snippet:

   UnitCost: [1 TO 20]

   Tip

   In the Query area, press Ctrl + Space to show the index fields list and select the UnitCost field.

   To do search on the data, instead of a lexical search you can use Unitcost: [Dx1 TO Dx20].

5. Click on the Execute button to show the results of the query.

   

6. Click on the Indexes link to show the Indexes screen.

7. Right-click on the Auto/Orders/ByUnitCost index to show the contextual menu and click on the Promote to auto index button.

   

What just happened?

We created a dynamic query which will retrieve all the documents in the Orders collection that matches the range values...