add_data


Description:

[ Version ( since = "5.0" ) ]
public bool add_data (DataPivotAggregate aggregate_type, string field, string? alias) throws Error

Specifies that field has to be included in the analysis.

field is a field specification with the following accepted syntaxes: <itemizedlist> <listitem><para>a column name in the source data model (see <link linkend="gda-data-model-get-column-index"> get_column_index</link>); or</para></listitem> <listitem><para>an SQL expression involving a column name in the source data model, for examples: <programlisting> price firstname || ' ' || lastname nb BETWEEN 5 AND 10</programlisting> </para></listitem> </itemizedlist>

It is also possible to specify several fields to be added, while separating them by a comma (in effect still forming a valid SQL syntax).

Parameters:

this

a DataPivot object

aggregate_type

the type of aggregate operation to perform

field

the field description, see below

alias

the field alias, or null

Returns:

true if no error occurred