GetTabFormatConditions

Syntax

TabFormatConditionsEx GetTabFormatConditions(string mon)

Parameters

mon. Moniker to work with conditional formats of analytical data area table.

Description

The GetTabFormatConditions operation gets settings of conditional formats specified for analytical data area table.

Comments

To execute the operation, in the mon field determine report instance moniker with the !DataArea!Views!«table key»!EaxTableStyle!InternalFormatConditions postfix. The operation results in the conditional formats settings.

Example

Below is the example of getting conditional formats settings specified for analytical data area table. The request contains moniker to work with conditional formats, the response contains received settings of conditional formats.

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">
<GetTabFormatConditions xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">S1!M!S!E1!DataArea!Views!1!EaxTableStyle!InternalFormatConditions</mon>
  </GetTabFormatConditions>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetTabFormatConditionsResult 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">
<conditions xmlns="">
<Condition>
  <k>0</k>
  <Key>0</Key>
  <Type>Values</Type>
<Range>
  <left>0</left>
  <top>0</top>
  <width>0</width>
  <height>0</height>
  </Range>
  <Enabled>1</Enabled>
<Details>
<Values>
  <Style>0</Style>
  <MinValueType>0</MinValueType>
  <MinValue />
  <MinValueColor>#FF0000</MinValueColor>
  <MaxValueType>1</MaxValueType>
  <MaxValue />
  <MaxValueColor>#00FF00</MaxValueColor>
  <MidValueType>3</MidValueType>
  <MidValue>50</MidValue>
  <MidValueColor>#FFFF00</MidValueColor>
<Points>
<Point>
  <Type>3</Type>
  <Value>20</Value>
  <Condition>1</Condition>
  </Point>
<Point>
  <Type>3</Type>
  <Value>40</Value>
  <Condition>1</Condition>
  </Point>
<Point>
  <Type>3</Type>
  <Value>60</Value>
  <Condition>1</Condition>
  </Point>
<Point>
  <Type>3</Type>
  <Value>80</Value>
  <Condition>1</Condition>
  </Point>
  </Points>
  <IconType>Circles</IconType>
  <ShowValues>1</ShowValues>
  <ReverseIcons>0</ReverseIcons>
  </Values>
  </Details>
  </Condition>
  </conditions>
  </GetTabFormatConditionsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
 "GetTabFormatConditions" : 
  {
   "mon" : "S1!M!S!E1!DataArea!Views!1!EaxTableStyle!InternalFormatConditions"
  }
}

JSON response:

{
 "GetTabFormatConditionsResult" : 
  {
   "conditions" : 
    {
     "Condition" : 
      {
       "k" : "0",
       "Key" : "0",
       "Type" : "Values",
       "Range" : 
        {
         "left" : "0",
         "top" : "0",
         "width" : "0",
         "height" : "0"
        },
       "Enabled" : "1",
       "Details" : 
        {
         "Values" : 
          {
           "Style" : "0",
           "MinValueType" : "0",
           "MinValue" : "",
           "MinValueColor" : "#FF0000",
           "MaxValueType" : "1",
           "MaxValue" : "",
           "MaxValueColor" : "#00FF00",
           "MidValueType" : "3",
           "MidValue" : "50",
           "MidValueColor" : "#FFFF00",
           "Points" : 
            {
             "Point" : 
              [
                {
                 "Type" : "3",
                 "Value" : "20",
                 "Condition" : "1"
                },
                {
                 "Type" : "3",
                 "Value" : "40",
                 "Condition" : "1"
                },
                {
                 "Type" : "3",
                 "Value" : "60",
                 "Condition" : "1"
                },
                {
                 "Type" : "3",
                 "Value" : "80",
                 "Condition" : "1"
                }
              ]
            },
           "IconType" : "Circles",
           "ShowValues" : "1",
           "ReverseIcons" : "0"
          }
        }
      }
    }
  }
}
public static TabFormatConditionsEx GetFormatConditions(string moniker, string viewKey)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tTab = new GetTabFormatConditions()
    {
        mon = moniker + "!DataArea!Views!" + viewKey + "!EaxTableStyle!InternalFormatConditions"
    };
    // Get conditional formats parameters
    var result = somClient.GetTabFormatConditions(tTab);
    return result;
}

See also:

Table