There are two types of queries in Alka: Filter Queries and Display Queries. A Filter Query is a search function that filters specific fields in a table (basically, the data you want to be shown). You can construct filter queries that search for specific numbers, dates, words or booleans among the fields available to a table.
The second type of query is a Display Query which configures how data and information are displayed. With a Display Query you can hide/show relevant fields, group/sort data, or alter the mode in which the data is displayed (ie. traditional table vs chart).
<aside> 💡 Figure 1.1 - A view of the transactions table in Alka set by the Display Query and a Filter Query applied showing transactions with amounts greater than 1000.
</aside>
The table above is relevant to both display queries and filter queries. Use this table as a reference to see what types of tables are available and the fields that can be queried within each table.
How are tables and field names relevant? With a display query you can select one of the table types listed above and you may configure it to display it's fields in the way that you want it to be displayed. Any number of a table's corresponding fields can be shown or hidden. A filter query will filter out irrelevant data to the selected table type using fields available to the table.
Let's start out by showing a display query below in figure 2.1. Here we have the table for transactions selected so it is going to list all available transactions. The mode in which to view this data is currently shown as a standard table.
The display query to make this happen is "table:transactions mode:table". The View drop down to the right of the display query input field can be selected to alter the queries through a user interface rather than a manual display query.
<aside> 💡 Figure 2.1 - A display query showing the transactions table has been selected and the viewing mode is a table
</aside>
Now we can see the same table of transactions shown with a different display mode. The display query shows "mode:report". By using display queries we can alter the way in which the data is shown.
