Style Intelligence v12.0

inetsoft.uql
Interface XConstants

All Superinterfaces:
Serializable
All Known Subinterfaces:
BinaryTableFilter, DataTableLens, FormLens, GroupedTable, MemberObjectTableLens, RegionTable, SortedTable, StyleConstants, TableFilter, TableLens
All Known Implementing Classes:
AbstractBinaryTableFilter, AbstractConditionFilter, AbstractFormLens, AbstractGroupedTable, AbstractTableLens, AttributeFormLens, AttributeTableLens, BeanSheet, ButtonPresenter, CalcTableLens, ColumnMapFilter, CompositeSheet, CompositeTableLens, ConditionFilter, CORBATableLens, CrossJoinTableLens, CrosstabConditionFilter, CrossTabCubeFilter, CrossTabFilter, CubeTableFilter, DataSetTable, DateRangeRef, DefaultFormLens, DefaultSortedTable, DefaultTableFilter, DefaultTableLens, DimensionSortOrder, DistinctTableLens, EightyTwentyFilter, FormulaTableLens, GroupedColumnMapFilter, GroupedSortFilter, GroupFilter, GroupRef, HeaderRowTableLens, HighlightFilter, IntersectTableLens, JDBCTableLens, JoinTableLens, MaxRowsTableLens, MaxRowsTableLens2, MergedJoinTableLens, MetaStyleSheet, MetaTableFilter, MetaTabularSheet, MinusTableLens, NamedRangeRef, NumericRangeRef, PagedTableLens, ParameterSheet, RankingTableLens, ReportSheet, RotatedTableLens, RowSummaryFilter, SelfJoinTableLens, SetTableLens, ShadowPresenter, SortFilter, SortOrder, inetsoft.report.internal.StyleCore, StyleFont, StyleSheet, SubTableLens, SummaryFilter, SummaryTableLens, TableSummaryFilter, TabularSheet, TextTableLens, TopNFilter, TransparentGroupFilter, UnionTableLens, XMLTableLens, XNodeFormLens, XNodeTableLens

public interface XConstants
extends Serializable

This class defines the constants used in package inetsoft.uql.


Field Summary
static int AM_PM_DATE_GROUP
          AM/PM date group.
static int AM_PM_OF_DAY_DATE_GROUP
          Am/pm of day date group.
static String AVERAGE_FORMULA
          Formula "Average".
static String CALC_FORMULA
          Formula "Calc".
static String COLUMN
          Represents current column.
static String CONCAT_FORMULA
          Formula "Concat".
static String CONDITION_EMPTY_STRING
          Condition Empty string.
static String CONDITION_NULL_STRING
          Condition string null.
static String CONDITION_NULL_VALUE
          Condition NULL value.
static String CONDITION_REAL_NULL
          Condition real NULL.
static String CORRELATION_FORMULA
          Formula "Correlation".
static String COUNT_FORMULA
          Formula "Count".
static String COVARIANCE_FORMULA
          Formula "Covariance".
static String CURRENCY_FORMAT
          Currency format type.
static String CURRENT_REP_CHANGED
          Current repository changed.
static String CURRENT_REP_WILL_CHANGE
          Current repository will change.
static String DATE_FORMAT
          Date format type.
static int DAY_DATE_GROUP
          Day date group.
static int DAY_OF_MONTH_DATE_GROUP
          Day of month date group.
static int DAY_OF_WEEK_DATE_GROUP
          Day of week date group.
static int DAY_OF_YEAR_DATE_GROUP
          Day of year date group.
static String DECIMAL_FORMAT
          Decimal format type.
static String DISTINCTCOUNT_FORMULA
          Formula "DistinctCount".
static String FIRST_FORMULA
          Formula "First".
static int FULL_JOIN
          Full join operation.
static int GREATER_EQUAL_JOIN
          Greater equal join operation.
static int GREATER_JOIN
          Greater join operation.
static int GROUP_OTHERS
          Other group option when using specific order: put all others together.
static int HOUR_DATE_GROUP
          Hour date group.
static int HOUR_OF_DAY_DATE_GROUP
          Hour of day date group.
static int INNER_JOIN
          Inner join operation.
