public override IEnumerable <string> Query(JournalPageIdsFromSearch query)
{
var search = query.Search;
var searchTerms = search.SearchTerms;
if (!searchTerms.Any())
{
return(Enumerable.Empty <string>());
}
var queryOperator = search.MatchAny ? "OR" : "AND";
var likeOperator = search.MatchCase ? "GLOB" : "LIKE";
var wildcard = search.MatchCase ? "*" : "%";
var sql = string.Format("SELECT jp.Id FROM JOURNAL_PAGES jp {0}", whereCondition(searchTerms, queryOperator, likeOperator, wildcard));
return(Db.Query <string>(sql));
}
