Your First Spreadic Query

Querying your data using the Spreadic UI is easy.

Pick a cell in your sheet where you want to load your data into and call up the Spreadic UI. By default, the UI will be in the Tabular Data mode, which allows you to retrieve data from the underlying data table (a data table is also known as a “model” in Spreadic) by selecting the columns that you need:

1. Model: Select the model that you want to retrieve data from. To build your first query, it would be good to start with a model that you are familiar with. Once you have selected a model, you will see two new sections - Column and Filter - showing up in the UI.

2. Column: Click on Select column here, you can then choose from the dropdown menu of all the columns available in the model. Hit the ADD button to include the column in your query. Repeat this step until you have all the columns that you want under Selected Column(s).

3. Filter (Optional): This section controls how you want to limit your query. For example, you can limit your query to just customers registered in the past month, or you may want to look at only transactions over a certain amount. There are a lot of possibilities to explore. But as a first query, you can leave this section blank for now.

4. Ordering Item (Optional): This section is for sorting the data by one or more of the selected column (by ascending or descending order).

If you want to remove a selected column, simply click on the selected column to remove it from the list.

You're all set and can now hit FETCH DATA at the bottom of the UI to retrieve the data.

There you go! You have run your first Spreadic query successfully and you should now see a table of data expanding from the cell that you picked at the start (make sure you're leaving enough space for the data to load)!

If you click on the cell that you started with, you should see a Spreadic formula that looks just like an ordinary spreadsheet function (albeit with a lot of parameters). Don’t be too intimidated by the lengthy formula (you won’t have to write one from scratch!) - it could come in very handy later when you start exploring more.