How to Choose Boolean Operators Connections

4. How to Choose Boolean Operators Connections

In a SFgate form there are generally different Input boxes and they can be linked with boolean operators AND or OR.
The choice of the boolean operator to use could be made using a drop-down list exactly as for field description selection.
See the document How to perform a simple query?.

Forms created in languages different from English allow to use localized (national) Boolean operators.
At the moment the German, Franch, Italian, Dutch, Swedish, Spanish and Portoguese boolean operators are supported.
For example, Boolean operators of the Italian language are E and O.

Please note that sometimes boolean operators are not declared (they are hidden). There is a unique Boolean Operator that joins all the Input Boxes of the form.
If you want to see what is the boolean operator in this case, you should inspect the form source code and search for a tag like the one reported below:

<INPUT TYPE="hidden" NAME="tie" VALUE="and">

Example #1

This LIVE example allows only to select the boolean operator to connect fields.

Surname
Name

Here you can inspect the .fmt file, while the relevant part of this form source code is here:

<FORM METHOD=POST ACTION="/htbin/SFgate">
<INPUT NAME="database" TYPE="hidden" VALUE="local//usr/local/wais-sources/phonebook/phone">
<CENTER>
<TABLE BORDER WIDTH=70%>
 <TR><TH align=left>Surname</TH><TD><INPUT TYPE="text" NAME="surname" VALUE="salviati" SIZE=40></TD>
           <TD><SELECT NAME="name_tie">
                       <OPTION>and
                       <OPTION>or
                     </SELECT></TD></TR>
 <TR><TH align=left>Name</TH><TD><INPUT TYPE="text" NAME="name" VALUE="giovanni" SIZE=40></TD></TR>
</TABLE>
</CENTER>
<P>

<CENTER>
<TABLE>
<TR><TH><INPUT TYPE="submit" VALUE="Start Search">
</TH><TH> </TH><TH>
<INPUT TYPE="reset"  VALUE="Reset Query">
</TR></TABLE>
</CENTER>

<INPUT TYPE="hidden" NAME="tieinternal" VALUE="and">
<INPUT TYPE="hidden" NAME="application" VALUE="phone">
<INPUT TYPE="hidden" NAME="directget" VALUE="1">
<INPUT TYPE="hidden" NAME="convert" VALUE="Table">
</FORM>

Example #2

This LIVE example allows to select both the fields and the boolean operators. Try to use this form modifying only the boolean operator at the beginning. Then, on the basis of what you have back, try also to modify default terms of the Input Boxes.

Here you can inspect the .fmt file, while the relevant part of this form source code is here:

<FORM METHOD=POST ACTION="/htbin/SFgate">
<INPUT NAME="database" TYPE="hidden" VALUE="phone_attribute">

<CENTER>
 <TABLE BORDER WIDTH=70%>
   <TR><TD><SELECT NAME="fieldsel_1_description">
                  <OPTION SELECTED>Surname
                  <OPTION>Name
                  <OPTION>Department
                 </SELECT></TD>
          <TD><INPUT TYPE="text" NAME="fieldsel_1_content" VALUE="salviati" SIZE=40></TD>
 
          <TD><SELECT NAME="fieldsel_1_tie">
                   <OPTION>and
                   <OPTION>or
          </SELECT></TD></TR>

    <TR><TD><SELECT NAME="fieldsel_2_description">
                   <OPTION>Surname
                   <OPTION SELECTED>Name
                   <OPTION>Department
           </SELECT></TD>

          <TD><INPUT TYPE="text" NAME="fieldsel_2_content" VALUE="giovanni" SIZE=40></TD></TR>
 </TABLE>
</CENTER>

<INPUT TYPE="hidden" NAME="fieldsel_name_surname" VALUE="Surname">
<INPUT TYPE="hidden" NAME="fieldsel_name_name" VALUE="Name">
<INPUT TYPE="hidden" NAME="fieldsel_name_department" VALUE="Department">
<P>

<CENTER>
<TABLE>
<TR><TH><INPUT TYPE="submit" VALUE="Start Search">
</TH><TH> </TH><TH>
<INPUT TYPE="reset"  VALUE="Reset Query"></TR>
</TABLE>
</CENTER>

<INPUT TYPE="hidden" NAME="tieinternal" VALUE="and">
<INPUT TYPE="hidden" NAME="application" VALUE="phone">
<INPUT TYPE="hidden" NAME="directget" VALUE="1">
<INPUT TYPE="hidden" NAME="convert" VALUE="Table">
<INPUT TYPE="hidden" NAME="attributes" VALUE="1">
<INPUT TYPE="hidden" NAME="lattice" VALUE="phone_lattice">
</FORM>

