com.cloupia.lib.util.managedreports

Class TableView

java.lang.Object

com.cloupia.lib.util.managedreports.TableView

public class TableView
extends java.lang.Object

This is a metadata representation of the Tabular report This class also gives utility methods to be operated upon the tabular report

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	TableView.ColPrefs Static class represents the column preferences
static class	TableView.ValueCountCompAsc Static class to compare the valueCount object in ascending order
static class	TableView.ValueCountCompDesc Static class to compare the valueCount object in descending order

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	otherLabel

Constructor Summary

Constructors

Constructor and Description
TableView(TabularReport report) Constructor to create the table view from the tabular report

Method Summary

Modifier and Type	Method and Description
int	columnCount() Number of columns in this tabular report
void	columnHide(java.lang.String columnLabel, boolean hide) Makes the given column as hidden or un-hidden
void	columnRename(java.lang.String columnLabel, java.lang.String newLabel) This method renames the given column label to the newly given one
TableView	filterRowsByColumn(java.lang.String columnLabel, java.lang.String match, boolean isRegexp) Filter the rows by the column label and the given matching string
java.lang.String	getColumnDescr(int idx) Returns the column description
int	getColumnIndex(java.lang.String columnLabel) The index value of the given column label
java.lang.String	getColumnLabel(int idx) Returns the column label for the given index
java.lang.String	getColumnLabelLocalized(int idx) Retrieve localized label
java.lang.String	getColumnValue(int rowIndex, java.lang.String columnLabel) Returns the columnValue for the given column label and the row index
java.lang.String[]	getColumnValues(java.lang.String columnLabel) Retrieve column values based on untranslated column labels
TabularReport	getReport() The under lying report for this TableView
static java.util.List<ValueCount>	getTopN(java.util.List<ValueCount> counts, int topN, boolean hasOther) Returns the list of value count object for the number of counts
int	rowCount() Number of rows in this Tabular Report
int	rowCountByColumn(int colidx, java.lang.String match, boolean isRegexp) Returns the number of rows matching a given string in a specific column
int	rowCountByColumn(java.lang.String columnLabel, java.lang.String match, boolean isRegexp) Returns the number of rows matching a given string in a specific column
int	rowCountByValue(java.lang.String columnLabel, java.lang.String match) Returns the number of rows matching the column label for given string
ValueSet	rowCountsByValue(java.lang.String columnLabel, boolean isAsc) Returns the valueSet object for the columnLabel ordered in ascending or descending order
ValueSet	rowCountsByValue(java.lang.String columnLabel, boolean isAsc, int topN, boolean hasOther) This method returns the ValueSet object in an ascending or descending order.
boolean	showColumn(int idx) Checks if the column is to be shown or not
double	sumByColumn(int colidx) The sum of the values of the given column label
double	sumByColumn(java.lang.String columnLabel) The sum of the values of the given column label

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

otherLabel

public static java.lang.String otherLabel

Constructor Detail

TableView

public TableView(TabularReport report)

Constructor to create the table view from the tabular report

Parameters:

report - - the tabular report

Method Detail

getReport

public TabularReport getReport()

The under lying report for this TableView

Returns:

- the Tabular Report

filterRowsByColumn

public TableView filterRowsByColumn(java.lang.String columnLabel,
                                    java.lang.String match,
                                    boolean isRegexp)

Filter the rows by the column label and the given matching string

Parameters:

columnLabel - - the column label

match - - the matching string

isRegexp - - is regular expression

Returns:

- the tableView

getTopN

public static java.util.List<ValueCount> getTopN(java.util.List<ValueCount> counts,
                                                 int topN,
                                                 boolean hasOther)

Returns the list of value count object for the number of counts

Parameters:

counts - - the valueCount object

topN - - the integer value to fetch the top counts

hasOther - - boolean value

Returns:

- the list of valueCount objects

rowCountByValue

public int rowCountByValue(java.lang.String columnLabel,
                           java.lang.String match)

Returns the number of rows matching the column label for given string

Parameters:

columnLabel - - the columnLabel

match - -the matching string

Returns:

- the count value

rowCountsByValue

public ValueSet rowCountsByValue(java.lang.String columnLabel,
                                 boolean isAsc)

Returns the valueSet object for the columnLabel ordered in ascending or descending order

Parameters:

columnLabel - - the column label

isAsc - - isAsc

Returns:

- the ValueSet object

rowCountsByValue

public ValueSet rowCountsByValue(java.lang.String columnLabel,
                                 boolean isAsc,
                                 int topN,
                                 boolean hasOther)

This method returns the ValueSet object in an ascending or descending order. Programmer can also specify the number of rows to be returned

Parameters:

columnLabel - - the column label to be ordered

isAsc - - the isAsc

topN - - the number of rows to be fetched

hasOther - - the hasOther

Returns:

- the ValueSet object

getColumnValue

public java.lang.String getColumnValue(int rowIndex,
                                       java.lang.String columnLabel)

Returns the columnValue for the given column label and the row index

Parameters:

rowIndex - - the rowIndex

columnLabel - - the column label

Returns:

- the value

getColumnLabel

public java.lang.String getColumnLabel(int idx)

Returns the column label for the given index

Parameters:

idx - - the index of the column label

Returns:

- the column label

getColumnLabelLocalized

public java.lang.String getColumnLabelLocalized(int idx)

Retrieve localized label

Parameters:

idx - - the index of the column

Returns:

- the column label

getColumnDescr

public java.lang.String getColumnDescr(int idx)

Returns the column description

Parameters:

idx - - the index of the column

Returns:

- the column description

showColumn

public boolean showColumn(int idx)

Checks if the column is to be shown or not

Parameters:

idx - - the index of the column

Returns:

- true if this column is defined to be shown else false

columnHide

public void columnHide(java.lang.String columnLabel,
                       boolean hide)

Makes the given column as hidden or un-hidden

Parameters:

columnLabel - - the column label

hide - - to hide or to un-hide

columnRename

public void columnRename(java.lang.String columnLabel,
                         java.lang.String newLabel)

This method renames the given column label to the newly given one

Parameters:

columnLabel - - the column label

newLabel - - the new label

rowCount

public int rowCount()

Number of rows in this Tabular Report

Returns:

the count of rows in this tabular report

columnCount

public int columnCount()

Number of columns in this tabular report

Returns:

- the count of columns in this tabular report

getColumnValues

public java.lang.String[] getColumnValues(java.lang.String columnLabel)

Retrieve column values based on untranslated column labels

Parameters:

columnLabel - - the columna label

Returns:

- the array of column values

getColumnIndex

public int getColumnIndex(java.lang.String columnLabel)

The index value of the given column label

Parameters:

columnLabel - - the column label

Returns:

- the index value

rowCountByColumn

public int rowCountByColumn(java.lang.String columnLabel,
                            java.lang.String match,
                            boolean isRegexp)

Returns the number of rows matching a given string in a specific column

Parameters:

columnLabel - - the column label

match - - the matching string

isRegexp - - isRegular expression

Returns:

- number of rows

rowCountByColumn

public int rowCountByColumn(int colidx,
                            java.lang.String match,
                            boolean isRegexp)

Returns the number of rows matching a given string in a specific column

Parameters:

colidx - - the column index

match - - the matching string

isRegexp - - is regular expression

Returns:

- the row count

sumByColumn

public double sumByColumn(java.lang.String columnLabel)

The sum of the values of the given column label

Parameters:

columnLabel - - the column label

Returns:

- the sum value

sumByColumn

public double sumByColumn(int colidx)

The sum of the values of the given column label

Parameters:

columnLabel - - the column label

Returns:

- the sum value