Error in Search Template Query in TaskSpace!

mitesh
edited January 31, 2009 in Documentum #1

Hello All,

I am trying to use following query in Search Template,

SELECT approver,doc_channel,funding_date,funding_amount,loan_number,requestor,transact
ion_type FROM tcs_fna_document WHERE[b] (LOWER(approver) = LOWER('$ApproverName$')) OR (LOWER(doc_channel) = LOWER('$Channel$'))[/b] ENABLE (FETCH_ALL_RESULTS 501, RETURN_TOP 500)

('$ApproverName$')  &  ('$Channel$') are 2 controls on my Search Template.

Problem :
Getting the query results in Form Builder & First time in TaskSpace search Tab , problem starts when I enter some values in controls & click on Search button

Getting Error like : A query Error has occurred.

Question:
1)Is this query correct for getting control values in search where condition ?

Can some let me know , what query should I use to get correct result based on control values entered in search Tab.

Thanks,