Examples of jimm.datavision.UserColumn

jimm.datavision.UserColumn

A user column is an arbitrary expression inserted into the SQL query and retrieved as a column value. It may contain database column values, parameters, special values, strings, or numbers. It can't contain formulas because their values may be undefined when the query is run.

When used by a query, the following substitutions are made withing the userString of a user column:

{table_name.column_name} is replaced by the column name table_name.column_name.
{%special_value_name} is replaced by a special value (report title, report run date, page number, or record number).
{?id_number} is replaced by a parameter value (string, number, or date).

jimm@io.com

    query = ds.getQuery();


    // Add user cols used in report that are not used by a group.
    Iterator iter;
    for (iter = report.userColumns(); iter.hasNext(); ) {
  UserColumn uc = (UserColumn)iter.next();
  if (!report.isUsedBySomeGroup(uc)) // Ignore group user groups
      addToModel(uc);
    }


    // Add columns used in report that are not used by a group.

Examples of jimm.datavision.UserColumn

Related Classes of jimm.datavision.UserColumn