<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv3586m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Table Fields (ttadv3586m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">This session lists the query table fields that you can select for use in a query chart. To select query table fields, either zoom from the <GUIRef href="" role="manual">Category Column</GUIRef> field, or the Data II Column field in the <Link href="/baanerp/tt/adv/ttadv3185s000" role="session">Query Chart Data (ttadv3185s000)</Link> session.</Paragraph>
		</AimSection>
		<GeneralSection><Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You must first define these query fields in the <Link href="/baanerp/tt/adv/ttadv3580m000" role="session">Query Data (ttadv3580m000)</Link> session.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/tt/onlinemanual/100036" role="manual">To add query table fields to a chart</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttadv382.fild"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Field</Title>
			</Header>
			<FuncDesc>The table field code.</FuncDesc>
			<SimpleSection><List><ListIntro>A table field is identified by its unique combination of:</ListIntro>
					<ListItem><Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">Package</Link> code</ListItem>
					<ListItem><Link href="/baanerp/tt/glossary/glossary#100004" role="glossary">Module</Link> code</ListItem>
					<ListItem>Table code</ListItem>
					<ListItem>Field name</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv382.bvar"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Bind.Var.</Title>
			</Header>
			<FuncDesc>If you want to use several functions on the same (non-repeating) table field, you must bind these functions in the text editor. To do this, postfix the functions with a colon and a binding-variable. The binding-variable must be of the form int0..int9 or float0..float9. The int variable displays the result of the function as an integer value, while float displays the result as a floating point number. This means that you cannot use this construction in non-numeric fields.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">select</Paragraph>
				<Paragraph class="Default">ttaad220.user, min(ttaad220.comp):int0, max(ttaad220.comp):int1</Paragraph>
				<Paragraph class="Default">from</Paragraph>
				<Paragraph class="Default">ttaad220</Paragraph>
				<Paragraph class="Default">group by</Paragraph>
				<Paragraph class="Default">ttaad220.user</Paragraph>
				<Paragraph class="Default">As output, the query produces a list of users, with the lowest and the highest company numbers they are authorized for.</Paragraph>
			</SimpleSection>
		</FieldHelp>
	</Fields>
</Session>
