com.ibm.tivoli.maximo.skd.app

Class SKDQuery

java.lang.Object

psdi.mbo.Mbo

com.ibm.tivoli.maximo.skd.app.SKDQuery

All Implemented Interfaces:

SKDQueryRemote, java.rmi.Remote, MboConstants, MboRemote, MaxRemoteProxy

public class SKDQuery
extends Mbo
implements SKDQueryRemote

MBO object to represent SKDQuery. See Scheduler package description for details.

This is a system level object.

The key attributes for this object is: NAME, OBJECTNAME, QUERYNAME.

The attributes in this object are as follows:

Attribute Name	Description
OBJECTNAME	Identifies the type of work/resource records that will be retrieved using the query.
QUERYNAME	Identifies the query that will be used to retrieve work/resource records. This value must be unique.
WHERECLAUSE	SQL expression that will be used to retrieve work/resource records.
SKDOBJECTNAME	SKD Object Name.
SKDQUERYID	Unique Id.
DESCRIPTION	Describes the query.
EXPOBJECT	Expression builder Object.
NAME	Identifies the schedule in the SKDProject(for a schedule). This value must be unique. The schedule consists of a group of work records and their required resources. The schedule can be viewed and edited in the Gantt View tab.

Field Summary

Fields inherited from class psdi.mbo.Mbo

MULTILANGCOPY, phantomList, phantomQueue

Fields inherited from interface psdi.mbo.MboConstants

ALLROWS, CHANGEDBY_USER, COUNT_ADDITIONS, COUNT_AFTERSAVE, COUNT_DATABASE, COUNT_DELETED, COUNT_EXISTING, DBCONFIG, DELAYVALIDATION, DELAYVALIDATIONONLY, DISCARDABLE, GOTCOMPLETEWHERE, HIDDEN, NO_RELATEDMBOS_OF_OWNERSCHILDREN_FETCH, NOACCESSCHECK, NOACTION, NOADD, NOCOMMIT, NODELETE, NONE, NOOVERWRITE, NOSAVE, NOSETVALUE, NOUPDATE, NOVALIDATION, NOVALIDATION_AND_NOACTION, NOVALIDATION_AND_NOACTION_ALLOWCROSSOVER, READONLY, REBUILD, REQUIRED, SAMEVALUEVALIDATION, SETBYPARENT, USER

Constructor Summary

Constructors

Constructor and Description
SKDQuery(MboSet ms) Constructs the SKDQuery object.

Method Summary

Methods

Modifier and Type	Method and Description
void	add() Adds a new SKDQuery(SKDACTQUERY,SKDRESQUERY,SKDLABORQUERY) object for the 'Work Queries', 'Additional Resources' and 'Resource Availability'.
void	canDelete() Before delete, here we check, If the Schedule(SKDProject) is been createdby the loggedin user.
void	copyQuerys(MboSetRemote querySet) Used to copy the selected queries from Query to SKDQuery depends on, 'Work Queries - SKDACTQUERY' or ' 'Additional Resources - SKDRESQUERY'.
java.lang.String	getDefaultObjectName(java.lang.String relationShipName) Return the default object name to be used for filling in for a new query.
java.util.Hashtable<java.lang.String,java.lang.String>	getQuickQueryQbe() This method returns the hash table for the given queryid.
void	init() Initialization routine.
void	modify() This is called whenever a change is made to the attributes of SKDQuery.
void	propagateKeyValue(java.lang.String keyName, java.lang.String keyValue) Set value for NAME.
void	saveQuickQueryQbe(java.util.Hashtable<java.lang.String,java.lang.String> savedQbeAttributes) This method will be called from the data bean to save the quick query qbe in the hashtable.
void	setQueryValues(java.lang.String whereClause) This method is called from the bean to set current query whereclause.

Methods inherited from class psdi.mbo.Mbo

