report dataset

Use the following command to configure report data sets.

You can configure existing data sets or add new ones, by creating SQL queries.

config report dataset
    edit {name}
    # Report dataset configuration.
        set name {string}   Name. size[71]
        set policy {integer}   Used by monitor policy. range[0-4294967295]
        set query {string}   SQL query statement. size[2303]
        config field
            edit {id}
            # Fields.
                set id {integer}   Field ID (1 to number of columns in SQL result). range[0-4294967295]
                set type {text | integer | double}   Field type.
                        text     Text.
                        integer  Integer.
                        double   Double.
                set name {string}   Name. size[71]
                set displayname {string}   Display name. size[127]
            next
        config parameters
            edit {id}
            # Parameters.
                set id {integer}   Parameter ID (1 to number of columns in SQL result). range[0-4294967295]
                set display-name {string}   Display name. size[127]
                set field {string}   SQL field name. size[127]
                set data-type {option}   Data type.
                        text          Text.
                        integer       Integer.
                        double        Double.
                        long-integer  Long integer.
                        date-time     Date and time.
            next
    next
end