com.wm.app.tn.db
Class ProfileQuery

java.lang.Object
  com.wm.app.tn.db.Query
      com.wm.app.tn.db.ProfileQuery

All Implemented Interfaces:

com.wm.data.IData

public class ProfileQuery
extends Query
implements com.wm.data.IData

Field Summary

static java.lang.String	A_TBL
static java.lang.String	ADDRESS_TBL
static java.lang.String	CITY
static java.lang.String	CORP
static java.lang.String	COUNTRY
static java.lang.String	EXPOSED_FLDID
static java.lang.String	EXPOSED_FLDNAME
static java.lang.String	EXPOSED_FLDVALUE
static java.lang.String	EXTFLDNAME
static java.lang.String	EXTFLDOP
static java.lang.String	EXTFLDVALUE
static java.lang.String	GROUP
static java.lang.String	GROUPID
static java.lang.String	IDT_TBL
static java.lang.String	IDT_TYPE
static java.lang.String	IDTYPE
static java.lang.String	IDTYPE_TBL
static java.lang.String	IDVALUE
static java.lang.String	INCL_PENDING
static java.lang.String	INCL_UNKNOWN
static java.lang.String	INTID
static java.lang.String	ONBOARDING
static java.lang.String	P_TBL
static java.lang.String	PARTNER_ID_ID
static java.lang.String	PARTNER_TBL
static java.lang.String	PARTNERID_TBL
static java.lang.String	PARTNERPROFILEFIELD_TBL
static java.lang.String	PARTNERPROFILEGROUP_TBL
static java.lang.String	PARTNERUSER_TBL
static java.lang.String	PENDING
static java.lang.String	PF_DEFAULT_VAL
static java.lang.String	PF_TBL
static java.lang.String	PFID
static java.lang.String	PG_TBL
static java.lang.String	PID
static java.lang.String	PID_IDTYPE
static java.lang.String	PID_TBL
static java.lang.String	PPF_TBL
static java.lang.String	PPG_TBL
static java.lang.String	PROFILEFIELD_TBL
static java.lang.String	PROFILEGROUP_TBL
static java.lang.String	PU_TBL
static java.lang.String	s_NegationPrefix
static java.lang.String[]	SEARCH_COLS For internal use only
static java.lang.String	STATE
static java.lang.String	STATUS
static java.lang.String	SUBSTATUS
static java.lang.String	UNIT
static java.lang.String	USERNAME
static java.lang.String	VIEW_EXTENDED_FIELDS
static java.lang.String	VIEW_PERMISSION
boolean	WITH_DLS
static java.lang.String	ZIP

Fields inherited from class com.wm.app.tn.db.Query

ACTLOG_EVENT_TIMESTAMP, BDTYPE_LASTMODIFIED, DJOB_TIME_CREATED, DJOB_TIME_UPDATED, DOC_TIMESTAMP, FN_AVG, FN_MAX, FN_MIN, FN_SUM, INVITE_ALERTDATE, INVITE_EXPIRYDATE, INVITE_LASTSENT, OP_COMP_AFTER, OP_COMP_BEFORE, OP_COMP_CONTAINS, OP_COMP_EQ, OP_COMP_GEQ, OP_COMP_GT, OP_COMP_INCLUDES, OP_COMP_LEQ, OP_COMP_LT, OP_COMP_NEQ, OP_MATCHES, OP_TEST_NOT_NULL, OP_TEST_NULL, TIME_ANYTIME, TIME_CUSTOM, TIME_LAST_7_DAYS, TIME_LAST_MONTH, TIME_LAST_WEEK, TIME_NEXT_10_MIN, TIME_NEXT_12_HOURS, TIME_NEXT_24_HOURS, TIME_NEXT_3_HOURS, TIME_NEXT_30_MIN, TIME_NEXT_6_HOURS, TIME_NEXT_HOUR, TIME_THIS_MONTH, TIME_THIS_WEEK, TIME_TODAY, TIME_TOMORROW, TIME_YESTERDAY, TIME_YTD, TPA_CREATED, TPA_LASTMODIFIED, TYPE_DATE, TYPE_NUMBER, TYPE_STRING

Constructor Summary

ProfileQuery()
Default query is "select * from partner".

Method Summary

void	clearAllExtFldQueries() Clear all ext fld queries.
void	clearExtFldQuery(java.lang.String extFld) Clear ext fld query for the specified ext fld.
void	clearSortColumn()
static com.wm.data.IData	create() For internal use only
java.lang.Object	getCity()
java.lang.Object	getCorporation()
java.lang.Object	getCountry()
com.wm.data.IDataCursor	getCursor()
java.util.Vector	getExtFldQueries() Get all extended field queries.
java.lang.String	getGenericQuery()
java.lang.Object	getGroup()
com.wm.data.IDataHashCursor	getHashCursor() For internal use only
java.lang.Object	getIDType()
java.lang.Object	getIDValue()
com.wm.data.IDataIndexCursor	getIndexCursor() For internal use only
com.wm.data.IDataSharedCursor	getSharedCursor()
java.lang.String	getSortColumn() Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])
java.lang.String[][]	getSortColumns() Get the sort columns in the format of {{CORP, "ASC"}, {STATUS, "DESC"}}.
java.lang.Object	getState()
java.lang.Object	getStatus()
java.lang.Object	getSubstatus()
com.wm.data.IDataTreeCursor	getTreeCursor() For internal use only
java.lang.Object	getUnit()
java.lang.Object	getUsername()
java.util.Enumeration	getVisibleColumns()
java.util.Vector	getVisibleExtFlds()
java.lang.Object	getZip()
boolean	isCityVisible()
boolean	isCorporationVisible()
boolean	isCountryVisible()
boolean	isExtFldVisible(java.lang.String fldId)
boolean	isGroupVisible()
boolean	isIDVisible()
boolean	isIncludeUnknown()
boolean	isIncudePending()
boolean	isInternalIDVisible()
boolean	isIntIdOnly()
boolean	isQueryOnID()
boolean	isSortAscending()
boolean	isStateVisible()
boolean	isStatusVisible()
boolean	isSubstatusVisible()
boolean	isUnitVisible()
boolean	isUsernameVisible()
boolean	isWithDLS()
boolean	isZipVisible()
void	preSql() For internal use only
void	setCity(java.lang.String s) Search for partner profile from address - city.
void	setCity(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on city.
void	setCityVisible(boolean b)
void	setCorporation(java.lang.String s) Search for partner profile from corp name.
void	setCorporation(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on corp name.
void	setCorporationVisible(boolean b)
void	setCountry(java.lang.String s) Search for partner profile from address - country.
void	setCountry(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on country.
void	setCountryVisible(boolean b)
void	setExtFieldQuery(java.lang.String fld, java.lang.String[][] opVal, boolean isORquery) Search for partner profile from extended field value
void	setExtFldQuery(java.lang.String fldId, java.lang.String[][] opVal, boolean isORquery) Search for partner profile from extended field value
void	setExtFldQuery(java.lang.String fldId, java.lang.String op, java.lang.String val) Add an extended field query.
void	setExtFldVisible(java.lang.String fldId, boolean show)
void	setGenericQuery(java.lang.String query)
void	setGroup(java.lang.String s) Search for partner profile from profile group name.
void	setGroup(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on profile group name.
void	setGroupVisible(boolean b)
void	setID(java.lang.String[][] typeVal, boolean isORquery) Search for partner profile from external id type description and value.
void	setID(java.lang.String type, java.lang.String value) Search for partner profile from external id type description and value.
void	setIDVisible(boolean b)
void	setIncludePending(boolean b)
void	setIncludeUnknown(boolean b)
void	setInternalIDVisible(boolean b)
void	setIntIdOnly(boolean b)
void	setIsQueryOnID(boolean b)
void	setKeywordQuery(java.lang.String[] keywords)
void	setSortColumn(java.lang.String col, boolean asc) Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])
void	setSortColumns(java.lang.String[][] columnOrder) Set the sort columns and order for this query.
void	setState(java.lang.String s) Search for partner profile from address - state.
void	setState(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on state.
void	setStateVisible(boolean b)
void	setStatus(java.lang.String s) Search for partner profile from partner profile status.
void	setStatus(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on profile status.
void	setStatusVisible(boolean b)
void	setSubstatus(java.lang.String s) Search for partner profile from partner profile sub status.
void	setSubstatus(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on profile substatus.
void	setSubstatusVisible(boolean b)
void	setUnit(java.lang.String s) Search for partner profile from unit name.
void	setUnit(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on unit name.
void	setUnitVisible(boolean b)
void	setUsername(java.lang.String username)
void	setUsername(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on user name.
void	setUsernameVisible(boolean b)
void	setViewPermission(java.lang.String viewPermission)
void	setWithDLS(boolean b)
void	setZip(java.lang.String s) Search for partner profile from address - zip.
void	setZip(java.lang.String[][] opVal, boolean isORquery) Search for partner profiles using multiple criteria on zip.
void	setZipVisible(boolean b)
java.lang.String	toString()

Methods inherited from class com.wm.app.tn.db.Query

beginningOfDay, escapeString, evaluate, evaluateListConditions, generateClause, generateClause, generateColumnList, generateComp, generateComp, generateComp, generateListComp, generateNumericClause, generateStringLit, generateStringLit, generateTimeInterval, generateTimestampLiteral, getIntervalType, getUnique, isDateTime, isDistinct, isIndentSql, isOR, searchMWS, setAlertTimeInterval, setDistinct, setExpiryTimeInterval, setIndentSql, setLastReminderInterval, setOR, setTimeInterval, toSql

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

CORP

public static final java.lang.String CORP

See Also:

Constant Field Values

UNIT

public static final java.lang.String UNIT

See Also:

Constant Field Values

IDTYPE

public static final java.lang.String IDTYPE

See Also:

Constant Field Values

IDVALUE

public static final java.lang.String IDVALUE

See Also:

Constant Field Values

GROUP

public static final java.lang.String GROUP

See Also:

Constant Field Values

STATUS

public static final java.lang.String STATUS

See Also:

Constant Field Values

CITY

public static final java.lang.String CITY

See Also:

Constant Field Values

STATE

public static final java.lang.String STATE

See Also:

Constant Field Values

ZIP

public static final java.lang.String ZIP

See Also:

Constant Field Values

COUNTRY

public static final java.lang.String COUNTRY

See Also:

Constant Field Values

PID

public static final java.lang.String PID

See Also:

Constant Field Values

INTID

public static final java.lang.String INTID

See Also:

Constant Field Values

PID_IDTYPE

public static final java.lang.String PID_IDTYPE

See Also:

Constant Field Values

GROUPID

public static final java.lang.String GROUPID

See Also:

Constant Field Values

PFID

public static final java.lang.String PFID

See Also:

Constant Field Values

IDT_TYPE

public static final java.lang.String IDT_TYPE

See Also:

Constant Field Values

USERNAME

public static final java.lang.String USERNAME

See Also:

Constant Field Values

PARTNER_ID_ID

public static final java.lang.String PARTNER_ID_ID

See Also:

Constant Field Values

SUBSTATUS

public static final java.lang.String SUBSTATUS

See Also:

Constant Field Values

ONBOARDING

public static final java.lang.String ONBOARDING

See Also:

Constant Field Values

PENDING

public static final java.lang.String PENDING

See Also:

Constant Field Values

EXTFLDNAME

public static final java.lang.String EXTFLDNAME

See Also:

Constant Field Values

EXTFLDVALUE

public static final java.lang.String EXTFLDVALUE

See Also:

Constant Field Values

EXTFLDOP

public static final java.lang.String EXTFLDOP

See Also:

Constant Field Values

PARTNER_TBL

public static final java.lang.String PARTNER_TBL

See Also:

Constant Field Values

P_TBL

public static final java.lang.String P_TBL

See Also:

Constant Field Values

ADDRESS_TBL

public static final java.lang.String ADDRESS_TBL

See Also:

Constant Field Values

A_TBL

public static final java.lang.String A_TBL

See Also:

Constant Field Values

PARTNERID_TBL

public static final java.lang.String PARTNERID_TBL

See Also:

Constant Field Values

PID_TBL

public static final java.lang.String PID_TBL

See Also:

Constant Field Values

IDTYPE_TBL

public static final java.lang.String IDTYPE_TBL

See Also:

Constant Field Values

IDT_TBL

public static final java.lang.String IDT_TBL

See Also:

Constant Field Values

PROFILEGROUP_TBL

public static final java.lang.String PROFILEGROUP_TBL

See Also:

Constant Field Values

PG_TBL

public static final java.lang.String PG_TBL

See Also:

Constant Field Values

PARTNERPROFILEGROUP_TBL

public static final java.lang.String PARTNERPROFILEGROUP_TBL

See Also:

Constant Field Values

PPG_TBL

public static final java.lang.String PPG_TBL

See Also:

Constant Field Values

PROFILEFIELD_TBL

public static final java.lang.String PROFILEFIELD_TBL

See Also:

Constant Field Values

PARTNERPROFILEFIELD_TBL

public static final java.lang.String PARTNERPROFILEFIELD_TBL

See Also:

Constant Field Values

PF_TBL

public static final java.lang.String PF_TBL

See Also:

Constant Field Values

PF_DEFAULT_VAL

public static final java.lang.String PF_DEFAULT_VAL

See Also:

Constant Field Values

PPF_TBL

public static final java.lang.String PPF_TBL

See Also:

Constant Field Values

PU_TBL

public static final java.lang.String PU_TBL

See Also:

Constant Field Values

PARTNERUSER_TBL

public static final java.lang.String PARTNERUSER_TBL

See Also:

Constant Field Values

EXPOSED_FLDNAME

public static final java.lang.String EXPOSED_FLDNAME

See Also:

Constant Field Values

EXPOSED_FLDVALUE

public static final java.lang.String EXPOSED_FLDVALUE

See Also:

Constant Field Values

EXPOSED_FLDID

public static final java.lang.String EXPOSED_FLDID

See Also:

Constant Field Values

VIEW_PERMISSION

public static java.lang.String VIEW_PERMISSION

VIEW_EXTENDED_FIELDS

public static java.lang.String VIEW_EXTENDED_FIELDS

INCL_UNKNOWN

public static final java.lang.String INCL_UNKNOWN

See Also:

Constant Field Values

INCL_PENDING

public static final java.lang.String INCL_PENDING

See Also:

Constant Field Values

WITH_DLS

public boolean WITH_DLS

s_NegationPrefix

public static final java.lang.String s_NegationPrefix

See Also:

Constant Field Values

SEARCH_COLS

public static final java.lang.String[] SEARCH_COLS

For internal use only

Constructor Detail

ProfileQuery

public ProfileQuery()

Default query is "select * from partner".

Method Detail

getCursor

public com.wm.data.IDataCursor getCursor()

Specified by:

getCursor in interface com.wm.data.IData

getSharedCursor

public com.wm.data.IDataSharedCursor getSharedCursor()

Specified by:

getSharedCursor in interface com.wm.data.IData

getIndexCursor

public com.wm.data.IDataIndexCursor getIndexCursor()

For internal use only

Specified by:

getIndexCursor in interface com.wm.data.IData

getTreeCursor

public com.wm.data.IDataTreeCursor getTreeCursor()

For internal use only

Specified by:

getTreeCursor in interface com.wm.data.IData

getHashCursor

public com.wm.data.IDataHashCursor getHashCursor()

For internal use only

Specified by:

getHashCursor in interface com.wm.data.IData

create

public static com.wm.data.IData create()

For internal use only

setIncludeUnknown

public void setIncludeUnknown(boolean b)

isIncludeUnknown

public boolean isIncludeUnknown()

setIncludePending

public void setIncludePending(boolean b)

isIncudePending

public boolean isIncudePending()

setIntIdOnly

public void setIntIdOnly(boolean b)

isIntIdOnly

public boolean isIntIdOnly()

setWithDLS

public void setWithDLS(boolean b)

isWithDLS

public boolean isWithDLS()

getVisibleExtFlds

public java.util.Vector getVisibleExtFlds()

setCorporation

public void setCorporation(java.lang.String s)

Search for partner profile from corp name.

setCorporation

public void setCorporation(java.lang.String[][] opVal,
                           boolean isORquery)

Search for partner profiles using multiple criteria on corp name.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE p.CorporationName = 'AAA' OR p.CorporationName <> 'BBB' else if isORquery = false WHERE p.CorporationName = 'AAA' AND p.CorporationName <> 'BBB' )

setUnit

public void setUnit(java.lang.String s)

Search for partner profile from unit name.

setUnit

public void setUnit(java.lang.String[][] opVal,
                    boolean isORquery)

Search for partner profiles using multiple criteria on unit name.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE p.OrgUnitName = 'AAA' OR p.OrgUnitName <> 'BBB' else if isORquery = false WHERE p.OrgUnitName = 'AAA' AND p.OrgUnitName <> 'BBB' )

setID

public void setID(java.lang.String type,
                  java.lang.String value)

Search for partner profile from external id type description and value.

setID

public void setID(java.lang.String[][] typeVal,
                  boolean isORquery)

Search for partner profile from external id type description and value. The operator is always Query.OP_COMP_EQ, or "=".

Parameters:

typeValue - is the idtype, idvalue in String[][] the operator is always "=", Query class should automatically convert "=" to "LIKE" when wild card is presented (not implemented yet) (e.g. {{"DUNS", "12345678"}, {"EULER", "abcd"}, {null, "a%"}) if isORquery = true, the where clause is WHERE idt.type = pid.IDType AND (idt.Description = 'DUNS' AND pid.ExternalID = '12345678') OR (idt.Description = 'EULER' AND pid.ExternalID = 'abcd') OR (pid.ExternalId LIKE a%)

isORquery - should OR operator be used between these criteria

setUsername

public void setUsername(java.lang.String username)

setUsername

public void setUsername(java.lang.String[][] opVal,
                        boolean isORquery)

Search for partner profiles using multiple criteria on user name.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE pu.UserName = 'AAA' OR pu.UserName <> 'BBB' else if isORquery = false WHERE pu.UserName = 'AAA' AND pu.UserName <> 'BBB' )

setGroup

public void setGroup(java.lang.String s)

Search for partner profile from profile group name.

setGroup

public void setGroup(java.lang.String[][] opVal,
                     boolean isORquery)

Search for partner profiles using multiple criteria on profile group name.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE pg.GroupName = 'AAA' OR pg.GroupName <> 'BBB' else if isORquery = false WHERE pg.GroupName = 'AAA' AND pg.GroupName <> 'BBB' )

setStatus

public void setStatus(java.lang.String s)

Search for partner profile from partner profile status.

setStatus

public void setStatus(java.lang.String[][] opVal,
                      boolean isORquery)

Search for partner profiles using multiple criteria on profile status.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE p.Status = 'AAA' OR p.Status <> 'BBB' else if isORquery = false WHERE p.Status = 'AAA' AND p.Status <> 'BBB' )

setSubstatus

public void setSubstatus(java.lang.String s)

Search for partner profile from partner profile sub status.

setSubstatus

public void setSubstatus(java.lang.String[][] opVal,
                         boolean isORquery)

Search for partner profiles using multiple criteria on profile substatus.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE p.Substatus = 'AAA' OR p.Substatus <> 'BBB' else if isORquery = false WHERE p.Substatus = 'AAA' AND p.Substatus <> 'BBB' )

setCity

public void setCity(java.lang.String s)

Search for partner profile from address - city.

setCity

public void setCity(java.lang.String[][] opVal,
                    boolean isORquery)

Search for partner profiles using multiple criteria on city.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE a.City = 'AAA' OR a.City <> 'BBB' else if isORquery = false WHERE a.City = 'AAA' AND a.City <> 'BBB' )

setState

public void setState(java.lang.String s)

Search for partner profile from address - state.

setState

public void setState(java.lang.String[][] opVal,
                     boolean isORquery)

Search for partner profiles using multiple criteria on state.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE a.State_Province = 'AAA' OR a.State_Province <> 'BBB' else if isORquery = false WHERE a.State_Province = 'AAA' AND a.State_Province <> 'BBB' )

setZip

public void setZip(java.lang.String s)

Search for partner profile from address - zip.

setZip

public void setZip(java.lang.String[][] opVal,
                   boolean isORquery)

Search for partner profiles using multiple criteria on zip.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE a.Zip_PostalCode = 'AAA' OR a.Zip_PostalCode <> 'BBB' else if isORquery = false WHERE a.Zip_PostalCode = 'AAA' AND a.Zip_PostalCode <> 'BBB' )

setCountry

public void setCountry(java.lang.String s)

Search for partner profile from address - country.

setCountry

public void setCountry(java.lang.String[][] opVal,
                       boolean isORquery)

Search for partner profiles using multiple criteria on country.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})

isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE a.Country = 'AAA' OR a.Country <> 'BBB' else if isORquery = false WHERE a.Country = 'AAA' AND a.Country <> 'BBB' )

getCorporation

public java.lang.Object getCorporation()

Returns:

the corporation name criterion.

getUnit

public java.lang.Object getUnit()

Returns:

the unit name criterion.

getIDType

public java.lang.Object getIDType()

Returns:

the external id type criterion.

getIDValue

public java.lang.Object getIDValue()

Returns:

the external id value criterion.

getGroup

public java.lang.Object getGroup()

Returns:

the profile group name criterion.

getUsername