static int JOIN
          Join operation.
static String LAST_FORMULA
          Formula "Last".
static int LEAVE_OTHERS
          Other group option when using specific order: leave all other data in their own group.
static int LEFT_JOIN
          Left join operation.
static int LESS_EQUAL_JOIN
          Less equal join operation.
static int LESS_JOIN
          Less join operation.
static String MAX_FORMULA
          Formula "Max".
static String MEDIAN_FORMULA
          Formula "Median".
static String MESSAGE_FORMAT
          Message format type.
static int MILLISECOND_DATE_GROUP
          Millisecond date group.
static String MIN_FORMULA
          Formula "Min".
static int MINUTE_DATE_GROUP
          Minute date group.
static String MODE_FORMULA
          Formula "Mode".
static int MONTH_DATE_GROUP
          Month date group.
static int MONTH_OF_YEAR_DATE_GROUP
          Month of year date group.
static int NONE_DATE_GROUP
          None date group.
static String NONE_FORMULA
          Formula "None".
static int NOT_EQUAL_JOIN
          Not equal join operation.
static String NTHLARGEST_FORMULA
          Formula "NthLargest".
static String NTHMOSTFREQUENT_FORMULA
          Formula "NthMostFrequent".
static String NTHSMALLEST_FORMULA
          Formula "NthSmallest".
static String PARAM_PREFIX
          Sub query parameter prefix in drill path.
static int PART_DATE_GROUP
          Part date group.
static String PERCENT_FORMAT
          Percent format type.
static int PERCENTAGE_BY_COL
          Percentage by column.
static int PERCENTAGE_BY_ROW
          Percentage by row.
static int PERCENTAGE_NONE
          No Percentage.
static int PERCENTAGE_OF_COL_GRANDTOTAL
          Percentage of col grand total.
static int PERCENTAGE_OF_COL_GROUP
          Percentage of col group.
static int PERCENTAGE_OF_GRANDTOTAL
          Percentage of grand total.
static int PERCENTAGE_OF_GROUP
          Percentage of group.
static int PERCENTAGE_OF_ROW_GRANDTOTAL
          Percentage of row grand total.
static int PERCENTAGE_OF_ROW_GROUP
          Percentage of row group.
static String POPULATIONSTANDARDDEVIATION_FORMULA
          Formula "PopulationStandardDeviation".
static String POPULATIONVARIANCE_FORMULA
          Formula "PopulationVariance".
static String PRODUCT_FORMULA
          Formula "Product".
static String PTHPERCENTILE_FORMULA
          Formula "PthPercentile".
static int QUARTER_DATE_GROUP
          Quarter date group.
static int QUARTER_OF_YEAR_DATE_GROUP
          Quarter of year date group.
static int RIGHT_JOIN
          Right join operation.
static int SECOND_DATE_GROUP
          Second date group.
static String SET_FORMULA
          Formula "Set".
static int SORT_ASC
          Ascending sorting order.
static int SORT_DESC
          Descending sorting order.
static int SORT_NONE
          No sorting.
static int SORT_ORIGINAL
          Original sorting.
static int SORT_SPECIFIC
          Specific sorting.
static int SORT_VALUE_ASC
          Sort by (aggregate) value, ascending.
static int SORT_VALUE_DESC
          Sort by (aggregate) value, descending.
static String STANDARDDEVIATION_FORMULA
          Formula "StandardDeviation".
static String SUB_QUERY_PARAM
          Sub query parameter in drill path.
static String SUM_FORMULA
          Formula "Sum".
static String SUMSQ_FORMULA
          Forumula "SumSQ"
static String SUMWT_FORMULA
          Formula "WeightSum".
static String VARIANCE_FORMULA
          Formula "Variance".
static int WEEK_DATE_GROUP
          Week date group.
static int WEEK_OF_MONTH_DATE_GROUP
          Week of month date group.
static int WEEK_OF_YEAR_DATE_GROUP
          Week of of year date group.
static String WEIGHTEDAVERAGE_FORMULA
          Formula "WeightedAverage".
static int YEAR_DATE_GROUP
          Year date group.
 

Field Detail

SORT_ASC

