Package quadbase.reportdesigner.lang

Class BooleanObject

java.lang.Object

quadbase.reportdesigner.lang.BooleanObject

All Implemented Interfaces:

IObject, IFunctionConstants

public class BooleanObject
extends Object
implements IObject, IFunctionConstants

This class is used to implement formulas for columns containing boolean data

Field Summary

Fields inherited from interface quadbase.util.IFunctionConstants

ABS, ACOS, ADD, ADDTIME, AM_PM, AND, ASIN, ATAN, ATAN2, AVERAGE, B_COL, BOOL, BOOL_FUNC, BOOL_NAME, CALENDAR_CONST, CEIL, COL, COS, COUNT, CURRDATE, CURRDATETIME, CURRTIME, D_COL, DATE, DATE_FUNC, DATE_NAME, DATETIME, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_WEEK_IN_MONTH, DAY_OF_YEAR, DAYDIFF, DAYOFWEEK, DECL, DIVIDE, E, EQUALS, ERA, EXP, FACTORIAL, FALSE, FLOOR, GETAMPM, GETERA, GETMONTH, GREATER, GREATEREQUAL, HOUR, HOUR_OF_DAY, ID, IEEEREMAINDER, IFELSE_B, IFELSE_D, IFELSE_N, IFELSE_S, INDEXOF, INSERT, LASTINDEXOF, LESS, LESSEQUAL, LOG, MAX, MAXLENGTH, MEDIAN, MILLISECOND, MIN, MINUTE, MOD, MONTH, MULTIPLY, N_COL, NAND, NEW_DATE_NAME, NEW_NUM_NAME, NEW_STR_NAME, NOR, NOT, NUM, NUM_FUNC, NUM_NAME, OR, OTHER_FUNC_NAME, PAGE, PARAM, PI, POW, PRINTDATE, PRINTDATETIME, PRINTTIME, RANDOM, REPLACE, RINT, ROLLTIME, S_COL, SECOND, SIN, SQRT, STDDEV, STR, STR_FUNC, STR_NAME, STRCAT, STRLEN, SUBSTRING, SUBTRACT, SUMSQUARE, TAN, TD_FUNC_NAME, THIS, TODATE, TODEGREES, TOLOWERCASE, TONUMERIC, TORADIANS, TOSTRING, TOTALPAGES, TOTALSECTIONS, TOUPPERCASE, TRUE, VARIANCE, WEEK_OF_MONTH, WEEK_OF_YEAR, WITHIN, XNOR, XOR, YEAR

Constructor Summary

Constructors

Modifier	Constructor	Description
	BooleanObject(boolean state)	Creates a new BooleanObject with specified state
protected	BooleanObject(String formula)	Creates a new BooleanObject with specified formula

Method Summary

Modifier and Type	Method	Description
static BooleanObject	and(BooleanObject[] f)	Does an AND operation on all the elements of the BooleanObject array.
static BooleanObject	and(BooleanObject a, BooleanObject b)	Does object a AND object b
static BooleanObject	equals(IObject a, IObject b)	Checks to see if object a is equal to object b
static BooleanObject	getColumnValue(int colInfoIndex)	Returns the Column value at specified column
static BooleanObject	getColumnValue(int colInfoIndex, short aggregation)	Returns the Column value at specified column after doing the specified aggregation.
static BooleanObject	getColumnValue(NumericObject colInfoIndex)	Returns the Column value at specified column
static BooleanObject	getColumnValue(NumericObject colInfoIndex, short aggregation)	Returns the Column value at specified column after doing the specified aggregation.
String	getFormula()	Returns the formula
int	getSQLType()	Returns the SQL type
static BooleanObject	greaterThan(IObject a, IObject b)	Checks to see if object a is greater than object b
static BooleanObject	greaterThanEqualTo(IObject a, IObject b)	Checks to if object a is greater than/equal to object b
static BooleanObject	ifElse(BooleanObject exp, BooleanObject ifState, BooleanObject elseState)	Does an IF-THEN operation on specified object
static DateTimeObject	ifElse(BooleanObject exp, DateTimeObject ifState, DateTimeObject elseState)	Does an IF-THEN operation on specified object
static NumericObject	ifElse(BooleanObject exp, NumericObject ifState, NumericObject elseState)	Does an IF-THEN operation on specified object
static StringObject	ifElse(BooleanObject exp, StringObject ifState, StringObject elseState)	Does an IF-THEN operation on specified object
static BooleanObject	lessThan(IObject a, IObject b)	Checks to see if object a is lesser than object b
static BooleanObject	lessThanEqualTo(IObject a, IObject b)	Checks to see if object a is lesser than/equal to object b
static BooleanObject	nand(BooleanObject a, BooleanObject b)	Does object a NAND object b
static BooleanObject	nor(BooleanObject a, BooleanObject b)	Does object a NOR object b
static BooleanObject	not(BooleanObject a)	Changes the boolean state of the specified object to its complement
static BooleanObject	or(BooleanObject[] f)	Does an OR operation on all the elements of the BooleanObject array.
static BooleanObject	or(BooleanObject a, BooleanObject b)	Does object a OR object b
static BooleanObject	withIn(IObject lower, IObject upper, IObject obj)	Checks to see if object obj is within the ranger defined by objects lower and upper
static BooleanObject	xnor(BooleanObject a, BooleanObject b)	Does object a XNOR object b
static BooleanObject	xor(BooleanObject a, BooleanObject b)	Does object a XOR object b