Example #3

In this form you can choose the boolean operator connecting fields, while inside each field an OR connects the terms.

MODE OF INHERITANCE
Autosomal Dominant	X-linked Dominant	Polygenic
Autosomal Recessive	X-linked Recessive	Unknown
Mitochondrial

RANGE OF FREQUENCY IMPAIRMENT
Low	High	Mid+High	Extended High
Mid	Low+Mid	Low+High	All Frequencies

Low: < 500Hz	High: > 2000Hz and =< 8000Hz
Mid: 500 - 2000Hz	Extended High: > 8000Hz

Here you can inspect the .fmt file, while the relevant part of this form source code is here:

<FORM METHOD=POST ACTION="/htbin/SFgate">
<INPUT NAME="database" TYPE="hidden" VALUE="local//usr/local/wais-sources/tutorial/audio">

<CENTER>
<TABLE BORDER>
   <TR><TH> </TH><TH>
              <TABLE BORDER WIDTH="100%">
                <TR><TH ALIGN=center COLSPAN=3>MODE OF INHERITANCE</TH></TR>
                    <TR><TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="dominant"> 
                                    Autosomal Dominant</TD>
                        <TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="x-linked_dominant" CHECKED>
                                     X-linked Dominant</TD>
                        <TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="polygenic">
                                      Polygenic</TD></TR>
                     <TR><TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="recessive"> 
                                      Autosomal Recessive</TD>
                         <TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="x-linked_recessive"> 
                                       X-linked Recessive</TD>
                         <TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="unknown"> 
                                       Unknown</TD></TR>
                      <TR><TD><INPUT TYPE="checkbox" NAME="inheritance_content" VALUE="mitochondrial">
                                       Mitochondrial</TD></TR>
                </TABLE>
         </TH></TR>
<TR><TD>
    <SELECT NAME="freqimpair_tie">
            <OPTION>and
            <OPTION>or
    </SELECT>
</TD></TR>
<TR><TH> </TH><TH>

                 <TABLE BORDER WIDTH=100%>
                    <TR><TH ALIGN=center COLSPAN=4>RANGE OF FREQUENCY IMPAIRMENT</TH></TR>
                        <TR><TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="low" CHECKED> 
                                             Low</TD>
                            <TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="high"> 
                                             High</TD>
                            <TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="mid+high"> 
                                             Mid+High</TD>
                            <TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="extended_high"> 
                                             Extended High</TD></TR>
                         <TR><TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="mid"> 
                                             Mid</TD>
                             <TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="low+mid"> 
                                             Low+Mid</TD>
                             <TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="low+high"> 
                                             Low+High</TD>
                             <TD><INPUT TYPE="checkbox" NAME="freqimpair_content" VALUE="frequencies"> 
                                             All Frequencies</TD></TR>
                 </TABLE>
             </TH></TR>
        <TR><TH> </TH><TH>

                 <TABLE WIDTH=100%>
                        <TR><TD WIDTH=50%><B>Low:</B> &lt; 500Hz</TD><TD><B>High:</B> &gt; 2000Hz and =&lt; 8000Hz</TD></TR>
                        <TR><TD WIDTH=50%><B>Mid:</B> 500 - 2000Hz</TD><TD><B>Extended High:</B> &gt; 8000Hz </TD></TR>
                 </TABLE>
</TH></TR>
</TABLE>
</CENTER>
<P>

<CENTER>
<TABLE>
<TR><TH><INPUT TYPE="submit" VALUE="Start Search">
</TH><TH> </TH><TH>
<INPUT TYPE="reset"  VALUE="Reset Query"></TR>
</TABLE>
</CENTER>

<INPUT TYPE="hidden" NAME="tieinternal" VALUE="or">
<INPUT TYPE="hidden" NAME="listenv" VALUE="table">
<INPUT TYPE="hidden" NAME="range" VALUE="1">
<INPUT TYPE="hidden" NAME="convert" VALUE="Table">
<INPUT TYPE="hidden" NAME="maxhits" VALUE="30">
<INPUT TYPE="hidden" NAME="directget" VALUE="1">
</FORM>

THIS PAGE REFERENCES:
© 1996-97 BioPD - University of Padova - Author: Leopoldo Saggin
Mail to: lsaggin@civ.bio.unipd.it - Last Revision: August 21, 1997
Tested on Netscape 1.22 and higher