addMboSetForRequiredCheck, addToDeleteForInsertList, andEvaluateConditions, appValidate, blindCopy, checkFieldAccess, checkMethodAccess, checkMethodAccess, checkQualifiedRestriction, checkSiteOrgAccessForSave, clear, copy, copy, copy, copyFake, copyValue, copyValue, createComm, delete, delete, determineRequiredFieldsFromERM, duplicate, enableMethod, evaluateCondition, evaluateCondition, evaluateCtrlConditions, evaluateCtrlConditions, evaluateRestriction, excludeObjectForPropagate, findAllNullRequiredFields, fireEvent, generateAutoKey, generateContentUID, getAlwaysFlags, getAttrRestrictionFlag, getAttrRestrictions, getBoolean, getByte, getBytes, getCheckpoint, getClientLocale, getClientTimeZone, getCommLogOwnerNameAndUniqueId, getCondition, getDatabaseValue, getDate, getDeleteForInsertList, getDocLinksCount, getDomainFilterWhere, getDomainIDs, getDouble, getExistingMboSet, getFetchIndex, getFieldExceptions, getFlags, getFloat, getIgnoreLockCheck, getInitialValue, getInsertCompanySetId, getInsertItemSetId, getInsertOrganization, getInsertSite, getInstanciatedMboSet, getInstanciatedMboValue, getInt, getIntegrationService, getKeyValue, getLanguageRecordRowStamp, getLinesRelationship, getList, getLockedByDisplayName, getLockedByUserID, getLong, getMatchingAttr, getMatchingAttr, getMatchingAttrs, getMaxMessage, getMboData, getMboDataSet, getMboForAttribute, getMboForAttributeStatic, getMboInitialValue, getMboList, getMboLogger, getMboRecordData, getMboServer, getMboSet, getMboSet, getMboSet, getMboSetInfo, getMboValue, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMXTransaction, getName, getOrgForGL, getOrgSiteForMaxvar, getOwner, getProfile, getPropagateKeyFlag, getProxy, getRecordIdentifer, getRecordMboName, getRelatedWhere, getRelatedWhere, getRelationshipNameToLangTable, getRowRestrictionFlag, getRowStamp, getSecurityLogger, getSiteOrg, getSqlLogger, getString, getString, getStringInBaseLanguage, getStringInSpecificLocale, getStringTransparent, getSynonymValueWhere, getTenantId, getThisMboSet, getTranslator, getUniqueIdentifer, getUniqueIDName, getUniqueIDValue, getUserInfo, getUserName, getValidateOrder, hasFieldAccess, hasHierarchyLink, hasLockSaveRights, hasRelatedQbe, hasUniqueID, initFieldFlagsOnMbo, initRelationship, isAutoKeyed, isBasedOn, isChangeByUserWhenSetFromLookup, isEAuditFieldModified, isESigFieldModified, isFlagSet, isForDM, isLocked, isLocked, isLockedByMe, isMasterTenant, isMboLockedByMe, isModified, isModified, isNew, isNull, isOptionGranted, isSelected, isSkipCopyField, isValid, isZombie, lock, moveFieldFlagsToMboValue, needCallInitFieldFlag, orEvaluateConditions, removeRelatedSet, rollbackToCheckpoint, select, setAppDefaultValue, setApplicationError, setApplicationRequired, setAutokeyFields, setCopyDefaults, setDefaultValue, setDefaultValues, setDeleted, setEAuditFieldModified, setESigFieldModified, setFetchIndex, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlags, setFlag, setFlag, setFlags, setForDM, setHierarchyLink, setIgnoreRecordLockCheck, setLangCodeDefault, setMLValue, setModified, setNewMbo, setPropagateKeyFlag, setPropagateKeyFlag, setProxy, setReadonlyWhenParentIsReadonly, setReferencedMbo, setReferencedMbo, setUniqueIDValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueFromSequence, setValueNull, setValueNull, sigopGranted, sigopGranted, sigopGranted, sigOptionAccessAuthorized, smartFill, smartFind, smartFind, smartFindByObjectName, smartFindByObjectName, smartFindByObjectNameDirect, startCheckpoint, thisToBeUpdated, toBeAdded, toBeDeleted, toBeSaved, toBeUpdated, toBeValidated, undelete, unlock, unselect, useDataSecurity, validate, validateAttributes, validateKeyUniqueness, valueChanged

Methods inherited from class java.lang.Object

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

Methods inherited from interface psdi.mbo.MboRemote

addMboSetForRequiredCheck, addToDeleteForInsertList, blindCopy, checkMethodAccess, clear, copy, copy, copy, copyFake, copyValue, copyValue, createComm, delete, delete, duplicate, evaluateCondition, evaluateCtrlConditions, evaluateCtrlConditions, excludeObjectForPropagate, generateAutoKey, getBoolean, getByte, getBytes, getCommLogOwnerNameAndUniqueId, getDatabaseValue, getDate, getDeleteForInsertList, getDocLinksCount, getDomainIDs, getDouble, getExistingMboSet, getFlags, getFloat, getIgnoreLockCheck, getInitialValue, getInsertCompanySetId, getInsertItemSetId, getInsertOrganization, getInsertSite, getInt, getKeyValue, getLinesRelationship, getList, getLockedByDisplayName, getLong, getMatchingAttr, getMatchingAttr, getMatchingAttrs, getMaxMessage, getMboData, getMboDataSet, getMboInitialValue, getMboList, getMboSet, getMboSet, getMboSet, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMXTransaction, getName, getOrgForGL, getOrgSiteForMaxvar, getOwner, getPropagateKeyFlag, getRecordIdentifer, getSiteOrg, getString, getString, getStringInBaseLanguage, getStringInSpecificLocale, getStringTransparent, getThisMboSet, getUniqueIDName, getUniqueIDValue, getUserInfo, getUserName, hasHierarchyLink, hasLockSaveRights, isAutoKeyed, isBasedOn, isFlagSet, isForDM, isLocked, isLocked, isMasterTenant, isMboLockedByMe, isModified, isModified, isNew, isNull, isOptionGranted, isSelected, isZombie, lock, rollbackToCheckpoint, select, setApplicationError, setApplicationRequired, setAutokeyFields, setCopyDefaults, setDeleted, setESigFieldModified, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlags, setFlag, setFlag, setFlags, setForDM, setIgnoreRecordLockCheck, setMLValue, setModified, setNewMbo, setPropagateKeyFlag, setPropagateKeyFlag, setReferencedMbo, setReferencedMbo, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull, sigopGranted, sigopGranted, sigopGranted, sigOptionAccessAuthorized, smartFill, smartFind, smartFind, smartFindByObjectName, smartFindByObjectName, smartFindByObjectNameDirect, startCheckpoint, thisToBeUpdated, toBeAdded, toBeDeleted, toBeSaved, toBeUpdated, toBeValidated, undelete, unlock, unselect, validate, validateAttributes

