GetDataGridColumns

Syntax

GetDataGridColumnsResult GetDataGridColumns(OdId tOb)

Parameters

tOb. Moniker of the relational data source, which the table is set up to work with.

Description

The GetDataGridColumns operation gets a list of columns that can be displayed in the table.

Comments

The table based on a relational data source is used in the DataGridView information panel visualizer. To execute the operation, in the tOb field specify moniker of the relational data source, which the table will be set up to work with. The object moniker can be obtained on executing the GetObjects operation.

The operation results in the collection of column names and identifiers.

Example

Below is the example of getting the list of columns that can be displayed in the table. The request contains moniker of the relational data source in the repository. The response contains the list of obtained columns.

The C# example uses the FindObjectById function, which code is given in the Getting Object Description by Its Identifier article.

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">
<GetDataGridColumns xmlns="http://www.fsight.ru/PP.SOM.Som">
<tOb xmlns="">
  <id>GKGLPALJEFMIGOAELJBFJLDABBEPHNDEMLLNDEFNJLCIOEOI!M!7466</id>
  </tOb>
  </GetDataGridColumns>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetDataGridColumnsResult 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">
<fields xmlns="">
<Item>
  <name>ORDER</name>
  <id>ORDER</id>
  </Item>
<Item>
  <name>city_name</name>
  <id>city_name</id>
  </Item>
<Item>
  <name>region</name>
  <id>region</id>
  </Item>
<Item>
  <name>federal_region</name>
  <id>federal_region</id>
  </Item>
<Item>
  <name>population</name>
  <id>population</id>
  </Item>
<Item>
  <name>year_foundation</name>
  <id>year_foundation</id>
  </Item>
<Item>
  <name>year_city_status</name>
  <id>year_city_status</id>
  </Item>
<Item>
  <name>old_city_name</name>
  <id>old_city_name</id>
  </Item>
<Item>
  <name>emblem</name>
  <id>emblem</id>
  </Item>
  </fields>
  </GetDataGridColumnsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetDataGridColumns" :
{
"tOb" :
{
"id" : "GKGLPALJEFMIGOAELJBFJLDABBEPHNDEMLLNDEFNJLCIOEOI!M!7466"
}
}
}

JSON response:

{
"GetDataGridColumnsResult" :
{
"fields" :
{
"Item" :
[
{
"name" : "ORDER",
"id" : "ORDER"
},
{
"name" : "city_name",
"id" : "city_name"
},
{
"name" : "region",
"id" : "region"
},
{
"name" : "federal_region",
"id" : "federal_region"
},
{
"name" : "population",
"id" : "population"
},
{
"name" : "year_foundation",
"id" : "year_foundation"
},
{
"name" : "year_city_status",
"id" : "year_city_status"
},
{
"name" : "old_city_name",
"id" : "old_city_name"
},
{
"name" : "emblem",
"id" : "emblem"
}
]
}
}
}
public static GetDataGridColumnsResult GetDataGridColumns(MbId mb, string id)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tGet = new GetDataGridColumns()
{
tOb = new OdId() { id = mb.id + "!" + FindObjectById(mb, id).k }
};
// Get the list of columns that can be displayed in the table based on a relational data source
var result = somClient.GetDataGridColumns(tGet);
return result;
}

See also:

Working with Development Environment