Combined Custom Filters

In the query specification model, comparison filters can be combined using the AND and OR logical operators. These operators are defined using the <and> and <or> XML elements.

Example

The following snippet of a query specification shows the combination AND of two comparison filters.

<query xmlns="http://www.sap.com/rws/sl/universe" id="5897899822041415615" dataSourceType="unx" 
    dataSourceId="5808">
    <querySpecification version="1.0">
        <queryOptions>
            ...
        </queryOptions>
        <queryData>
            <resultObjects>
                <resultObject path="Customer|folder\Geography|folder\Country|dimension"
                    id="_IBo8NrIhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Customer|folder\Customer|dimension"
                    id="_IBo8OrIhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Customer Satisfaction|folder\Satisfaction Index|measure"
                    id="_IBytE7IhEeCk0Ylv-tlF2Q"/>
            </resultObjects>
            <filterPart>
                <and>
                    <comparisonFilter path="Time|folder\Calendar|folder\Calendar Year Month
                        |dimension" operator="EqualTo" id="_IBo8G7IhEeCk0Ylv-tlF2Q">
                        <constantOperand>
                            <answerValue>CY2011-M10</answerValue>
                        </constantOperand>
                    </comparisonFilter>
                    <comparisonFilter path="Customer|folder\Geography|folder\Continent|dimension" 
                        operator="EqualTo" id="_IBo8M7IhEeCk0Ylv-tlF2Q">
                        <constantOperand>
                            <answerValue>Europe</answerValue>
                         </constantOperand>
                    </comparisonFilter>
                </and>
            </filterPart>
        </queryData>
    </querySpecification>
</query>