static final int SORT_ASC
Ascending sorting order.

See Also:
Constant Field Values

SORT_DESC

static final int SORT_DESC
Descending sorting order.

See Also:
Constant Field Values

SORT_NONE

static final int SORT_NONE
No sorting.

See Also:
Constant Field Values

SORT_ORIGINAL

static final int SORT_ORIGINAL
Original sorting.

See Also:
Constant Field Values

SORT_SPECIFIC

static final int SORT_SPECIFIC
Specific sorting.

See Also:
Constant Field Values

SORT_VALUE_ASC

static final int SORT_VALUE_ASC
Sort by (aggregate) value, ascending.

See Also:
Constant Field Values

SORT_VALUE_DESC

static final int SORT_VALUE_DESC
Sort by (aggregate) value, descending.

See Also:
Constant Field Values

GROUP_OTHERS

static final int GROUP_OTHERS
Other group option when using specific order: put all others together.

See Also:
Constant Field Values

LEAVE_OTHERS

static final int LEAVE_OTHERS
Other group option when using specific order: leave all other data in their own group.

See Also:
Constant Field Values

NONE_DATE_GROUP

static final int NONE_DATE_GROUP
None date group.

See Also:
Constant Field Values

YEAR_DATE_GROUP

static final int YEAR_DATE_GROUP
Year date group.

See Also:
Constant Field Values

QUARTER_DATE_GROUP

static final int QUARTER_DATE_GROUP
Quarter date group.

See Also:
Constant Field Values

MONTH_DATE_GROUP

static final int MONTH_DATE_GROUP
Month date group.

See Also:
Constant Field Values

WEEK_DATE_GROUP

static final int WEEK_DATE_GROUP
Week date group.

See Also:
Constant Field Values

DAY_DATE_GROUP

static final int DAY_DATE_GROUP
Day date group.

See Also:
Constant Field Values

AM_PM_DATE_GROUP

static final int AM_PM_DATE_GROUP
AM/PM date group.

See Also:
Constant Field Values

HOUR_DATE_GROUP

static final int HOUR_DATE_GROUP
Hour date group.

See Also:
Constant Field Values

MINUTE_DATE_GROUP

static final int MINUTE_DATE_GROUP
Minute date group.

See Also:
Constant Field Values

SECOND_DATE_GROUP

static final int SECOND_DATE_GROUP
Second date group.

See Also:
Constant Field Values

MILLISECOND_DATE_GROUP

static final int MILLISECOND_DATE_GROUP
Millisecond date group.

See Also:
Constant Field Values

PART_DATE_GROUP

static final int PART_DATE_GROUP
Part date group.

See Also:
Constant Field Values

QUARTER_OF_YEAR_DATE_GROUP

static final int QUARTER_OF_YEAR_DATE_GROUP
Quarter of year date group.

See Also:
Constant Field Values

MONTH_OF_YEAR_DATE_GROUP

static final int MONTH_OF_YEAR_DATE_GROUP
Month of year date group.

See Also:
Constant Field Values

WEEK_OF_YEAR_DATE_GROUP

static final int WEEK_OF_YEAR_DATE_GROUP
Week of of year date group.

See Also:
Constant Field Values

WEEK_OF_MONTH_DATE_GROUP

static final int WEEK_OF_MONTH_DATE_GROUP
Week of month date group.

See Also:
Constant Field Values

DAY_OF_YEAR_DATE_GROUP

static final int DAY_OF_YEAR_DATE_GROUP
Day of year date group.

See Also:
Constant Field Values

DAY_OF_MONTH_DATE_GROUP

static final int DAY_OF_MONTH_DATE_GROUP
Day of month date group.

See Also:
Constant Field Values

DAY_OF_WEEK_DATE_GROUP

static final int DAY_OF_WEEK_DATE_GROUP
Day of week date group.

See Also:
Constant Field Values

AM_PM_OF_DAY_DATE_GROUP

static final int AM_PM_OF_DAY_DATE_GROUP
Am/pm of day date group.

See Also:
Constant Field Values

HOUR_OF_DAY_DATE_GROUP

static final int HOUR_OF_DAY_DATE_GROUP
Hour of day date group.

