Query Options

You can specify in the query some of the options that you can set in the information design tool.

The query specification model defines query options by using the <queryOption> XML element.

<queryOptions>
    <queryOption name="string" activated="true|false" value="string"/>
Remember An option that is not present explicitly in the specification is not validated.
<queryOption> Attribute Description
name The option name
activated The option does not apply if activated is false. Is optional. If not present, the option is activated.
value The option value
name Attribute Value Description
duplicatedRows If true, the query returns all related rows, even if there are duplicated rows.
maxRetrievalTimeInSeconds It defines the maximum time that a query can run before the query is stopped.
maxRowsRetrieved If true, the query returns all the possible rows, but only displays the first n rows,where n is the maximum number of rows set for this option.

If the user only needs a certain amount of data, you can set this option to restrict the number of rows of data displayed in reports.

samplingResultSetSize It defines the maximum number of rows that a query returns as a sample.
samplingResultSetFixed It defines the type of sampling used. Option values are true for fixed sampling and false for random.
Remember samplingResultSetSize can be set without samplingResultSetFixed. In that case, the type of sampling is random.

See the Information Design Tool User Guide for more information about these options.

Example

The following snippet of a query specification shows the query options.

<query xmlns="http://www.sap.com/rws/sl/universe" id="589789982204141561 dataSourceType="unx" 
    dataSourceId="5808">
    <querySpecification version="1.0">
        <queryOptions>
            <queryOption name="duplicatedRows" value="true"/>
            <queryOption name="maxRetrievalTimeInSeconds" activated="false" value="600"/>
            <queryOption name="maxRowsRetrieved" activated="true" value="5000"/>
            <queryOption name="samplingResultSetSize" activated="false" value="200">
            <queryOption name="samplingResultSetFixed" activated="false" value="false">
        </queryOptions>
        ...
    </querySpecification>
</query>