DrillAction

Syntax

bool DrillAction(string mon, DrillArguments drillArgs)

Parameters

mon. Moniker of the Table visualizer.

drillArgs. Operation execution parameters.

Description

The DrillAction operation drills down data.

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 visualizers, and in the drillArgs field specify drill down parameters. The moniker can be obtained on executing the OpenPrxMeta operation.

The operation returns logical True if drill down was executed successfully.

Example

Below is the example of data drill down. The request contains table moniker, cell range, drill down method. The response contains whether drill down is executed successfully.

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">
<DrillAction 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>
  </DrillAction>
  </s:Body>
  </s:Envelope>

SOAP response:

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

JSON request:

{
"DrillAction" :
{
"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:

{
"DrillActionResult" : "1"
}
public static bool DrillAction(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 DrillAction()
{
drillArgs = new DrillArguments()
{
method = 1,
grid = new GridDrillArgs()
{
rng = drillRange
}
},
mon = moniker + "!DataArea!DataSources!" + sourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Views!" + viewKey.ToString()
};
// Drill down table data
var result = somClient.DrillAction(tDrill);
return result;
}

See also:

Working With Regular Reports