<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/basictasks/000074" xml:lang="en">
   <Header>
      <Title>Easy filtering</Title>
      <Keyword type="header" order="d1e506871">
         <Level1>Overview session</Level1>
      </Keyword>
      <Keyword type="header" order="d1e506874">
         <Level1>Filter</Level1>
      </Keyword>
      <Keyword type="header" order="d1e506877">
         <Level1>Easy filtering</Level1>
      </Keyword>
   </Header>
   <GeneralSection ID="customize">
      <Paragraph>Easy filtering allows you to enter filter criteria on the column
		headings of an overview session.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>Easy filtering is available only in the WebTop client.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection ID="order.columns">
      <SectionTitle>To start easy filtering</SectionTitle>
      <Paragraph>To make easy filtering available, on the <GUIRef href="" role="manual" Update="No">View</GUIRef> menu, point to <GUIRef href="" role="manual" Update="No">Filter</GUIRef>,
		and then click <GUIRef href="" role="manual" Update="No">Easy Filtering</GUIRef>. Alternatively,
		click the <HTML:IMG xmlns:HTML="http://www.w3.org/TR/REC-html40" width="16" height="19"
                   SRC="../images/filter.gif"
                   alt="[...]"/> button. Filter fields appear in each column heading.</Paragraph>
      <Paragraph>If you activate <GUIRef href="" role="manual" Update="No">Instant Filtering</GUIRef>,
		the filtering criteria immediately take effect. If you deactivate <GUIRef href="" role="manual" Update="No">Instant Filtering</GUIRef>, the filtering criteria take
		effect after you leave the filter area.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>To define a filter</SectionTitle>
      <Paragraph>To define a filter on a column, enter a value in the filter
		field on the column heading. Optionally, you use filter operators in a filter
		value.</Paragraph>
      <ExampleSection>
         <SectionTitle>Example</SectionTitle>
         <Paragraph>The <GUIRef href="/baanerp/tc/com/tccom4530m000" role="session">Addresses (tccom4530m000)</GUIRef> session has a <GUIRef href="/baanerp/tc/com/tccom4530m000#tccom130.dsca" role="manual">City Description</GUIRef> field. If you enter <Code>Casablanca</Code> in this filter field, the session displays only the addresses with the <GUIRef href="/baanerp/tc/com/tccom4530m000#tccom130.dsca" role="manual">City Description</GUIRef> field "Casablanca".</Paragraph>
      </ExampleSection>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Operators in filter fields</SectionTitle>
      <GeneralSection>
         <SectionTitle>Fields with codes and textual values</SectionTitle>
         <Paragraph>On columns with codes and textual values, the filter selects
		  all records with values that start with the value of the filter field. This
		  selection is not case sensitive.</Paragraph>
         <ExampleSection>
            <SectionTitle>Example</SectionTitle>
            <Paragraph>If you enter <Code>c</Code> in the filter field for the <GUIRef href="/baanerp/tc/com/tccom4530m000#tccom130.dsca" role="manual">City Description</GUIRef> column, the session displays all records with a
			 value for the <GUIRef href="/baanerp/tc/com/tccom4530m000#tccom130.dsca" role="manual">City Description</GUIRef> field that starts with the letter C, such as,
			 Cairo, Canberra, Caracas, Chicago.</Paragraph>
         </ExampleSection>
         <GeneralSection>
            <SectionTitle>Wildcards</SectionTitle>
            <Paragraph>On columns with codes and textual values, you can use
			 filters with wildcards. You can use the following wildcard symbols:</Paragraph>
            <TABLE border="2" cellpadding="8" borderstyle="matrix"
                   space-and-orientation="indented-estimated">
               <TBODY noTR="2">
                  <TR no="1" isLast="false">
                     <TD valign="top" rowspan="1" colspan="1">?</TD>
                     <TD rowspan="1" colspan="1">Represents any character</TD>
                  </TR>
                  <TR no="2" isLast="true">
                     <TD valign="top" rowspan="1" colspan="1">*</TD>
                     <TD rowspan="1" colspan="1">Represents a series of arbitrary characters.</TD>
                  </TR>
               </TBODY>
            </TABLE>
            <ExampleSection>
               <SectionTitle>Example</SectionTitle>
               <Paragraph>The filter value <Code>TZ?03</Code> selects <Code>TZA03</Code>, <Code>TZB03</Code>, <Code>TZC03</Code>, and so on.</Paragraph>
               <Paragraph>The filter value <Code>A*B</Code> selects all values that start with <Code>A</Code>, followed by zero or more arbitrary characters, followed by <Code>B</Code>, (optionally followed by more characters).</Paragraph>
            </ExampleSection>
         </GeneralSection>
         <GeneralSection>
            <SectionTitle>The &gt; and &lt; operators</SectionTitle>
         </GeneralSection>
         <Paragraph>On columns with codes and textual values, you can use the
		  &gt;, &lt;, &lt;=, &gt;=, and &lt;&gt; operators. These operators are used as
		  follows:</Paragraph>
         <TABLE cellpadding="8" border="1" borderstyle="default"
                space-and-orientation="indented-estimated">
            <TBODY noTR="5">
               <TR no="1" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&gt;TEXT</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects values that come alphabetically after TEXT.</TD>
               </TR>
               <TR no="2" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&gt;=TEXT</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects the value TEXT and all values that come alphabetically
				  after TEXT.</TD>
               </TR>
               <TR no="3" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&lt;TEXT</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects values that come alphabetically before TEXT.</TD>
               </TR>
               <TR no="4" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&lt;=TEXT</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects the value TEXT and all values that come alphabetically
				  before TEXT.</TD>
               </TR>
               <TR no="5" isLast="true">
                  <TD rowspan="1" colspan="1">
                     <Code>&lt;&gt;TEXT</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects all values that do not start with TEXT.</TD>
               </TR>
            </TBODY>
         </TABLE>
         <Note>
            <SectionTitle>Note</SectionTitle>
            <Paragraph>Filter operations with these operators are case
			 sensitive.</Paragraph>
         </Note>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Fields with numeric values</SectionTitle>
         <Paragraph>On columns with numeric values, you can use the &gt;, &lt;,
		  &lt;=, &gt;=, and &lt;&gt; operators. These operators are used as follows:</Paragraph>
         <TABLE cellpadding="8" border="1" borderstyle="default"
                space-and-orientation="indented-estimated">
            <TBODY noTR="5">
               <TR no="1" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&gt;123.450</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects values that greater than 123.45.</TD>
               </TR>
               <TR no="2" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&gt;=123.450</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects values that greater than or equal to
				  123.45.</TD>
               </TR>
               <TR no="3" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&lt;123.450</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects values that less than 123.45.</TD>
               </TR>
               <TR no="4" isLast="false">
                  <TD rowspan="1" colspan="1">
                     <Code>&lt;=123.450</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects values that less than or equal to
				  123.45.</TD>
               </TR>
               <TR no="5" isLast="true">
                  <TD rowspan="1" colspan="1">
                     <Code>&lt;&gt;123.450</Code>
                  </TD>
                  <TD rowspan="1" colspan="1">Selects all values that are unequal to 123.45.</TD>
               </TR>
            </TBODY>
         </TABLE>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Fields with date values</SectionTitle>
         <Paragraph>Click the calendar icon, to open the calendar and select a
		  date.</Paragraph>
         <Paragraph>You can enter relative dates. For example, <Code>-7</Code> represents one week ago and <Code>+2</Code> represents the day after tomorrow.</Paragraph>
      </GeneralSection>
   </GeneralSection>
   <GeneralSection>
      <Paragraph>For more information, refer to the online Help of the Web UI,
		under <GUIRef href="" role="manual" Update="No">Working with Infor ERP</GUIRef>.</Paragraph>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/basictasks/000014" role="manual">Overview of filters</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>