PrxMetaSheetAutoFilter

Syntax

bool PrxMetaSheetAutoFilter(string mon)

Parameters

mon. Regular report sheet moniker.

Description

The PrxMetaSheetAutoFilter operation enables or disables autofilter on a regular report sheet.

Comments

Before executing the operation, select any cell range with data in the table. To change the selected range, use the SetTabSheetData operation.

To execute the PrxMetaSheetAutoFilter operation, in the mon field specify moniker in the following format: Regular report instance moniker!Sheets!Sheet key. Repeated call disables the autofilter. Moniker of regular report instance can be obtained on executing the OpenPrxMeta operation.

The operation results in the logical True if autofilter can be changed, and False if autofilter cannot be enabled for some reason.

Example

Below is the example of enabling autofilter on a regular report sheet. The request contain sheet moniker. The response contains whether autofilter is successfully enabled.

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<PrxMetaSheetAutoFilter xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">AHJKEIMPCFKNFOAELIJIBPGEKCGMJLGEPKABMNOAGNOLMJKO!M!S!PNIDLKJMPCFKNFOAEBLMIGAAPBJANABBEKIKMCOOLGEHJMDMM!Sheets!1</mon>
  </PrxMetaSheetAutoFilter>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
  <PrxMetaSheetAutoFilterResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">1</PrxMetaSheetAutoFilterResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"PrxMetaSheetAutoFilter" :
{
"mon" : "AHJKEIMPCFKNFOAELIJIBPGEKCGMJLGEPKABMNOAGNOLMJKO!M!S!PNIDLKJMPCFKNFOAEBLMIGAAPBJANABBEKIKMCOOLGEHJMDMM!Sheets!1"
}
}

JSON response:

{
"PrxMetaSheetAutoFilterResult" : "1"
}
public static bool PrxMetaSheetAutoFilter(string moniker, int listKey)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tSet = new PrxMetaSheetAutoFilter()
{
mon = moniker + "!Sheets!" + listKey.ToString()
};
// Enable autofilter
var result = somClient.PrxMetaSheetAutoFilter(tSet);
return result;
}

See also:

Working with Regular Reports