Custom Query sends AND Operator for two or more keywords associated with Search

[Sakhr_Mohammed]

Hello : i'm trying to create custom Query of "By kewword type"

I linked it to HTML Form and i included two keyword fileds , and in configuration i mapped the two keyowrds exactly in configuration now in client i turn Verbose on and when i search single keywod , i get "No Document Found" i open the verbose file .txt and see the query as following : select hsi.itemdata.itemnum, hsi.itemdata.itemname, hsi.itemdata.batchnum,
hsi.itemdata.status, hsi.itemdata.itemtypegroupnum, hsi.itemdata.itemtypenum,
hsi.itemdata.itrevnum, hsi.itemdata.itemdate, hsi.itemdata.datestored,
hsi.itemdata.usernum, hsi.itemdata.deleteusernum, hsi.itemdata.securityvalue,
hsi.itemdata.doctracenumber, hsi.itemdata.institution, hsi.itemdata.maxdocrev
from hsi.itemdata, hsi.keyitem131 ki0 , hsi.keyitem142 ki1
where ( hsi.itemdata.itemnum = ki0.itemnum and ( ki0.keyvaluechar = '%123%'
) ) and ( hsi.itemdata.itemnum = ki1.itemnum and ( ki1.keyvaluechar LIKE
'%123%' ) ) and hsi.itemdata.status + 0 = 0 my question is " is there any way to make onBase to send Query as OR instead of AND

[Lisa_Smith1]

This is how I was able to incorporate OR into my Custom Queries.

Thanks,  Lisa

<!-- REPORT NUMBER 1 -->

<TR>

<TD><FONT SIZE=2 ALIGN="left" nowrap><B>Report Number:</B></TD>

<TD><SELECT name="OBOperKey_PD_-_Report_Number_1">

<OPTION selected>=</OPTION>

<OPTION>&lt;&gt;</OPTION>

<OPTION>" "</OPTION>

</SELECT></TD>

<TD><FONT SIZE=2>

<INPUT type="text" ALIGN="left"  name="OBKey_PD_-_Report_Number_1"  size="25">

 OR </TD

</TR>

<!-- REPORT NUMBER 2 -->

<TR>

<TD><FONT SIZE=2 ALIGN="left" nowrap><B>Report Number:</B></TD>

<TD><SELECT name="OBOperKey_PD_-_Report_Number_2">

<OPTION selected>=</OPTION>

<OPTION>&lt;&gt;</OPTION>

<OPTION>" "</OPTION>

</SELECT></TD>

<TD><FONT SIZE=2>

<INPUT type="text" ALIGN="left"  name="OBKey_PD_-_Report_Number_2"  size='25'>

 OR </TD

</TR>

<!-- REPORT NUMBER 3 -->

<TR>

<TD><FONT SIZE=2 ALIGN="left" nowrap><B>Report Number:</B></TD>

<TD><SELECT name="OBOperKey_PD_-_Report_Number_3">

<OPTION selected>=</OPTION>

<OPTION>&lt;&gt;</OPTION>

<OPTION>" "</OPTION>

</SELECT></TD>

<TD><FONT SIZE=2>

<INPUT type="text" ALIGN="left"  name="OBKey_PD_-_Report_Number_3"  size='25'>

</TD

</TR>