Methods inherited from class java.lang.Object

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

Constructor Details

BooleanObject

public BooleanObject(boolean state)

Creates a new BooleanObject with specified state

BooleanObject

protected BooleanObject(String formula)

Creates a new BooleanObject with specified formula

Method Details

getFormula

public String getFormula()

Returns the formula

Specified by:

getFormula in interface IObject

getSQLType

public int getSQLType()

Returns the SQL type

Specified by:

getSQLType in interface IObject

getColumnValue

public static BooleanObject getColumnValue(int colInfoIndex)

Returns the Column value at specified column

getColumnValue

public static BooleanObject getColumnValue(NumericObject colInfoIndex)

Returns the Column value at specified column

getColumnValue

public static BooleanObject getColumnValue(int colInfoIndex,
 short aggregation)

Returns the Column value at specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants

getColumnValue

public static BooleanObject getColumnValue(NumericObject colInfoIndex,
 short aggregation)

Returns the Column value at specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants

withIn

public static BooleanObject withIn(IObject lower,
 IObject upper,
 IObject obj)

Checks to see if object obj is within the ranger defined by objects lower and upper

greaterThanEqualTo

public static BooleanObject greaterThanEqualTo(IObject a,
 IObject b)

Checks to if object a is greater than/equal to object b

lessThanEqualTo

public static BooleanObject lessThanEqualTo(IObject a,
 IObject b)

Checks to see if object a is lesser than/equal to object b

equals

public static BooleanObject equals(IObject a,
 IObject b)

Checks to see if object a is equal to object b

greaterThan

public static BooleanObject greaterThan(IObject a,
 IObject b)

Checks to see if object a is greater than object b

lessThan

public static BooleanObject lessThan(IObject a,
 IObject b)

Checks to see if object a is lesser than object b

not

public static BooleanObject not(BooleanObject a)

Changes the boolean state of the specified object to its complement

xnor

public static BooleanObject xnor(BooleanObject a,
 BooleanObject b)

Does object a XNOR object b

xor

public static BooleanObject xor(BooleanObject a,
 BooleanObject b)

Does object a XOR object b

nand

public static BooleanObject nand(BooleanObject a,
 BooleanObject b)

Does object a NAND object b

nor

public static BooleanObject nor(BooleanObject a,
 BooleanObject b)

Does object a NOR object b

and

public static BooleanObject and(BooleanObject a,
 BooleanObject b)

Does object a AND object b

and

public static BooleanObject and(BooleanObject[] f)

Does an AND operation on all the elements of the BooleanObject array. Array must contain at least 2 elements

or

public static BooleanObject or(BooleanObject a,
 BooleanObject b)

Does object a OR object b

or

public static BooleanObject or(BooleanObject[] f)

Does an OR operation on all the elements of the BooleanObject array. Array must contain at least 2 elements

ifElse

public static BooleanObject ifElse(BooleanObject exp,
 BooleanObject ifState,
 BooleanObject elseState)

Does an IF-THEN operation on specified object

ifElse

public static NumericObject ifElse(BooleanObject exp,
 NumericObject ifState,
 NumericObject elseState)

Does an IF-THEN operation on specified object

ifElse

public static StringObject ifElse(BooleanObject exp,
 StringObject ifState,
 StringObject elseState)

Does an IF-THEN operation on specified object

ifElse

public static DateTimeObject ifElse(BooleanObject exp,
 DateTimeObject ifState,
 DateTimeObject elseState)

Does an IF-THEN operation on specified object