DashboardFormulaEditorEdit: Operation

The DashboardFormulaEditorEdit operation opens information panel element or data model element for edit in the expression editor.

Comments

The operation starts editing SQL queries, calculated field expressions, data model table filtering. To execute the operation, in the mon field specify moniker of element that should be edited.

The moniker is created from moniker of opened information panel instance or data model with adding the following postfixes:

!Sources!Queries!Elements!query key!Ufe. To work with SQL queries.
!Fields!field key!Ufe. To work with calculated fields.
!Ufe. To set up filtering in data model table.

Example

Below is the example of editing SQL query in data model. The request contains moniker of SQL query saved in data model. The response contains the current SQL query text.

SOAP JSON C#

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">

<mon xmlns="">JGFBABFGGBCDGOAEBMHDIAHPJIKJBODEGIEMDGCEMLPABPHA!M!S!PAKKBPCFGGBCDGOAEPJJNAKJDEPCJOIOEJLMIGOFHBOBCOFGO!Sources!Queries!Elements!1!Ufe</mon>

</DashboardFormulaEditorEdit>

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<DashboardFormulaEditorEditResult 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">select * from t_log</DashboardFormulaEditorEditResult>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "DashboardFormulaEditorEdit" : 
  {
   "mon" : "JGFBABFGGBCDGOAEBMHDIAHPJIKJBODEGIEMDGCEMLPABPHA!M!S!PAKKBPCFGGBCDGOAEPJJNAKJDEPCJOIOEJLMIGOFHBOBCOFGO!Sources!Queries!Elements!1!Ufe"
  }
}

JSON response:

{
 "DashboardFormulaEditorEditResult" : "select * from t_log"
}

public static string DashboardFormulaEditorEdit(string moniker, uint elementkey)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tEdit = new DashboardFormulaEditorEdit()
    {
        // Element moniker
        mon = moniker + "!Sources!Queries!Elements!" + elementkey + "!Ufe"
    };
    // Edit expression
    var result = somClient.DashboardFormulaEditorEdit(tEdit);
    return result;
}

DashboardFormulaEditorEdit

Syntax