If you want to know how to upload a CSV file to create a Mirata Data Table, go to the Uploading Data to Mirata article.

Once you have a data table created in Mirata, you can create queries to grab subsets of that dataset. These queries can be used to bring data into Mirata forms. 

To demonstrate how to do this, we’ll walk through how to set up an example use case in this article. Let’s say your use case is: You have a data table that holds all viable line number / region pairs (below screenshot). You’re building a form in which the technician will provide what region they’re doing the work in and then they need to select a viable line number based on that region. So, if they select that they’re working in the South region, then they select either 20, 4000, or 1 as the line number.

(1) Build a Data Table Query (Integration Action) 

The first thing you’ll need to do is build a data table query, which is just a specific type of Integration Action. You’ll create an Integration Action of type Data Table Request and then select Query as the type of Data Table Request. 

To create one in the Admin Tool follow the below steps:

Create an Integration Action:

1. Go to the ADMIN TOOL tab and then the Integration Actions tab
2. Click +ADD INTEGRATION ACTION
3. Name: Set a name for your action (this is how form designers will find the action)
4. Action Request Type: Select Data Table Request
5. Click SAVE
   
   Select Data Table Request and Query:
6. Go to the REQUEST tab
7. Data Table: Select your data table that you want to query. I’ll select “LIne Numbers by Region”.
8. Request Type: Select “Query”

1. Now you’ll see “Query Parameters” options below with a +ADD button to build out your query    
   

Build your query using the Query Builder:

9. Click +ADD and select the column from your data table that you want to search by. In our example, we’ll select Region.

1. You have many options to query by if the values in the column contain, begin with, doesn’t contain, exist, etc. and to type in a constant value or use an input parameter. In this simple example, we want to search for records where the region equals an input parameter. 

10. Select Input Parameter in place of Constant
11. Click the Select a Parameter dropdown and then click Add an Input Parameter
12. Click SAVE
13. Now we’re done building our query so click SAVE in the top right
    
    
    Test your query: 
14. Go to the TEST tab (you always want to test your query before adding it to a form)
15. Enter a sample value for your input parameter(s). In our case, Region. I’ll enter “South”.
16. Click RUN TEST
17. You should see a success message and see the records you were expecting appear in the results (in our case, that’s 20, 4000, and 1). If this is not the case, you should review the above steps to make sure you set up the request correctly and try testing again.
    

(2) Set up the dropdowns on your form

On your form, we want to add two dropdown components, one for the region and one for the line number. After you’ve added these two fields and named & labeled them, follow the below steps: 

Set up the first (Region) dropdown using Reference Table: 

1. In the Data tab of the right panel for the region dropdown, use Source Type of Reference Table to make the options and returned values our list of regions (North, South, and West)
   Go to the Source Dropdown Options from a Data Table article for more detailed instructions on this step
   

Set up your second (Line Number) dropdown using query table:
In the Data tab of the right panel for the line number dropdown:

2. Source Type: Select “Query Table”
3. Query: Select your query name

1. If you have any input parameters, like we do in this example, you’ll see the PARAMETERS section appear at the bottom and list your input parameters

Map your input parameters: 

4. There will be a “+” button to the right of each input parameter. Use that to map each input parameter to the desired value. In our example, we’ll map the Region input parameter simply to the Region dropdown field (see the screenshot of the String Calculation below).
   
   Set Return, Sort By, and Display:
5. Return & Display: For Return, select the column from your table that holds the data you want to hold behind the scenes. For Display, select the column from your table that holds the values you want the form user to see. In this example, I want to select Region for both.
6. Sort By & Sort Order: For Sort By, select a column from your table that you want to use to sort the Display list. You can select the Sort Order as either ascending or descending.
   
   Preview to test it out:
7. Now if we go to Preview Mode, we’ll see that when you select a Region, the options for Line Number change appropriately.