DynamicReportFilterDetail Method

The DynamicReportFilterDetail method returns the detailed default filter syntax of a Dynamic Report.

The DynamicReportFilterDetail method is invoked using the MethodOperation.

Parameters

Name Type Description
reportId String Required. This is the object ID of the Dynamic Report.

Examples

The following example retrieves the detailed filter syntax for a report named "Clients With Children" whose object ID is DynReport.1.3.

Request XML
<request version='1.0'>
    <header>
        <office>myoffice</office>
        <user>jdoe</user>
        <password>password</password>
    </header>
    <method>
        <DynamicReportFilterDetail>
            <reportId>DynReport.1.3</reportId>
        </DynamicReportFilterDetail>
    </method>
</request>

Response XML
<?xml version="1.0" encoding="UTF-8" ?> 
<response version="1.0">
    <header>
        <sessionClosed /> 
    </header>
    <method>
        <DynamicReportFilterDetail>
            <![CDATA[
              <filter fltrkey="4">
                <element colName="Type" colid="65627" fltrkey="5" lookupId="5" sqldesc="Equal to" sqlop="eq" tableName="Contact" type="dtStr" uiValue="Client" value="Client"/>
                <element colName="# of Child" colid="589830" fltrkey="6" sqldesc="Greater Than" sqlop="gt" tableName="Personal" type="dtShort" uiValue="0" value="0"/>
              </filter>
            ]]>
        </DynamicReportFilterDetail> 
    </method>
    <_status>OK</_status> 
    <_systime>2016-04-28T19:23:34</_systime> 
    <!-- Cost 21 mill seconds. --> 
</response>

-- DinosLambropoulos - 28 Apr 2016
Topic revision: 28 Apr 2016, DinosLambropoulos
 

This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback