Skip to main content

Developing in Cascade how to

Filtering queries based on multi-value fields

Using the query tool, you may need to filter on pages with specific checkbox or multi-select values. Filtering on these multi-value fields isn't possible in a single query, so this doesn't work as you'd hope:

Velocity 
$_.query().bySiteName("CascadeUniversity").byContentType("Page Types/News").hasStructuredData("details/is-featured", "Yes").execute()

Instead, run the broader query and use a conditional to filter the results:

Velocity 
#set ($list = $_.query().bySiteName("CascadeUniversity").byContentType("Page Types/News").execute())
#foreach ($page in $list)
  #if ($page.getStructuredData("details/is-featured").hasTextValue("Yes"))
    ...your code here...
  #end
#end