Tutorial 3 - Answers to the First Filtering Challenge
We look at a possible answer to Tutorial 3's challenge. This shows how to write a query which fetches all WebApp items, not Module items.
The trick here was to examine the tablesand spot the common patterns in their values.
The two types of recordswe wanted had these tables beginning with "webapp_":
The types of records we don't want have table values without "webapp_", for example:
- module_3 - (Blog Module)
- module_14 - (eCommerce Module)
- form_1 - Newsletter Sign Up Form Submissions
So, in order to filter for the recordswe do want and not the recordswe don't want, we need recordswhich start with the string webapp_. Code:
- In this method, there is no need to write one filter to include webapp items and another to remove module and form items from the Results. This is because the given rule efficiently achieves both at once.
This is just one possible answer, you may have found a different method.
Try and make sure you choose the best method for your use case. You should always be looking out for a more efficient way of doing things.
We'll continue to look at filtering queries in more detail, including:
- filtering by different fields, or properties
- filtering with different kinds of rules
- using more than one filter at once