<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv9593m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Filters (ttadv9593m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to define, or edit filters. You can use the filters to display subsets of records in an overview session, and to define a sort order.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">To specify a sort order for the filtered records, click <GUIRef href="ttttadv993.sort" role="manual">Define Sort Order</GUIRef> on the <GUIRef href="" role="menu">Specific</GUIRef> menu.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The filters only apply to the records displayed in the session from which you started the <GUIRef href="/baanerp/tt/adv/ttadv9593m000" role="session">Filters (ttadv9593m000)</GUIRef> session.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/basictasks/000014" role="manual">Overview of filters</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/basictasks/000057" role="manual">To use filters</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields ID="ttadv993.valu"><FieldHelp ID="parent.prog.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Calling Session</Title>
			</Header>
			<FuncDesc>The session to which you can apply the filter.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv993.fltn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Filter Name</Title>
			</Header>
			<FuncDesc>The name that identifies the filter.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">When you apply the filter to the overview session, the name appears in the session's title bar.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="publish"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Publish Filter</Title>
			</Header>
			<FuncDesc>This field is only visible if you are logged on as a superuser. This field is hidden for normal users. If this check box is selected, (and the filter is saved), the filter will be available for all users.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The published filter appears, for all users, on the <GUIRef href="" role="manual">Filter</GUIRef> menu of the session to which the filter is linked. To open this menu, a user must click the <GUIRef href="" role="manual">Filter</GUIRef> command on the session's <GUIRef href="" role="manual">View</GUIRef> menu.</Paragraph>
				<Paragraph class="Default">If you clear this check box, and save the filter, the filter will no longer be public: the filter will only be available for the user who created the filter.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="field.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Name</Title>
			</Header>
			<FuncDesc>The field you use to filter the overview session's records.</FuncDesc>
			<SimpleSection><Paragraph class="Default">For a record to display in the overview session when you apply the filter, the record's data in this field must satisfy the <GUIRef href="ttttadv992.value" role="manual">Value</GUIRef> field by the operator you select in the <GUIRef href="ttttams345.autn" role="manual">Condition</GUIRef> field.</Paragraph>
				<Paragraph class="Default">If you define more than one field for a filter, the conditions combine to form an AND relation. That is, when you apply the filter, only records that satisfy all your filter's conditions will display in the overview session.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You can only select fields that are displayed in the overview session and the details session. For technical reasons, some fields displayed in these sessions might not be available in the pull-down list.</Paragraph>
				<Paragraph class="Default">If a field in the pull-down list does not belong to the session's main table, the table name is displayed between brackets.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv993.oper"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Condition</Title>
			</Header>
			<FuncDesc>The condition by which a record's data (entered in the <GUIRef href="/baanerp/tt/adv/ttadv3101s000#ttadv301.fldn" role="manual">Field Name</GUIRef> field) must satisfy the <GUIRef href="ttttadv992.value" role="manual">Value</GUIRef> field to be displayed in the overview session when you apply the filter.</FuncDesc>
			<SimpleSection><Paragraph class="Default"> 
                                    Allowed values:</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv993.valu"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Value</Title>
			</Header>
			<FuncDesc>The value a record's data (in the <GUIRef href="/baanerp/tt/adv/ttadv3101s000#ttadv301.fldn" role="manual">Field Name</GUIRef> field) must satisfy (by the operator you select in the <GUIRef href="ttttams345.autn" role="manual">Condition</GUIRef> field) to display in the overview session when you apply the filter.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>In the <GUIRef href="/baanerp/tt/adv/ttadv9593m000#ttadv993.zb_match" role="manual">Match Case</GUIRef> field, specify whether alphanumeric values are case sensitive.</ListItem>
					<ListItem>For enumerated fields (predefined values), you can press CTRL+B to select a value from a drop-down list.</ListItem>
					<ListItem>Lowercase characters have lower values than the equivalent uppercase characters.</ListItem>
					<ListItem>You can only use wildcard characters (.*) when you select <GUIRef href="/baanerp/tt/domains/adv.fopr#alfa.like" role="option">contains</GUIRef>, or <GUIRef href="/baanerp/tt/domains/adv.fopr#alfa.not_like" role="option">doesn't contain</GUIRef> in the <GUIRef href="ttttams345.autn" role="manual">Condition</GUIRef> field.</ListItem>
				</List>
			</Note>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/basictasks/000058" role="manual">Operators used in filters</Link>
				</RelTopic>
				<RelTopic><Link href="/baanerp/tt/onlinemanual/100103" role="manual">to use wildcard characters for filter values</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="ttadv993.zb_match"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Match Case</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the condition is case sensitive. For alphanumeric values, the condition is only met if the case, such as UPPERCASE, Title Case, Sentence case, lowercase, of the record data is identical to the case of the text specified in the <GUIRef href="/baanerp/tt/adv/ttadv9593m000#ttadv993.valu" role="manual">Value</GUIRef> field.</FuncDesc>
		</FieldHelp>
	</Fields>
	<FormCommands><CommandHelp ID="apply"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Apply</Title>
			</Header>
			<FuncDesc>Select this option to apply the filter to the overview session. If you close and restart the session the filter is not applied.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="select.filter"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Apply and Exit</Title>
			</Header>
			<FuncDesc>Select this option to apply the filter to the overview session, and exit the <GUIRef href="/baanerp/tt/adv/ttadv9593m000" role="session">Filters (ttadv9593m000)</GUIRef> session. If you close and restart the overview session, the filter is not applied.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="sort"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Define Sort Order</Title>
			</Header>
			<FuncDesc>Click to open the <Link href="/baanerp/tt/adv/ttadv9193m001" role="session">Define Sort Order (ttadv9193m001)</Link> session, which you use to define a sort order for your filter.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="set.default.filter"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Set as Default</Title>
			</Header>
			<FuncDesc>If you select this option (checked) when you start the overview session, the filter will be applied.</FuncDesc>
		</CommandHelp>
	</FormCommands>
</Session>