See Also:
Constant Field Values

JOIN

static final int JOIN
Join operation.

See Also:
Constant Field Values

INNER_JOIN

static final int INNER_JOIN
Inner join operation.

See Also:
Constant Field Values

LEFT_JOIN

static final int LEFT_JOIN
Left join operation.

See Also:
Constant Field Values

RIGHT_JOIN

static final int RIGHT_JOIN
Right join operation.

See Also:
Constant Field Values

FULL_JOIN

static final int FULL_JOIN
Full join operation.

See Also:
Constant Field Values

NOT_EQUAL_JOIN

static final int NOT_EQUAL_JOIN
Not equal join operation.

See Also:
Constant Field Values

GREATER_JOIN

static final int GREATER_JOIN
Greater join operation.

See Also:
Constant Field Values

GREATER_EQUAL_JOIN

static final int GREATER_EQUAL_JOIN
Greater equal join operation.

See Also:
Constant Field Values

LESS_JOIN

static final int LESS_JOIN
Less join operation.

See Also:
Constant Field Values

LESS_EQUAL_JOIN

static final int LESS_EQUAL_JOIN
Less equal join operation.

See Also:
Constant Field Values

NONE_FORMULA

static final String NONE_FORMULA
Formula "None".

See Also:
Constant Field Values

AVERAGE_FORMULA

static final String AVERAGE_FORMULA
Formula "Average".

See Also:
Constant Field Values

COUNT_FORMULA

static final String COUNT_FORMULA
Formula "Count".

See Also:
Constant Field Values

DISTINCTCOUNT_FORMULA

static final String DISTINCTCOUNT_FORMULA
Formula "DistinctCount".

See Also:
Constant Field Values

MAX_FORMULA

static final String MAX_FORMULA
Formula "Max".

See Also:
Constant Field Values

MIN_FORMULA

static final String MIN_FORMULA
Formula "Min".

See Also:
Constant Field Values

PRODUCT_FORMULA

static final String PRODUCT_FORMULA
Formula "Product".

See Also:
Constant Field Values

SUM_FORMULA

static final String SUM_FORMULA
Formula "Sum".

See Also:
Constant Field Values

SET_FORMULA

static final String SET_FORMULA
Formula "Set".

See Also:
Constant Field Values

CONCAT_FORMULA

static final String CONCAT_FORMULA
Formula "Concat".

See Also:
Constant Field Values

STANDARDDEVIATION_FORMULA

static final String STANDARDDEVIATION_FORMULA
Formula "StandardDeviation".

See Also:
Constant Field Values

VARIANCE_FORMULA

static final String VARIANCE_FORMULA
Formula "Variance".

See Also:
Constant Field Values

POPULATIONSTANDARDDEVIATION_FORMULA

static final String POPULATIONSTANDARDDEVIATION_FORMULA
Formula "PopulationStandardDeviation".

See Also:
Constant Field Values

POPULATIONVARIANCE_FORMULA

static final String POPULATIONVARIANCE_FORMULA
Formula "PopulationVariance".

See Also:
Constant Field Values

CORRELATION_FORMULA

static final String CORRELATION_FORMULA
Formula "Correlation".

See Also:
Constant Field Values

COVARIANCE_FORMULA

static final String COVARIANCE_FORMULA
Formula "Covariance".

See Also:
Constant Field Values

MEDIAN_FORMULA

static final String MEDIAN_FORMULA
Formula "Median".

See Also:
Constant Field Values

MODE_FORMULA

static final String MODE_FORMULA
Formula "Mode".

See Also:
Constant Field Values

NTHLARGEST_FORMULA

static final String NTHLARGEST_FORMULA
Formula "NthLargest".

See Also:
Constant Field Values

NTHMOSTFREQUENT_FORMULA

static final String NTHMOSTFREQUENT_FORMULA
Formula "NthMostFrequent".

See Also:
Constant Field Values

NTHSMALLEST_FORMULA

static final String NTHSMALLEST_FORMULA
Formula "NthSmallest".

See Also:
Constant Field Values

PTHPERCENTILE_FORMULA

static final String PTHPERCENTILE_FORMULA
Formula "PthPercentile".

