<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/dm/qry/dmqry0502m000" xml:lang="en">
	<Header>
		<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Conditions (dmqry0502m000)</Title>
	</Header>
	<HelpTopic><AimSection><Paragraph>Use this session to specify the condition for processing a query. This session can be invoked in two ways:</Paragraph>
			<List><ListItem>From the SSA ODM <Link href="/baanerp/dm/onlinemanual/dmqry" role="manual">Queries and Reports</Link> menu</ListItem>
				<ListItem>From the <GUIRef href="" role="manual">Specific</GUIRef> menu in the <Link href="/baanerp/dm/qry/dmqry0501m000" role="session">Query (dmqry0501m000)</Link> session</ListItem>
			</List>
		</AimSection>
		<GeneralSection><Paragraph>To enter a new query condition, click <GUIRef href="" role="manual">New</GUIRef> on the <GUIRef href="" role="manual">File</GUIRef> menu, and enter the parameter values.</Paragraph>
			<Paragraph>You can also specify one or more query conditions for each query, using the query connectors <GUIRef href="" role="manual">And</GUIRef> or <GUIRef href="" role="manual">Or</GUIRef>.</Paragraph>
			<Paragraph>Each record in this session represents a condition on the query object for a specific query instance. Each query condition consists of a connector, an attribute, an operator, an optional system parameter, and a value. If the system parameter is selected, click the browse arrow to select the system parameter from the <Link href="/baanerp/dm/com/dmcom0125m000" role="session">System Parameters (dmcom0125m000)</Link> session.</Paragraph>
		</GeneralSection>
		<Note><SectionTitle>Note</SectionTitle>
			<Paragraph>Use the <GUIRef href="" role="manual">Group</GUIRef> command to change the object type and query, if required.</Paragraph>
		</Note>
	</HelpTopic>
	<Fields><FieldHelp ID="dmqry002.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 selected for the object type and the conditions for a query can be defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry002.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 which acts as identifier for the <Link href="/baanerp/dm/glossary/glossary#000039" role="glossary">query</Link>. The conditions are specified for the query selected here.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry002.join"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Connector</Title>
			</Header>
			<FuncDesc>The condition connector that represents the logical connection of a query condition with the earlier conditions.</FuncDesc>
			<Note><SectionTitle>Note</SectionTitle>
				<Paragraph>The first condition is blank by default. From the second condition connector onwards, the accepted values are either <GUIRef href="" role="manual">And</GUIRef> or <GUIRef href="" role="manual">Or</GUIRef>.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="dmqry002.cond"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Attribute</Title>
			</Header>
			<FuncDesc>The object attribute, which is the actual object of table field name. Attributes enable you to link the query conditions by using the two connectors, such as AND, OR. If the query object type is Change (CH), the object attribute must be cpid instead of dmchm011.cpid. You can either specify an attribute or click the browse arrow to select the field from the <GUIRef href="" role="manual">Table Fields (ttadv4529m000)</GUIRef> session. After you specify the object attribute, the attribute's description appears. To select an attribute you want to include in the condition, use the browse arrow in the Internal Name column, and select the required attribute.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="dmqry002.lopt"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Operator</Title>
			</Header>
			<FuncDesc>The logical operator quantifies the object attribute with a comparison operator. Select an operator from the drop-down list. The following table shows the usage of the available operators.</FuncDesc>
			<SimpleSection><TABLE border="1"><TBODY><TR><TD>Operator</TD>
							<TD>Syntax</TD>
							<TD>Int. / Long</TD>
							<TD>Float / Double</TD>
							<TD width="34">Enum</TD>
							<TD width="24">Date</TD>
							<TD>String</TD>
						</TR>
						<TR><TD>= / &lt;&gt;</TD>
							<TD>Single String</TD>
							<TD>Value</TD>
							<TD>Value</TD>
							<TD width="34">Enum Description</TD>
							<TD width="24">utc format</TD>
							<TD>Single String</TD>
						</TR>
						<TR><TD height="36">&gt; / &gt;=</TD>
							<TD height="36">Single String</TD>
							<TD height="36">Value</TD>
							<TD height="36">Value</TD>
							<TD width="34" height="36">Enum Description</TD>
							<TD width="24" height="36">utc format</TD>
							<TD height="36">Single String</TD>
						</TR>
						<TR><TD>&lt;/ &lt;=</TD>
							<TD>Single String</TD>
							<TD>Value</TD>
							<TD>Value</TD>
							<TD width="34">Enum Description</TD>
							<TD width="24">utc format</TD>
							<TD>Single String</TD>
						</TR>
						<TR><TD>IN / NOT IN</TD>
							<TD>X[,Y] [,Z] …</TD>
							<TD>Value</TD>
							<TD>Value</TD>
							<TD width="34">Enum Description</TD>
							<TD width="24">utc format</TD>
							<TD>Single String</TD>
						</TR>
						<TR><TD>BET / NOT BET</TD>
							<TD>X and Y</TD>
							<TD>Value</TD>
							<TD>Value</TD>
							<TD width="34">Enum Description</TD>
							<TD width="24">utc format</TD>
							<TD>Single String</TD>
						</TR>
						<TR><TD>LIKE / NOT LIKE</TD>
							<TD>String. *</TD>
							<TD>Not Valid</TD>
							<TD>Not Valid</TD>
							<TD width="34">Not Valid</TD>
							<TD width="24">Not Valid</TD>
							<TD>String.*</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph>Select an operator from the drop-down list in the operator column. A wide range of operators are available, for example, (Not) Equal, (Not) less than, (Not) like, &amp; (Not) in, and so on.</Paragraph>
				<Paragraph>Example "Release date &gt; 06091991".</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>Note</SectionTitle>
				<Paragraph>The term "Single String" defines a continuous string without any breaks or spaces. For the "LIKE" operator, the sample string must be followed by ".*". If the selected object attribute is based on an enumerated domain, the user must provide a valid enum description from the domain. For example, if the selected object attribute is based on the domain dmcom.ynin, a valid value is "Yes" or "No". To specify dates, click the browse arrow and select a date from the date calendar.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="dmqry002.spar"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">System Parameter</Title>
			</Header>
			<FuncDesc>If this check box is selected, you must fill the <GUIRef href="" role="manual">Value</GUIRef> field with the available values from the <Link href="/baanerp/dm/com/dmcom0125m000" role="session">System Parameters (dmcom0125m000)</Link> session .</FuncDesc>
			<SimpleSection><Paragraph>Example: User Login code, UTC date/time.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="dmqry002.valu"><Header>
				<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Value</Title>
			</Header>
			<FuncDesc>The value for the selected attribute.</FuncDesc>
			<Note><SectionTitle>Note</SectionTitle>
				<Paragraph>For the system parameter attribute, you must select the value from the <GUIRef href="/baanerp/dm/com/dmcom0125m000" role="session">System Parameters (dmcom0125m000)</GUIRef> session.</Paragraph>
				<Paragraph>For a date or enumeration attribute, you must select the browse arrow to specify the date from the date calendar.</Paragraph>
				<Paragraph>For a enumeration attribute, you must select the value from the Enumeration values of the attribute.</Paragraph>
			</Note>
		</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">Execute Query</Title>
			</Header>
			<FuncDesc>Runs the query based on the specified condition.</FuncDesc>
		</CommandHelp>
	</FormCommands>
</Session>