Constructor Detail

SKDQuery

public SKDQuery(MboSet ms)
         throws java.rmi.RemoteException

Constructs the SKDQuery object.

Parameters:

ms - MboSet

Throws:

java.rmi.RemoteException

Method Detail

getDefaultObjectName

public java.lang.String getDefaultObjectName(java.lang.String relationShipName)
                                      throws MXException,
                                             java.rmi.RemoteException

Return the default object name to be used for filling in for a new query.

Parameters:

relationShipName -

Returns:

Throws:

MXException

java.rmi.RemoteException

add

public void add()
         throws MXException,
                java.rmi.RemoteException

Adds a new SKDQuery(SKDACTQUERY,SKDRESQUERY,SKDLABORQUERY) object for the 'Work Queries', 'Additional Resources' and 'Resource Availability'.

Specified by:

add in interface MboRemote

Overrides:

add in class Mbo

Parameters:

none -

Throws:

MXException, - RemoteException

MXException

java.rmi.RemoteException

init

public void init()
          throws MXException

Initialization routine. If the loggedin user is not the creator of the current schedule, then Schedule and associated 'Work Queries', 'Additional Resources' are not editable.

Overrides:

init in class Mbo

Parameters:

none -

Throws:

MXException

propagateKeyValue

public void propagateKeyValue(java.lang.String keyName,
                     java.lang.String keyValue)
                       throws MXException,
                              java.rmi.RemoteException

Set value for NAME.

Specified by:

propagateKeyValue in interface MboRemote

Overrides:

propagateKeyValue in class Mbo

Parameters:

keyName - Should equal "NAME" or else nothing will be propagated.

keyValue - The new value of NAME.

Throws:

MXException

java.rmi.RemoteException

modify

public void modify()
            throws MXException,
                   java.rmi.RemoteException

This is called whenever a change is made to the attributes of SKDQuery. When any field related to SKDQuery is changed, the owner SKDProject's change date/change by is updated.

Overrides:

modify in class Mbo

Throws:

MXException

java.rmi.RemoteException

copyQuerys

public void copyQuerys(MboSetRemote querySet)
                throws MXException,
                       java.rmi.RemoteException

Used to copy the selected queries from Query to SKDQuery depends on, 'Work Queries - SKDACTQUERY' or ' 'Additional Resources - SKDRESQUERY'. If the Selected Query exists in SKDQuery for the 'Work Queries - SKDACTQUERY' or ' 'Additional Resources - SKDRESQUERY', then we make the duplicate of that 'selected existing query' with extension 'Copy plus some number', then you can edit the QueryName in the UI before save is clicked. And also if the selected Query doesn't exist in the SKDQuery then we copy that query, to the SKDQuery (Work or Resources) object as a new record.

Specified by:

copyQuerys in interface SKDQueryRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

copyQuerys(MboSetRemote querySet)

canDelete

public void canDelete()
               throws MXException,
                      java.rmi.RemoteException

Before delete, here we check, If the Schedule(SKDProject) is been createdby the loggedin user. If logged in user is not the same as schedule creator, then throw the message. The logged in user cannot delete the 'Query'.

Overrides:

canDelete in class Mbo

Throws:

MXException

java.rmi.RemoteException

MXApplicationException

setQueryValues

public void setQueryValues(java.lang.String whereClause)
                    throws MXException,
                           java.rmi.RemoteException

This method is called from the bean to set current query whereclause.

Specified by:

setQueryValues in interface SKDQueryRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

setQueryValues(String whereClause)

saveQuickQueryQbe

public void saveQuickQueryQbe(java.util.Hashtable<java.lang.String,java.lang.String> savedQbeAttributes)
                       throws MXException,
                              java.rmi.RemoteException

This method will be called from the data bean to save the quick query qbe in the hashtable.

Specified by:

saveQuickQueryQbe in interface SKDQueryRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

com.ibm.tivoli.maximo.skd.app.SKDQuery#saveQuickQueryQbe( HashtablesavedQbeAttributes)

getQuickQueryQbe

public java.util.Hashtable<java.lang.String,java.lang.String> getQuickQueryQbe()
                                                                        throws MXException,
                                                                               java.rmi.RemoteException

This method returns the hash table for the given queryid. If the queryid is not found, it will return null.

Specified by:

getQuickQueryQbe in interface SKDQueryRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

com.ibm.tivoli.maximo.skd.app.SKDQuerySet#Hashtable getQBE(long queryid)