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,
