DrillCheck

Syntax

DrillActionResult DrillCheck(string mon, DrillArguments drillArgs)

Parameters

mon. Moniker of the Table visualizer.

drillArgs. Operation execution parameters.

Description

The DrillCheck operation checks if data can be drilled down.

Comments

To execute the operation, in the mon field specify regular report instance moniker with the !DataArea!DataSources!source key!DataSourceSlices!slice key!Views!table key postfix to work with visualizer, and in the drillArgs field specify drill down check parameters. The moniker can be obtained on executing the OpenPrxMeta operation.

The operation results in the integer value combined from available drill down methods.

Example

Below is the example of checking if data can be drilled down. The request contains the table moniker and the checked cell range. The response contains the number corresponding to a combination of available data drill down methods.

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">
<DrillCheck xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">CHCLOAMOHNMNFOAEAOBHLKNHNLECIIEECIEPIFJKDPMAKEHH!M!S!PJMCKNEMOHNMNFOAEACDENOFJJPKEDLHEMIJKOGIFKAHGPPCI!DataArea!DataSources!1!DataSourceSlices!1!Views!1</mon>
<drillArgs xmlns="">
  <method>1</method>
<grid>
<rng>
  <left>0</left>
  <top>0</top>
  <width>0</width>
  <height>0</height>
  <address>C2</address>
  </rng>
  </grid>
  </drillArgs>
  </DrillCheck>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<DrillCheckResult 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">
  <methods xmlns="">3</methods>
  </DrillCheckResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"DrillCheck" :
{
"mon" : "CHCLOAMOHNMNFOAEAOBHLKNHNLECIIEECIEPIFJKDPMAKEHH!M!S!PJMCKNEMOHNMNFOAEACDENOFJJPKEDLHEMIJKOGIFKAHGPPCI!DataArea!DataSources!1!DataSourceSlices!1!Views!1",
"drillArgs" :
{
"method" : "1",
"grid" :
{
"rng" :
{
"left" : "0",
"top" : "0",
"width" : "0",
"height" : "0",
"address" : "C2"
}
}
}
}
}

JSON response:

{
"DrillCheckResult" :
{
"methods" : "3"
}
}
public static DrillActionResult DrillCheck(string moniker, uint sourceKey, uint sliceKey, uint viewKey, TabComplexRange drillRange)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tDrill = new DrillCheck()
{
drillArgs = new DrillArguments()
{
method = 1,
grid = new GridDrillArgs()
{
rng = drillRange
}
},
mon = moniker + "!DataArea!DataSources!" + sourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Views!" + viewKey.ToString()
};
// Check if data can be drilled down in table
var result = somClient.DrillCheck(tDrill);
return result;
}

See also:

Working With Regular Reports