Filtering the query results
Every query is built to retrieve a specific set of results.
When we define a query, the data can be processed and analyzed in several possible contexts:
- Time: This gives information about when an event occurred; for example, the sales for the current week (a "when" business question)
- Data type and specification: This gives the model specifications of the cars that were rented or sold (a "which" business question)
- Measure: This gives a range or a value that is greater or less than (a "how much" business question)
Without a filtering context, a query is somewhere between serving a meaningless purpose and answering a very general question. The main idea when creating query filters is to fetch only the data that is relevant ...