DashboardFormulaEditorDelete

Syntax

bool DashboardFormulaEditorDelete(string mon)

Parameters

mon. Information panel element moniker.

Description

The DashboardFormulaEditorDelete operation deletes expressions for information panel element or data model element edited in the expression editor.

Comments

The operation deletes SQL queries, calculated field expressions, and data model table filtering. To execute the operation, in the mon field specify moniker of edited element.

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

The operation results in the logical true if expression was deleted successfully.

Example

Below is the example of deleting SQL query text in data model. The request contains moniker of SQL query saved in data model. The response contains whether SQL query text was deleted 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">
<DashboardFormulaEditorDelete xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">JGFBABFGGBCDGOAEBMHDIAHPJIKJBODEGIEMDGCEMLPABPHA!M!S!PAKKBPCFGGBCDGOAEPJJNAKJDEPCJOIOEJLMIGOFHBOBCOFGO!Sources!Queries!Elements!1!Ufe</mon>
  </DashboardFormulaEditorDelete>
  </s:Body>
  </s:Envelope>

SOAP response:

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

JSON request:

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

JSON response:

{
 "DashboardFormulaEditorDeleteResult" : "1"
}
public static bool DashboardFormulaEditorDelete(string moniker, uint elementkey)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tDel = new DashboardFormulaEditorDelete()
    {
        // Element moniker
        mon = moniker + "!Sources!Queries!Elements!" + elementkey + "!Ufe"
    };
    // Delete expression
    var result = somClient.DashboardFormulaEditorDelete(tDel);
    return result;
}

See also:

Working with Information Panel