bool DrillAction(string mon, DrillArguments drillArgs)
mon. Moniker of the Table visualizer.
drillArgs. Operation execution parameters.
The DrillAction operation drills down data.
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.
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.
{
"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"
}
}
}
}
}
{
"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: