psdi.app.signature

Interface QuerySetRemote

All Superinterfaces:

MboAccessInterface, MboSetRemote, java.rmi.Remote, Transactable

All Known Implementing Classes:

QuerySet

public interface QuerySetRemote
extends MboSetRemote

Remote Interface to the set of Query. Constants for relationships defined in the 'MAXRELATIONSHIP' table are declared here.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	DEFAULTFORAPP Relationship to DefaultQuery (defaultquery.app = query.app and defaultquery.username = the user who owns this Query MboSet, not the Query.Owner attribute).
static java.lang.String	DEFAULTQUERY Relationship to DefaultQuery (defaultquery.clausename = query.clausename and defaultquery.app = query.app).
static java.lang.String	MAXAPPS Relationship to MaxApps (maxapps.app = query.app).
static java.lang.String	THISUSERDEFAULT Relationship to DefaultQuery (defaultquery.clausename = query.clausename and defaultquery.app = query.app and defaultquery.username = the user who owns this Query MboSet, not the Query.Owner attribute).

Fields inherited from interface psdi.mbo.MboSetRemote

INSERTONLY, INSERTORUPDATE, UPDATEONLY

Method Summary

Modifier and Type	Method and Description
void	addAndSaveQuery(java.lang.String appName, java.lang.String clauseName, java.lang.String clause, boolean isPublic, boolean isDefault, java.lang.String description)
void	getQueriesForUser(java.lang.String appName)
void	getQueriesForUser(java.lang.String appName, java.lang.String orderBy)
void	validateSqlExpression(java.lang.String objectname, java.lang.String expression)

Methods inherited from interface psdi.mbo.MboSetRemote

abortSql, add, add, addAtEnd, addAtEnd, addAtIndex, addAtIndex, addFakeAtEnd, addSubQbe, addSubQbe, addSubQbe, addSubQbe, addWarning, addWarnings, checkMethodAccess, cleanup, clear, clearLongOpPipe, close, commit, copy, copy, copyForDM, count, count, deleteAll, deleteAll, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemoveAll, deleteAndRemoveAll, determineRequiredFieldsFromERM, earliestDate, fetchNext, findAllNullRequiredFields, findByIntegrationKey, findKey, getApp, getAppAlwaysFieldFlags, getAppWhere, getCompleteWhere, getCurrentPosition, getDBFetchMaxRows, getDefaultValue, getERMEntity, getESigTransactionId, getExcludeMeFromPropagation, getFlags, getKeyAttributes, getList, getList, getMaxMessage, getMbo, getMbo, getMboForUniqueId, getMboSetData, getMboSetData, getMboSetInfo, getMboSetRetainMboPositionData, getMboSetRetainMboPositionInfo, getMboSetValueData, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMLFromClause, getMXTransaction, getName, getOrderBy, getOwner, getParentApp, getProfile, getQbe, getQbe, getQbe, getQbeWhere, getQueryTimeout, getRelationName, getRelationship, getSelection, getSelectionWhere, getSetOrderByForUI, getSize, getSQLOptions, getTxnPropertyMap, getUserAndQbeWhere, getUserInfo, getUserName, getUserWhere, getWarnings, getWhere, getZombie, hasMLQbe, hasQbe, hasWarnings, ignoreQbeExactMatchSet, incrementDeletedCount, init, isBasedOn, isDMDeploySet, isDMSkipFieldValidation, isDownloadSet, isEmpty, isESigNeeded, isFlagSet, isQbeCaseSensitive, isQbeExactMatch, isRetainMboPosition, latestDate, locateMbo, logESigVerification, max, min, moveFirst, moveLast, moveNext, movePrev, moveTo, newMboIndex, notExist, positionState, processML, remove, remove, remove, reset, resetQbe, resetWithSelection, rollback, rollbackToCheckpoint, rollbackToCheckpoint, save, save, select, select, select, selectAll, setAllowQualifiedRestriction, setApp, setAppAlwaysFieldFlag, setAppWhere, setAutoKeyFlag, setDBFetchMaxRows, setDefaultOrderBy, setDefaultValue, setDefaultValue, setDefaultValues, setDMDeploySet, setDMSkipFieldValidation, setDownloadSet, setERMEntity, setESigFieldModified, setExcludeMeFromPropagation, setFlag, setFlag, setFlags, setInsertCompanySet, setInsertItemSet, setInsertOrg, setInsertSite, setLastESigTransId, setLogLargFetchResultDisabled, setMboSetInfo, setMXTransaction, setNoNeedtoFetchFromDB, setOrderBy, setOwner, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeCaseSensitive, setQbeCaseSensitive, setQbeExactMatch, setQbeExactMatch, setQbeOperatorOr, setQueryBySiteQbe, setQueryTimeout, setRelationName, setRelationship, setRequiedFlagsFromERM, setRetainMboPosition, setSetOrderByForUI, setSQLOptions, setTableDomainLookup, setTxnPropertyMap, setupLongOpPipe, setUserWhere, setUserWhereAfterParse, setWhere, setWhereQbe, smartFill, smartFill, smartFind, smartFind, startCheckpoint, startCheckpoint, sum, toBeSaved, undeleteAll, unselect, unselect, unselect, unselectAll, useStoredQuery, validate, verifyESig

Methods inherited from interface psdi.mbo.MboAccessInterface

getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getString, isNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull

Methods inherited from interface psdi.txn.Transactable

commitTransaction, fireEventsAfterDB, fireEventsAfterDBCommit, fireEventsBeforeDB, rollbackTransaction, saveTransaction, undoTransaction, validateTransaction

Field Detail

DEFAULTQUERY

static final java.lang.String DEFAULTQUERY

Relationship to DefaultQuery (defaultquery.clausename = query.clausename and defaultquery.app = query.app). The result set will contain zero or mroe objects.

See Also:

Constant Field Values

MAXAPPS

static final java.lang.String MAXAPPS

Relationship to MaxApps (maxapps.app = query.app). The result set will normally contain one object, assuming the app exists in only one module.

See Also:

Constant Field Values

THISUSERDEFAULT

static final java.lang.String THISUSERDEFAULT

Relationship to DefaultQuery (defaultquery.clausename = query.clausename and defaultquery.app = query.app and defaultquery.username = the user who owns this Query MboSet, not the Query.Owner attribute). The result set will contain zero or one object. If the result set is not empty, then this Query is the default query for this user and app.

See Also:

Constant Field Values

DEFAULTFORAPP

static final java.lang.String DEFAULTFORAPP

Relationship to DefaultQuery (defaultquery.app = query.app and defaultquery.username = the user who owns this Query MboSet, not the Query.Owner attribute). The result set will contain zero or one object.

See Also:

Constant Field Values

Method Detail

addAndSaveQuery

void addAndSaveQuery(java.lang.String appName,
                     java.lang.String clauseName,
                     java.lang.String clause,
                     boolean isPublic,
                     boolean isDefault,
                     java.lang.String description)
              throws MXException,
                     java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

See Also:

QuerySet.addAndSaveQuery(java.lang.String, java.lang.String, java.lang.String, boolean, boolean, java.lang.String)

getQueriesForUser

void getQueriesForUser(java.lang.String appName)
                throws MXException,
                       java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

See Also:

QuerySet.getQueriesForUser(String)

getQueriesForUser

void getQueriesForUser(java.lang.String appName,
                       java.lang.String orderBy)
                throws MXException,
                       java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

See Also:

QuerySet.getQueriesForUser(String,String)

validateSqlExpression

void validateSqlExpression(java.lang.String objectname,
                           java.lang.String expression)
                    throws MXException,
                           java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

See Also:

QuerySet.validateSqlExpression(String,String)