<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/100039" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">To use operators in filters</Title>
		<Keyword ContextSensitive="No"><Level1>Operators</Level1>
			<Level2></Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>Filter</Level1>
			<Level2></Level2>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">To search for specific records or groups of records you can use filters. You can specify one or more <Link href="/baanerp/tt/glossary/glossary#100006" role="glossary">expressions</Link> to search accurately for certain records.</Paragraph>
		<Note><SectionTitle>
                                 Note
                              </SectionTitle>
			<Paragraph class="Default">The examples used in this topic are based on the <Link href="/baanerp/tt/aad/ttaad2500m000" role="session">User Data (ttaad2500m000)</Link> session.</Paragraph>
		</Note>
		<GeneralSection><SectionTitle>Equal</SectionTitle>
			<Paragraph class="Default">Requires a complete expression.</Paragraph>
			<Paragraph class="Default">Example</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">Expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">=</TD>
						<TD rowspan="1" colspan="1">Ajohnson</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default">Only the record of the <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> user Ajohnson is displayed.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Larger or equal</SectionTitle>
			<Paragraph class="Default">You can specify a partial expression.</Paragraph>
			<Paragraph class="Default">Example</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">Expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">&gt;=</TD>
						<TD rowspan="1" colspan="1">W</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default"><GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> displays the following records: -All <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> users whose login starts with a w. -All <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> users in the database whose login starts with a letter that comes after W.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Smaller or equal</SectionTitle>
			<Paragraph class="Default">Can be used in the same way as the &gt;= operator, but the records displayed are descending in alphabetical order.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Larger</SectionTitle>
			<Paragraph class="Default">Has the same result as the &gt;= operator, except that the records that start with the specified expression are not displayed.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Smaller</SectionTitle>
			<Paragraph class="Default">Has the same result as the &lt;= operator, except that the records that start with the specified expression are not displayed.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Not equal</SectionTitle>
			<Paragraph class="Default">Requires a complete expression.</Paragraph>
			<Paragraph class="Default">Example</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">&lt;&gt;</TD>
						<TD rowspan="1" colspan="1">AJohnsson</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default">All records in the database are displayed, except the record of <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> user AJohnsson.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Like</SectionTitle>
			<Paragraph class="Default">Requires the use of wildcards</Paragraph>
			<Paragraph class="Default">Example</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">Like</TD>
						<TD rowspan="1" colspan="1">A.*</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default">The records that are displayed are of all <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> users whose login starts with A.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Not like</SectionTitle>
			<Paragraph class="Default">Requires the use of wildcards</Paragraph>
			<Paragraph class="Default">Example</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">Not like</TD>
						<TD rowspan="1" colspan="1">A.*</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default">The records that are displayed are of all <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> users whose login does not start with A.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>In</SectionTitle>
			<Paragraph class="Default">Requires complete expressions. The IN operator is meant to be used to select a number of records that are not in a sequence in the database. If you use the IN operator, you cannot use wildcards.</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">In</TD>
						<TD rowspan="1" colspan="1">Ajohnsson,Ksmith,Zjones</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default">Only the records of the users specified in the expression field are displayed.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Not in</SectionTitle>
			<Paragraph class="Default">See the IN operator. All the records in the database are displayed except the ones that you have specified in the expression field.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Between</SectionTitle>
			<Paragraph class="Default">You can start the query with partial expressions.</Paragraph>
			<Paragraph class="Default">Example</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Field Name</TD>
						<TD rowspan="1" colspan="1">Operator</TD>
						<TD rowspan="1" colspan="1">expression</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">User</TD>
						<TD rowspan="1" colspan="1">Between</TD>
						<TD rowspan="1" colspan="1">w and z</TD>
					</TR>
				</TBODY>
			</TABLE>
			<Paragraph class="Default">The records that are displayed are of <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> users whose login starts with w, z or any letter in between.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Not between</SectionTitle>
			<Paragraph class="Default">See the BETWEEN operator. All the records in the database are displayed, except the records in the range between the two expressions.</Paragraph>
		</GeneralSection>
	</GeneralSection>
</ManualTopic>
