<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/dm/qry/dmqry0501m000" xml:lang="en">
	<Header>
		<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Query (dmqry0501m000)</Title>
	</Header>
	<HelpTopic><AimSection><Paragraph>Use this session to create, edit, print, or view a query. Each query depends on an object defined in ODM. This session enables you to select the object and create a new query for that object. By default, a query string is created for each query. The user can run the query at this stage. Adding object attributes and qualifying them with conditions enhances the query mechanism. All these conditions act as a constraint for that particular query on that object. If you run the query, the results of the objects that satisfy the constraints already given by the user appear.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph>Queries can be of the following types:</Paragraph>
			<List><ListItem><GUIRef href="" role="manual">Base Query</GUIRef>: The default setting. The base queries run directly on the object on which the query is defined. The results are filtered on the conditions specified</ListItem>
				<ListItem><GUIRef href="" role="manual">Previous Query</GUIRef>: You can also run a query on one of the query's previous runs. To run a query on the previous run, set the query type to previous query. If you run the query, the user is prompted to select a previous run of the query, which is treated as the input for the current execution.</ListItem>
				<ListItem><GUIRef href="" role="manual">Linked Query</GUIRef>: Two or more queries can be linked and executed together. To achieve this, you can make the type a linked query. You can define linked queries in the <Link href="/baanerp/dm/qry/dmqry0507m000" role="session">Complex Conditions (dmqry0507m000)</Link> session.</ListItem>
			</List>
			<Paragraph>In the <Link href="/baanerp/dm/qry/dmqry0501m000" role="session">Query (dmqry0501m000)</Link> session, you can group queries by an object. Click <GUIRef href="" role="manual">Group</GUIRef> to browse the required object. You can also enter an <Link href="/baanerp/dm/glossary/glossary#000063" role="glossary">object</Link> directly by selecting <GUIRef href="" role="manual">New</GUIRef> from the <GUIRef href="" role="manual">Group</GUIRef> menu. To create a new query, click <GUIRef href="" role="manual">New</GUIRef> from the <GUIRef href="" role="manual">File</GUIRef> menu.</Paragraph>
			<Paragraph>Specific menu options:</Paragraph>
			<List><ListItem><Link href="/baanerp/dm/qry/dmqry0502m000" role="session">Query Conditions (dmqry0502m000)</Link>: Enables you to define the conditions of the query.</ListItem>
				<ListItem><GUIRef href="" role="manual">Run Query</GUIRef>: Enables you to run the query.</ListItem>
				<ListItem><Link href="/baanerp/dm/qry/dmqry0503m000" role="session">Previous Runs (dmqry0503m000)</Link>: Enables you to display the previous query runs for a query.</ListItem>
				<ListItem><GUIRef href="" role="manual">Browser</GUIRef>: Enables you to open a tree browser that graphically displays the attributes of the query.</ListItem>
			</List>
			<Paragraph>When you run a query, you must store the result set. If you click <GUIRef href="" role="manual">Yes</GUIRef>, the query results are stored and can be retrieved at any point in time. After the query run is complete, you can view the results.</Paragraph>
			<List><ListItem><GUIRef href="" role="manual">Display</GUIRef>: Displays the results in the <Link href="/baanerp/dm/qry/dmqry0506m000" role="session">Query Instance Links (dmqry0506m000)</Link> session.</ListItem>
				<ListItem><GUIRef href="" role="manual">Report</GUIRef>: Displays the <Link href="/baanerp/dm/com/dmcom0124m000" role="session">Reports Repository (dmcom0124m000)</Link> of the main query object type with the <GUIRef href="" role="manual">Query</GUIRef> field and with the current query.</ListItem>
				<ListItem><GUIRef href="" role="manual">Native Session</GUIRef>: Displays the results in the main session of the main query object. The session is filtered based on the query result set.</ListItem>
				<ListItem><GUIRef href="" role="manual">Display Summary</GUIRef>: Displays the run number and the number of records retrieved for the condition.</ListItem>
				<ListItem><GUIRef href="" role="manual">Cancel</GUIRef>: If you click this option, the dialog box closes.</ListItem>
				<ListItem><GUIRef href="" role="manual">Native Session</GUIRef>: Displays the main session of the object type on which the query is based.</ListItem>
			</List>
		</GeneralSection>
		<RelatedTopics><SectionTitle>Related topics</SectionTitle>
			<RelTopic><Link href="/baanerp/dm/qry/dmqry0507m000" role="session">Complex Conditions (dmqry0507m000)</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/dm/qry/dmqry0502m000" role="session">Query Conditions (dmqry0502m000)</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/dm/qry/dmqry0503m000" role="session">Previous Runs (dmqry0503m000)</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/dm/sys/dmsys0100m000" role="session">Common ODM Parameters (dmsys0100m000)</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/dm/com/dmcomobjbrows" role="session">Object Browsing (dmcomobjbrows)</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="dmqry001.objt"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Object</Title>
			</Header>
			<FuncDesc>The object ID that acts as an identifier. The query instance is defined for the object.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmsys111.odsc"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Object</Title>
			</Header>
			<FuncDesc>The name of the object.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.qrid"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Query</Title>
			</Header>
			<FuncDesc>The query ID that acts as the identifier. If object masks have been configured for queries, the query Identifier field is generated automatically according to the mask.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.desc"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Description</Title>
			</Header>
			<FuncDesc>The description of a query.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.qtyp"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Type</Title>
			</Header>
			<FuncDesc>The types of query. Query can be of the following types:</FuncDesc>
			<SimpleSection><List><ListItem><GUIRef href="" role="manual">Base</GUIRef>: This query is an independent query that is performed for specific query conditions defined for a query.</ListItem>
					<ListItem><GUIRef href="" role="manual">Linked</GUIRef>: This query has a reference to another base query.</ListItem>
					<ListItem><GUIRef href="" role="manual">Previous</GUIRef>: The previous option is shown only if the query has any previous runs. If the query is made to be previous, the next run on the query must be on the data retrieved by the selected previous run from the run time window that appears during a query execution.</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="dmqry001.crby"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">User</Title>
			</Header>
			<FuncDesc>The creator of the query.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.crdt"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Creation Date</Title>
			</Header>
			<FuncDesc>The creation date and time of the query.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.mdby"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Modified By</Title>
			</Header>
			<FuncDesc>The name of the user who has modified the query.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.mddt"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Modification Date</Title>
			</Header>
			<FuncDesc>The modification date and time of the query.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry001.sys"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">System Defined</Title>
			</Header>
			<FuncDesc>This is a special option available to define confidential or reusable queries. Marking of this value to true makes the query a system query. Only users with proper authorizations can modify or delete the system queries.</FuncDesc>
		</FieldHelp>
	</Fields>
	<FormCommands><CommandHelp ID="exec.user.0"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Conditions...</Title>
			</Header>
			<FuncDesc>Defines the conditions of a <Link href="/baanerp/dm/glossary/glossary#000039" role="glossary">query</Link>.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="exec.user.1"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Previous Runs...</Title>
			</Header>
			<FuncDesc>Displays the previous runs of a query.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="exec.user.2"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Execute Query</Title>
			</Header>
			<FuncDesc>Executes the selected query. On execution, the query results can either be stored or viewed.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="exec.user.3"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Native Session</Title>
			</Header>
			<FuncDesc>Opens the native session on which the current query is based. The records of the native session are filtered based on the conditions specified for the query.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="exec.user.4"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Browse</Title>
			</Header>
			<FuncDesc>Opens the history of the query.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="exec.user.5"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Complex Query Conditions</Title>
			</Header>
			<FuncDesc>Enables you to specify the complex query conditions for a query.</FuncDesc>
		</CommandHelp>
	</FormCommands>
</Session>
