GraphQL
Tutorial 4 - Challenge Answers

5min
In our Tutorial 4 challenge, we asked you to write a query which returned items matching multiple filter rules. Here's a possible solution.
Prerequisites
This Article shows the Answers to a Challenge. If you've not had a go at the challenge yet, we'd recommend you head there first.﻿
﻿About GraphQL- optional- Read more about GraphQL and when it might be best used.
Introduction
Last time, we asked you to write a single query which utilised a combination of filters to find recordswhich meet these criteria:
They are Module Items
They are enabled
They have already been released
They have not yet expired
They have a `weighting` between 1 and 3
They have a meta_title 
They fall into the posters Category

This challenge required you to modify and combine the queries we'd already looked at. If you were able to match at least some of the criteria, good work.
Challenge Answers
To find the category_id for the posters Category. One way to do it would have been to go to the Siteglide Admin: 
﻿

After that, it was a case of combining what you'd learned so far to add multiple filters to a query:
GraphQL
query webapps_missing_meta_descriptions {
  records(
    page: 1
    per_page: 2000
    filter: { 
      table: {starts_with: "module_"}
      properties: [
        { name: "meta_title", exists: true }
        { name: "enabled", value_boolean: true}
        { name: "release_date", range: { lte: "1582108820" }}
        { name: "expiry_date", range: { gt: "1582108820" }}
        { name: "weighting", range: { gte: "1", lte: "3" } }
        { name: "meta_title", exists: true }
        { name: "category_array", value_in: ["158197"] }
        
      ]
    }
  ) {
    total_pages
    results {
      table
      properties
    }
  }
}
query webapps_missing_meta_descriptions {
  records(
    page: 1
    per_page: 2000
    filter: { 
      table: {starts_with: "module_"}
      properties: [
        { name: "meta_title", exists: true }
        { name: "enabled", value_boolean: true}
        { name: "release_date", range: { lte: "1582108820" }}
        { name: "expiry_date", range: { gt: "1582108820" }}
        { name: "weighting", range: { gte: "1", lte: "3" } }
        { name: "meta_title", exists: true }
        { name: "category_array", value_in: ["158197"] }
        
      ]
    }
  ) {
    total_pages
    results {
      table
      properties
    }
  }
}
﻿
Notes:
For the range of weighting we've added a gte and lte setting, in order to demonstrate the possibility. This is not really necessary as there won't be values less than 0, but it's not a bad idea to rule these out, should data be entered incorrectly. 
The category_array  ID may be different from one site to another. Check your site's category_id in the Admin. 
Explorer:
Unfortunately, as mentioned last time, Explorer does not yet support arrays, so it's not possible to show an Explorer demo for this challenge. 
Next Time
It's time for the real thing! We'll look at how you can save your GraphQL query in a File and use Liquid to run it on a website Page.
Let's go!
Tutorial 4 - Advanced Filtering
Tutorial 5 - Using Liquid to run GraphQL queries on your Site