Filtering on terms
Filter rows returned by a CQL SELECT statement on terms using the Solr Standard Parser syntax.
The basic syntax to limit queries has the following syntax:
SELECT <column_list> FROM <table_name> WHERE solr_query = '<standard_term_expression> ...';
The Solr Standard Parser is a case-sensitive term search that supports boolean expressions with wildcards.
CQL for DSE Search also supports more complex searches using JSON-formatted query strings.
This section uses the Wikipedia Demo included in DataStax Enterprise.
Replace <standard_term_expression> with the
solr_query value from corresponding tables below to return the results:
SELECT count(*) FROM solr WHERE solr_query = '<q_search_expression>';
CQL Solr queries do not support native functions or column aliases as selectors.