<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/dm/qry/dmqry0501m000" xml:lang="en">
   <Header>
      <Title>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>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>Object</Title>
         </Header>
         <FuncDesc>The name of the object.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="dmqry001.qrid">
         <Header>
            <Title>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>Query Description</Title>
         </Header>
         <FuncDesc>The description of a query.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="dmqry001.qtyp">
         <Header>
            <Title>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>User</Title>
         </Header>
         <FuncDesc>The creator of the query.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="dmqry001.crdt">
         <Header>
            <Title>Creation Date</Title>
         </Header>
         <FuncDesc>The creation date and time of the query.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="dmqry001.mdby">
         <Header>
            <Title>Modified By</Title>
         </Header>
         <FuncDesc>The name of the user who has modified the query.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="dmqry001.mddt">
         <Header>
            <Title>Modification Date</Title>
         </Header>
         <FuncDesc>The modification date and time of the query.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="dmqry001.sys">
         <Header>
            <Title>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>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>Previous Runs...</Title>
         </Header>
         <FuncDesc>Displays the previous runs of a query.</FuncDesc>
      </CommandHelp>
      <CommandHelp ID="exec.user.2">
         <Header>
            <Title>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>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>Browse</Title>
         </Header>
         <FuncDesc>Opens the history of the query.</FuncDesc>
      </CommandHelp>
      <CommandHelp ID="exec.user.5">
         <Header>
            <Title>Complex Query Conditions</Title>
         </Header>
         <FuncDesc>Enables you to specify the complex query conditions for a
		  query.</FuncDesc>
      </CommandHelp>
   </FormCommands>
</Session>