flexiblesearch builder

Generates a valid FSQ so you don't have to remember the {pk} requirement, how enum filters actually work, or the catalog version subquery syntax.

Item type

Alias

Fields to select (comma-separated)

Include subtypes ({Type!})

Add catalog version filter

WHERE condition (optional)

ORDER BY (optional)

Limit

output

// fill in the form and click build query

{pk} is not optional — SELECT * doesn't exist in FlexibleSearch
Enum fields need a JOIN — WHERE {approvalStatus} = 'approved' will silently return wrong results; you need to join to {ArticleApprovalStatus}
UNION needs double braces on both sides: {{ SELECT ... }} UNION {{ SELECT ... }}
Collection and Map attributes can't go in a WHERE clause — write a Groovy script for those
{Product!} includes subtypes, {Product} doesn't — you usually want {Product!}
{p.name:o} forces a LEFT OUTER JOIN on the localized table — needed when the field can be null