public java.lang.Object getUsername()

Returns:

the profile username criterion

getStatus

public java.lang.Object getStatus()

Returns:

the partner profile status criterion.

getSubstatus

public java.lang.Object getSubstatus()

Returns:

the partner profile status criterion.

getCity

public java.lang.Object getCity()

Returns:

the address - city criterion.

getState

public java.lang.Object getState()

Returns:

the address - state criterion.

getZip

public java.lang.Object getZip()

Returns:

the address - zip criterion.

getCountry

public java.lang.Object getCountry()

Returns:

the address -country criterion.

getExtFldQueries

public final java.util.Vector getExtFldQueries()

Get all extended field queries.

setExtFldQuery

public void setExtFldQuery(java.lang.String fldId,
                           java.lang.String op,
                           java.lang.String val)

Add an extended field query. Note all queries are "AND"ed in SQL where clause. This method also replaces old query criterion with new query criterion if it's for the same ext fld.

setExtFieldQuery

public void setExtFieldQuery(java.lang.String fld,
                             java.lang.String[][] opVal,
                             boolean isORquery)

Search for partner profile from extended field value

Parameters:

fld - is FieldName:GroupName

opValue - is the operator, value in String[][] (e.g. {{Query.OP_COMP_EQ, "icecream"}, {Query.OP_COMP_NEQ, "apple pie"}})

