We have a database table with several fields we are searching through Thunderstone with the SOAP interface.
One of the fields, named list_typ, contains a list of values that are delimited with semi-colon, like this: "02;03;08;10;11".
We want to allow users to select one or more values to search for in this field (for example, find any rows containing 8 or 10) in addition to their keyword query, if they want.
On the Search Settings for this profile, I have this in the Parametric Search Query: list_typ LIKE $qpList_Typ
I have a problem whenever I submit a soap request that includes more than one parameter for this field, like this:
<ns:Param name="qplist_typ">08</ns:Param>
<ns:Param name="qplist_typ">10</ns:Param>
The system searches against '08' just fine, but ignores the '10' in the search, and displays this message about it:
Skipping additional values for qpList_Typ: Previous operator/token `like' may not support multiple values.
Is there another way to accomplish this? Do we need different delimiters in the source data field, or use a different operator in the SQL?
One of the fields, named list_typ, contains a list of values that are delimited with semi-colon, like this: "02;03;08;10;11".
We want to allow users to select one or more values to search for in this field (for example, find any rows containing 8 or 10) in addition to their keyword query, if they want.
On the Search Settings for this profile, I have this in the Parametric Search Query: list_typ LIKE $qpList_Typ
I have a problem whenever I submit a soap request that includes more than one parameter for this field, like this:
<ns:Param name="qplist_typ">08</ns:Param>
<ns:Param name="qplist_typ">10</ns:Param>
The system searches against '08' just fine, but ignores the '10' in the search, and displays this message about it:
Skipping additional values for qpList_Typ: Previous operator/token `like' may not support multiple values.
Is there another way to accomplish this? Do we need different delimiters in the source data field, or use a different operator in the SQL?