Page 1 of 1
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 6:06 am
by kamal.oulhadj
Hello,
In my search query I have the following filter:
Title like $ qpDoc_Title
By testing in advanced research, I have the following error:
Unknown Parametric Search Query operator or field `title '.
I do not know where it comes this error?
thanks
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 7:09 am
by John
It looks as if this is a Texis question. Field names are case sensitive, so check your query against the table.
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 9:45 am
by kamal.oulhadj
Hello,
I have the same error when I use "Title like $ qpDoc_Title" and "title like $ qpDoc_Title"
thanks
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 10:48 am
by mark
Try without the space after $
Title like $qpDoc_Title
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 11:14 am
by kamal.oulhadj
I have this query
Doc_Ref = $qpDoc_Ref and
Doc_Lang like $qpDoc_Lang and
Doc_Date>=$qpDoc_DateDebut and Doc_Date<=$qpDoc_DateFin and
( Doc_Title like $qpDoc_Title or Title like $qpDoc_Title ) and
Doc_Type like $qpDoc_Type and
Doc_SubType like $qpDoc_SubType and
Doc_Descriptors like $qpDoc_Descriptors and
Doc_Authors like $qpDoc_Authors and
Doc_ID_Session = $qpDoc_ID_Session and
Doc_ID_Commission =$qpDoc_ID_Commission
Without space after $, and I have always this error.
Thanks
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 11:45 am
by John
Just to confirm, which product are you using, and where is the query?
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 11:58 am
by kamal.oulhadj
Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32)
Scripts Version: 5.1.86
In Profile Search Settings, section Parametric Search Query ,SQL Query Clause
I use this SQL Query clause :
"Doc_Ref = $qpDoc_Ref and
Doc_Lang like $qpDoc_Lang and
Doc_Date>=$qpDoc_DateDebut and Doc_Date<=$qpDoc_DateFin and
( Doc_Title like $qpDoc_Title or Title like $qpDoc_Title ) and
Doc_Type like $qpDoc_Type and
Doc_SubType like $qpDoc_SubType and
Doc_Descriptors like $qpDoc_Descriptors and
Doc_Authors like $qpDoc_Authors and
Doc_ID_Session = $qpDoc_ID_Session and
Doc_ID_Commission =$qpDoc_ID_Commission "
Thanks
Unknown Parametric Search Query field or operator `Title'
Posted: Tue Mar 30, 2010 3:12 pm
by Kai
What are the data types for each of the Doc_... fields?