isORquery - should OR operator be used between these criteria

setExtFldQuery

public void setExtFldQuery(java.lang.String fldId,
                           java.lang.String[][] opVal,
                           boolean isORquery)

Search for partner profile from extended field value

Parameters:

fldId - is PartnerProfileField.ProfileFieldID

opValue - is the operator, value in String[][] (e.g. {{Query.OP_COMP_EQ, "icecream"}, {Query.OP_COMP_NEQ, "apple pie"}})

isORquery - should OR operator be used between these criteria

clearExtFldQuery

public void clearExtFldQuery(java.lang.String extFld)

Clear ext fld query for the specified ext fld.

clearAllExtFldQueries

public void clearAllExtFldQueries()

Clear all ext fld queries.

setSortColumn

public void setSortColumn(java.lang.String col,
                          boolean asc)

Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])

getSortColumn

public java.lang.String getSortColumn()

Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])

setSortColumns

public void setSortColumns(java.lang.String[][] columnOrder)

Set the sort columns and order for this query. Make sure to use one of the constants above: CORP, STATUS, etc. Trying to sort on a column that's not visible will be ignored.

Overrides:

setSortColumns in class Query

Parameters:

columnOrder - takes column names and sort orders (e.g. {{CORP, "ASC"}, {STATUS, "DESC"}} )

