DashboardFormulaEditorRollback: Operation

The DashboardFormulaEditorRollback operation cancels undoes the changes made in information panel element or data model element expression.

Comments

The operations undoes changes in SQL queries, calculated field expressions, 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:

!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 undoing the changes made in data model SQL query. The request contains moniker of SQL query saved in data model. The response contains whether changes are successfully canceled.

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>

</DashboardFormulaEditorRollback>

</s:Body>

</s:Envelope>

SOAP response:

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

<soapenv:Body>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

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

JSON response:

{
 "DashboardFormulaEditorRollbackResult" : "1"
}

public static bool DashboardFormulaEditorRollback(string moniker, uint elementkey)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tRollback = new DashboardFormulaEditorRollback()
    {
        // Element moniker
        mon = moniker + "!Sources!Queries!Elements!" + elementkey + "!Ufe"
    };
    // Roll back changes
    var result = somClient.DashboardFormulaEditorRollback(tRollback);
    return result;
}

DashboardFormulaEditorRollback

Syntax