09-12-2011 07:10 AM
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
02-03-2012 12:03 PM
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><></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><></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><></OPTION>
<OPTION>" "</OPTION>
</SELECT></TD>
<TD><FONT SIZE=2>
<INPUT type="text" ALIGN="left" name="OBKey_PD_-_Report_Number_3" size='25'>
</TD
</TR>
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.