getSortColumns

public java.lang.String[][] getSortColumns()

Get the sort columns in the format of {{CORP, "ASC"}, {STATUS, "DESC"}}.

isSortAscending

public boolean isSortAscending()

clearSortColumn

public void clearSortColumn()

setCorporationVisible

public void setCorporationVisible(boolean b)

setUnitVisible

public void setUnitVisible(boolean b)

setIDVisible

public void setIDVisible(boolean b)

setGroupVisible

public void setGroupVisible(boolean b)

setStatusVisible

public void setStatusVisible(boolean b)

setSubstatusVisible

public void setSubstatusVisible(boolean b)

setCityVisible

public void setCityVisible(boolean b)

setStateVisible

public void setStateVisible(boolean b)

setZipVisible

public void setZipVisible(boolean b)

setCountryVisible

public void setCountryVisible(boolean b)

setInternalIDVisible

public void setInternalIDVisible(boolean b)

setUsernameVisible

public void setUsernameVisible(boolean b)

isCorporationVisible

public boolean isCorporationVisible()

isUnitVisible

public boolean isUnitVisible()

isIDVisible

public boolean isIDVisible()

isGroupVisible

public boolean isGroupVisible()

isStatusVisible

public boolean isStatusVisible()

isSubstatusVisible

public boolean isSubstatusVisible()

isCityVisible

public boolean isCityVisible()

isStateVisible

public boolean isStateVisible()

isZipVisible

public boolean isZipVisible()

isCountryVisible

public boolean isCountryVisible()

isInternalIDVisible

public boolean isInternalIDVisible()

isUsernameVisible

public boolean isUsernameVisible()

setExtFldVisible

public void setExtFldVisible(java.lang.String fldId,
                             boolean show)

isExtFldVisible

public boolean isExtFldVisible(java.lang.String fldId)

preSql

public void preSql()

Description copied from class: Query

For internal use only

Overrides:

preSql in class Query

getVisibleColumns

public java.util.Enumeration getVisibleColumns()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

setGenericQuery

public void setGenericQuery(java.lang.String query)

setKeywordQuery

public void setKeywordQuery(java.lang.String[] keywords)

getGenericQuery

public java.lang.String getGenericQuery()

setIsQueryOnID

public void setIsQueryOnID(boolean b)

isQueryOnID

public boolean isQueryOnID()

setViewPermission

public void setViewPermission(java.lang.String viewPermission)

Overrides:

setViewPermission in class Query