<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv3188m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Easy SQL Parameters (ttadv3188m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">In the <Link href="/baanerp/tt/adv/ttadv3580m000" role="session">Query Data (ttadv3580m000)</Link> session, you can generate a report based on an Easy SQL Query. If the COUNT function is used, the generated report contains a COUNT field with a domain of type long. This domain can be specified in this session.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">An example of a query with the function COUNT is:</Paragraph>
			<Paragraph class="Default">select count(tiitm001.item) from tiitm001</Paragraph>
			<Paragraph class="Default">The domain must be of type long.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You must use a package that is present in all package combinations. You can check this in the <GUIRef href="/baanerp/tt/aad/ttaad1121m000" role="session">Packages by Package Combination (ttaad1121m000)</GUIRef> session. When you generate a report in a package that has no integration with the package of the domain, <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> displays an error message.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/basictasks/000005" role="manual">To use a details session</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttadv383.cpac"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Count Domain</Title>
			</Header>
			<FuncDesc>Select a <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link>.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You must use a package that is present in all <Link href="/baanerp/tt/glossary/glossary#000000000000012" role="glossary">package combinations</Link>. You can check this in the <GUIRef href="/baanerp/tt/aad/ttaad1121m000" role="session">Packages by Package Combination (ttaad1121m000)</GUIRef> session. When you generate a report in a package that has no integration with the package of the domain, <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> displays an error message.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv383.cdom"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Count Domain</Title>
			</Header>
			<FuncDesc>Select a <Link href="/baanerp/tt/glossary/glossary#domain.tt" role="glossary">domain</Link>.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