See Also:
Constant Field Values

WEIGHTEDAVERAGE_FORMULA

static final String WEIGHTEDAVERAGE_FORMULA
Formula "WeightedAverage".

See Also:
Constant Field Values

SUMWT_FORMULA

static final String SUMWT_FORMULA
Formula "WeightSum".

See Also:
Constant Field Values

SUMSQ_FORMULA

static final String SUMSQ_FORMULA
Forumula "SumSQ"

See Also:
Constant Field Values

CALC_FORMULA

static final String CALC_FORMULA
Formula "Calc".

See Also:
Constant Field Values

FIRST_FORMULA

static final String FIRST_FORMULA
Formula "First".

See Also:
Constant Field Values

LAST_FORMULA

static final String LAST_FORMULA
Formula "Last".

See Also:
Constant Field Values

DATE_FORMAT

static final String DATE_FORMAT
Date format type.

See Also:
Constant Field Values

DECIMAL_FORMAT

static final String DECIMAL_FORMAT
Decimal format type.

See Also:
Constant Field Values

CURRENCY_FORMAT

static final String CURRENCY_FORMAT
Currency format type.

See Also:
Constant Field Values

PERCENT_FORMAT

static final String PERCENT_FORMAT
Percent format type.

See Also:
Constant Field Values

MESSAGE_FORMAT

static final String MESSAGE_FORMAT
Message format type.

See Also:
Constant Field Values

CONDITION_NULL_VALUE

static final String CONDITION_NULL_VALUE
Condition NULL value.

See Also:
Constant Field Values

CONDITION_EMPTY_STRING

static final String CONDITION_EMPTY_STRING
Condition Empty string.

See Also:
Constant Field Values

CONDITION_NULL_STRING

static final String CONDITION_NULL_STRING
Condition string null.

See Also:
Constant Field Values

CONDITION_REAL_NULL

static final String CONDITION_REAL_NULL
Condition real NULL.

See Also:
Constant Field Values

PERCENTAGE_NONE

static final int PERCENTAGE_NONE
No Percentage.

See Also:
Constant Field Values

PERCENTAGE_OF_GROUP

static final int PERCENTAGE_OF_GROUP
Percentage of group.

See Also:
Constant Field Values

PERCENTAGE_OF_GRANDTOTAL

static final int PERCENTAGE_OF_GRANDTOTAL
Percentage of grand total.

See Also:
Constant Field Values

PERCENTAGE_OF_ROW_GROUP

static final int PERCENTAGE_OF_ROW_GROUP
Percentage of row group.

See Also:
Constant Field Values

PERCENTAGE_OF_COL_GROUP

static final int PERCENTAGE_OF_COL_GROUP
Percentage of col group.

See Also:
Constant Field Values

PERCENTAGE_OF_ROW_GRANDTOTAL

static final int PERCENTAGE_OF_ROW_GRANDTOTAL
Percentage of row grand total.

See Also:
Constant Field Values

PERCENTAGE_OF_COL_GRANDTOTAL

static final int PERCENTAGE_OF_COL_GRANDTOTAL
Percentage of col grand total.

See Also:
Constant Field Values

PERCENTAGE_BY_COL

static final int PERCENTAGE_BY_COL
Percentage by column. Only use in CrossTabFilter.

See Also:
Constant Field Values

PERCENTAGE_BY_ROW

static final int PERCENTAGE_BY_ROW
Percentage by row. Only use in CrossTabFilter.

See Also:
Constant Field Values

CURRENT_REP_WILL_CHANGE

static final String CURRENT_REP_WILL_CHANGE
Current repository will change.

See Also:
Constant Field Values

CURRENT_REP_CHANGED

static final String CURRENT_REP_CHANGED
Current repository changed.

See Also:
Constant Field Values

COLUMN

static final String COLUMN
Represents current column.

See Also:
Constant Field Values

SUB_QUERY_PARAM

static final String SUB_QUERY_PARAM
Sub query parameter in drill path.

See Also:
Constant Field Values

PARAM_PREFIX

static final String PARAM_PREFIX
Sub query parameter prefix in drill path.

See Also:
Constant Field Values

Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved.