<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/basictasks/000059" xml:lang="en">
   <Header>
      <Title>Examples of conditions in filters</Title>
      <Keyword type="header" order="d1e473443">
         <Level1>Filters</Level1>
         <Level2>conditions</Level2>
      </Keyword>
   </Header>
   <GeneralSection>
      <Paragraph>In the following examples, the displayed addresses are the
		records that are displayed in the overview session if you apply the filter.</Paragraph>
      <TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated">
         <TBODY noTR="17">
            <TR no="1" isLast="false">
               <TH rowspan="1" colspan="1">Session</TH>
               <TD colspan="2" rowspan="1">Addresses (tccom4530m000)</TD>
            </TR>
            <TR no="2" isLast="false">
               <TH rowspan="1" colspan="1">Field Name</TH>
               <TD colspan="2" rowspan="1">ZIP Code/Postal Code</TD>
            </TR>
            <TR no="3" isLast="false">
               <TH rowspan="1" colspan="1">Condition</TH>
               <TH style="width:7em;" rowspan="1" colspan="1">Value</TH>
               <TH rowspan="1" colspan="1">Displayed addresses are all the addresses of which the postal
				code:</TH>
            </TR>
            <TR no="4" isLast="false">
               <TD rowspan="1" colspan="1">is (exactly)</TD>
               <TD rowspan="1" colspan="1">7330 AC</TD>
               <TD rowspan="1" colspan="1">is 7330 AC</TD>
            </TR>
            <TR no="5" isLast="false">
               <TD rowspan="1" colspan="1">equals or after</TD>
               <TD rowspan="1" colspan="1">7300 AA</TD>
               <TD rowspan="1" colspan="1">is 7300 AA or greater</TD>
            </TR>
            <TR no="6" isLast="false">
               <TD rowspan="1" colspan="1">equals or before</TD>
               <TD rowspan="1" colspan="1">7999 ZZ</TD>
               <TD rowspan="1" colspan="1">is 7999 ZZ or less</TD>
            </TR>
            <TR no="7" isLast="false">
               <TD rowspan="1" colspan="1">is after</TD>
               <TD rowspan="1" colspan="1">7330 AC</TD>
               <TD rowspan="1" colspan="1">is greater than 7330 AC</TD>
            </TR>
            <TR no="8" isLast="false">
               <TD rowspan="1" colspan="1">is before</TD>
               <TD rowspan="1" colspan="1">7330 AC</TD>
               <TD rowspan="1" colspan="1">is less than 7330 AC</TD>
            </TR>
            <TR no="9" isLast="false">
               <TD rowspan="1" colspan="1">is not</TD>
               <TD rowspan="1" colspan="1">7330 AC</TD>
               <TD rowspan="1" colspan="1">is different from 7330 AC</TD>
            </TR>
            <TR no="10" isLast="false">
               <TD rowspan="3" colspan="1">in</TD>
               <TD rowspan="1" colspan="1">7330 AC,</TD>
               <TD rowspan="3" colspan="1">is 7330 AC, 7335 KB, or 7364 ML</TD>
            </TR>
            <TR no="11" isLast="false">
               <TD rowspan="1" colspan="1">7335 KB,</TD>
            </TR>
            <TR no="12" isLast="false">
               <TD rowspan="1" colspan="1">7364 ML</TD>
            </TR>
            <TR no="13" isLast="false">
               <TD rowspan="3" colspan="1">not in</TD>
               <TD rowspan="1" colspan="1">7330 AC,</TD>
               <TD rowspan="3" colspan="1">is not 7330 AC, 7335 KB, or 7364 ML</TD>
            </TR>
            <TR no="14" isLast="false">
               <TD rowspan="1" colspan="1">7335 KB,</TD>
            </TR>
            <TR no="15" isLast="false">
               <TD rowspan="1" colspan="1">7364 ML</TD>
            </TR>
            <TR no="16" isLast="false">
               <TD rowspan="1" colspan="1">contains</TD>
               <TD rowspan="1" colspan="1">AA</TD>
               <TD rowspan="1" colspan="1">contains AA</TD>
            </TR>
            <TR no="17" isLast="true">
               <TD rowspan="1" colspan="1">doesn't contain</TD>
               <TD rowspan="1" colspan="1">AA</TD>
               <TD rowspan="1" colspan="1">does not contain AA</TD>
            </TR>
         </TBODY>
      </TABLE>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/basictasks/000014" role="manual">Overview of filters</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/basictasks/000058" role="manual">Operators used in filters</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>