WHERE 1=1
<%= IFNOTNULL(":CATEGORY_COND", "AND Q_MASTER.COL_TQMASTERCATEGORYID = :CATEGORY_COND ") %>
<%= IFNOTNULL(":QUESTION", "AND (CASE WHEN UPPER (:COND_QUESTION) = UPPER('EXACTMATCH') AND Q_MASTER.COL_QUESTION =:QUESTION THEN 1 WHEN UPPER(:COND_QUESTION) = UPPER('WILDCARD') AND lower(Q_MASTER.COL_QUESTION) like( '%' || lower(:QUESTION) || '%') THEN 1 ELSE 0 END) = 1") %>
<%= IFNOTNULL(":DESCRIPTION", "AND lower(Q_MASTER.COL_DESCRIPTION) like( '%' || lower(:DESCRIPTION) || '%' )") %>
<%=Sort("@SORT@","@DIR@")%>