psdi.app.assetcatalog

Class SpecificationMboSet

java.lang.Object

psdi.mbo.MboSet

psdi.app.assetcatalog.SpecificationMboSet

All Implemented Interfaces:

java.rmi.Remote, SpecificationMboSetRemote, MboAccessInterface, MboConstants, MboSetRemote, MaxRemoteProxy, Transactable, FixedLoggerNames, FixedLoggers

Direct Known Subclasses:

ActCISpecSet, AssetFeatureSpecSet, AssetSpecSet, BIMProductBaseSpecSet, CISpecSet, FeatureSpecSet, ItemSpecSet, JobPlanSpecSet, JobTaskSpecSet, LocationSpecSet, PDSpecSet, SolutionSpecSet, TicketSpecSet, TKTemplateSpecSet, TKTempltActySpecSet, WorkOrderSpecSet

public abstract class SpecificationMboSet
extends MboSet
implements SpecificationMboSetRemote

Represents the set of Specifications.

Field Summary

Fields

Modifier and Type	Field and Description
MboRemote	currentClassSpecUseWithMbo PERFORMANCE TESTING: passing the ClassSpecUseWith, instead of re-fetch, used in assetcatalogservice.generatespecset
java.lang.String	dbUpper
MboSetRemote	mboSetAttributeSearch 07-17112

Fields inherited from class psdi.mbo.MboSet

fetchStopLimitEnabled, LOOKUPMAXROW, maxSorterSize, mboCountCleanuplist, perfStats, strNoBaseLangValueEntered

Fields inherited from interface psdi.mbo.MboSetRemote

INSERTONLY, INSERTORUPDATE, UPDATEONLY

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

Fields inherited from interface psdi.util.logging.FixedLoggers

APPLOGGER, CRONTASKLOGGER, CRONTASKMGRLOGGER, CRONTASKMGRSQLLOGGER, DBCONNECTIONLOGGER, DDLOGGER, DMLOGGER, EVENTLOGGER, EXCEPTIONLOGGER, MAILLOGGER, MAXIMOLOGGER, MTLOGGER, NULLMBOPOINTER, SECURITY, SENDFAILEDLOGGER, SERVICELOGGER, SQLLOGGER

Fields inherited from interface psdi.util.logging.FixedLoggerNames

appenderPrefix, LOGGERNAME_APP, LOGGERNAME_CRONTASK, LOGGERNAME_CRONTASKMGR, LOGGERNAME_DBCONNECTION, LOGGERNAME_DD, LOGGERNAME_DM, LOGGERNAME_DMPREVIEW, LOGGERNAME_EVENT, LOGGERNAME_EXCEPTION, LOGGERNAME_MAIL, LOGGERNAME_MAXIMO, LOGGERNAME_MT, LOGGERNAME_NULLMBOPOINTER, LOGGERNAME_SECURITY, LOGGERNAME_SENDFAILED, LOGGERNAME_SERVICE, LOGGERNAME_SQL, LOGGERNAME_SQL_CRONTASKMGR, LOGGERNAME_TXN, loggerPrefix

Constructor Summary

Constructors

Constructor and Description
SpecificationMboSet(MboServerInterface ms)

Method Summary

Modifier and Type	Method and Description
void	canAdd() Cannot add a new specifictaion attribute if the owner does not have a classstructureid.
void	checkCommonSpecDuplicates(MboRemote currentClassSpec) Check to see if the combination of classstructureid/assetattrid/section already exists in other specification records currently in this set.
boolean	checkValueExists(java.lang.String attrName, java.lang.String attrValue) Checks if there are records that meet the attrName, attrValue setQBE() command.
MboSetRemote	getAttributesSearchMboSet() 07-17112: get the MboSet from which attribute search is launched
MboRemote	getCurrentClassSpecUseWithMbo() PERFORMANCE TESTING: passing the ClassSpecUseWith, instead of re-fetch.
java.lang.String	getGeneratedDesc() Loops thru the current set and returns a concatinated string based on the corresponding classspec.ATTRDESCPREFIX, alnvalue/numvalue, and measureunit.abbreviation/or measureunitid.
java.lang.String	getGeneratedDescWithQbe(MboSetRemote dbRelationshipSet) 08-15740: this SpecSet has qbe.
boolean	isLinear() 08-13571: DO NOT OVERRIDE this unless your SpecificationSet is related to LINEAR functionality.
void	setAttributesSearchMboSet(MboSetRemote mboSet) 07-17112: set the mboset from the Classification Attribute Search
void	setCurrentClassSpecUseWithMbo(MboRemote classSpeUseWith) PERFORMANCE TESTING: passing the ClassSpecUseWith, instead of re-fetch.
void	setDescGenerated(java.lang.String desc) 07-16935:description needs to be generated by one specification mbo
MboRemote[]	sortThisSetByDisplaySeq() 09-12625: This spec set may be new mbos, need to sort in mboset
boolean	toCheckClassSpecUseWith() 12-11553/IV17979:DO NOT OVERRIDE this method unless you need to.
boolean	toCreateNewSpecRecordsInMainObject() DO NOT OVERRIDE this method unless you need to.
boolean	wasDescGenerated() 07-16935:description needs to be generated by one specification mbo
java.lang.String	whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues)
java.lang.String	whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues, java.lang.String classstructureid) For Asset Catalog Search - returns a String to the caller.

Methods inherited from class psdi.mbo.MboSet

abortSql, add, add, addAtEnd, addAtEnd, addAtIndex, addAtIndex, addFakeAtEnd, addFederatedMboToSorter, addSubQbe, addSubQbe, addSubQbe, addSubQbe, addToEndOfSelectStatement, addWarning, addWarnings, appendToWhere, applyRowSecurity, avg, cancelAndClose, checkMethodAccess, checkMethodAccess, cleanup, clear, clearBatchedPreparedStmt, clearBatchedPreparedStmts, clearESigTransactionIdThread, clearESigTransIDForAdmin, clearIgnoredAutokeyAttrs, clearLongOpPipe, clearToBeSaved, clearTransactionReference, clearWarnings, close, commit, commitTransaction, copy, copy, copy, copyForDM, count, count, deleteAll, deleteAll, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemoveAll, deleteAndRemoveAll, determineRequiredFieldsFromERM, dump, earliestDate, enableMethod, executeBatch, fetchNext, findAllNullRequiredFields, findByIntegrationKey, findKey, fireEventsAfterDB, fireEventsAfterDBCommit, fireEventsBeforeDB, forceDBSort, getAllowQualifiedRestriction, getAlwaysFlags, getAlwaysFlags, getApp, getAppAlwaysFieldFlags, getAppWhere, getAttrRestrictions, getBoolean, getByte, getBytes, getClientLocale, getClientTimeZone, getCompleteWhere, getCurrentPosition, getDate, getDBFetchMaxRows, getDefaultValue, getDefaultValueHash, getDouble, getERMEntity, getESigTransactionId, getExcludeMeFromPropagation, getFlags, getFloat, getIgnoredAutokeyAttrs, getInsertCompanySet, getInsertItemSet, getInsertOrg, getInsertSite, getInt, getJspDefaultValueHash, getKeyAttributes, getList, getList, getLong, getMaxAppsWhere, getMaxMessage, getMbo, getMbo, getMboForUniqueId, getMboLogger, getMboServer, getMboSetData, getMboSetData, getMboSetInfo, getMboSetRetainMboPositionData, getMboSetRetainMboPositionInfo, getMboSetValueData, getMboSetValueData, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMLFromClause, getMultiSiteWhere, getMXTransaction, getName, getOrderBy, getOwner, getParentApp, getPreparedStmt, getProfile, getProxy, getQbe, getQbe, getQbe, getQbeSiteAuthorization, getQbeWhere, getQualifiedWhere, getQueryTimeout, getRelationName, getRelationship, getRowRestrictions, getSecurityLogger, getSelection, getSelectionWhere, getSetOrderByForUI, getSharedMboSet, getSize, getSkipFirstNRows, getSqlLogger, getSQLOptions, getString, getTxnPropertyMap, getUserAndQbeWhere, getUserInfo, getUserName, getUserPrefWhere, getUserWhere, getUserWhere, getWarnings, getWhere, getZombie, handleMLMbo, handleMLMbo, hasMLQbe, hasQbe, hasWarnings, ignoreAutokeyAttr, ignoreAutokeyAttr, ignoreQbeExactMatchSet, incrementDeletedCount, init, init, initDataDictionary, isBasedOn, isClosed, isDeltaStorage, isDMDeploySet, isDMSkipFieldValidation, isEAuditFieldModified, isEmpty, isESigFieldModified, isESigNeeded, isFlagSet, isIgnoreQbeExactMatchSet, isLookup, isNull, isQbeCaseSensitive, isQbeExactMatch, isRetainMboPosition, isTableDomainLookup, latestDate, locateMbo, logESigVerification, logRowUpdatedException, max, min, moveFirst, moveLast, moveNext, movePrev, moveTo, moveToKey, newMboIndex, notExist, positionState, processML, remove, remove, remove, reset, resetForRefreshOnSave, resetQbe, resetWithSelection, rollback, rollbackToCheckpoint, rollbackToCheckpoint, rollbackTransaction, save, save, save, save, saveMbos, saveTransaction, select, select, select, selectAll, setAllowQualifiedRestriction, setApp, setAppAlwaysFieldFlag, setAppWhere, setAutoKeyFlag, setDBFetchMaxRows, setDefaultOrderBy, setDefaultValue, setDefaultValue, setDefaultValues, setDefaultValues, setDMDeploySet, setDMSkipFieldValidation, setEAuditFieldModified, setERMEntity, setESigFieldModified, setExcludeMeFromPropagation, setFederatedResources, setFlag, setFlag, setFlags, setInsertCompanySet, setInsertItemSet, setInsertOrg, setInsertSite, setLastESigTransId, setLogLargFetchResultDisabled, setMboSetInfo, setMXTransaction, setNoNeedtoFetchFromDB, setOrderBy, setOrderByNVL, setOwner, setPreserveOrderByCase, setProxy, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeCaseSensitive, setQbeCaseSensitive, setQbeExactMatch, setQbeExactMatch, setQbeOperatorOr, setQueryBySiteQbe, setQueryTimeout, setRelationName, setRelationship, setRequiedFlagsFromERM, setRetainMboPosition, setSetOrderByForUI, setSkipFirstNRows, setSQLOptions, setTableDomainLookup, setTxnPropertyMap, setupLongOpPipe, setUserWhere, setUserWhereAfterParse, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull, setWhere, setWhereQbe, smartFill, smartFill, smartFind, smartFind, smartFind, smartFind, sort, splitOrderBy, startCheckpoint, startCheckpoint, sum, toBeSaved, undeleteAll, undoTransaction, unselect, unselect, unselect, unselectAll, useStoredQuery, validate, validateTransaction, verifyESig

Methods inherited from class java.lang.Object

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

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, 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, 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

mboSetAttributeSearch

public MboSetRemote mboSetAttributeSearch

07-17112

dbUpper

public java.lang.String dbUpper

currentClassSpecUseWithMbo

public MboRemote currentClassSpecUseWithMbo

PERFORMANCE TESTING: passing the ClassSpecUseWith, instead of re-fetch, used in assetcatalogservice.generatespecset

Constructor Detail

SpecificationMboSet

public SpecificationMboSet(MboServerInterface ms)
                    throws java.rmi.RemoteException

Throws:

java.rmi.RemoteException

Method Detail

checkValueExists

public boolean checkValueExists(java.lang.String attrName,
                                java.lang.String attrValue)
                         throws java.rmi.RemoteException,
                                MXException

Checks if there are records that meet the attrName, attrValue setQBE() command. If there are, return true; resetQbe to put the set into its original state.

Specified by:

checkValueExists in interface SpecificationMboSetRemote

Parameters:

attrName - the attribute name

attrValue - the attribute value

Returns:

boolean true if there are records, false if not

Throws:

java.rmi.RemoteException

MXException

See Also:

checkValueExists(String, String)

whereClauseOnAttrAndValues

public java.lang.String whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues,
                                                   java.lang.String classstructureid)
                                            throws MXException,
                                                   java.rmi.RemoteException

For Asset Catalog Search - returns a String to the caller. It loops thru the passed two dimensional array and produces a where clause to the caller. The two dimensional array holds the assetAttrIds and their values. It's contents look like the following:
[0][0] = "assetattrid='SIZE'", [0][1]=" numvalue > 1.5"; IV81743: added section, so example if section is populated [0][4] = "section like '%SEC%'

Specified by:

whereClauseOnAttrAndValues in interface SpecificationMboSetRemote

Parameters:

attrAndValues - 2 dimentional array of assetAttrIds and their values

classstructureid - the classstructureid

Returns:

String - resulting where clause

Throws:

MXException

java.rmi.RemoteException

See Also:

whereClauseOnAttrAndValues(String[][], String)

whereClauseOnAttrAndValues

public java.lang.String whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues)
                                            throws MXException,
                                                   java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

getGeneratedDesc

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

Loops thru the current set and returns a concatinated string based on the corresponding classspec.ATTRDESCPREFIX, alnvalue/numvalue, and measureunit.abbreviation/or measureunitid. This method is needed for the description generation for item, locations, and asset.

Specified by:

getGeneratedDesc in interface SpecificationMboSetRemote

Returns:

String - A concated string obtained looping thru each indivisual spec.

Throws:

MXException

java.rmi.RemoteException

See Also:

getGeneratedDesc()

checkCommonSpecDuplicates

public void checkCommonSpecDuplicates(MboRemote currentClassSpec)
                               throws MXException,
                                      java.rmi.RemoteException

Check to see if the combination of classstructureid/assetattrid/section already exists in other specification records currently in this set.

Specified by:

checkCommonSpecDuplicates in interface SpecificationMboSetRemote

Parameters:

currentClassSpec -

Throws:

MXException

java.rmi.RemoteException

See Also:

checkCommonSpecDuplicates(MboRemote)

canAdd

public void canAdd()
            throws MXException

Cannot add a new specifictaion attribute if the owner does not have a classstructureid.

Overrides:

canAdd in class MboSet

Throws:

MXException

setAttributesSearchMboSet

public void setAttributesSearchMboSet(MboSetRemote mboSet)
                               throws MXException,
                                      java.rmi.RemoteException

07-17112: set the mboset from the Classification Attribute Search

Parameters:

appMboSet, - the result set or appset from attribute search.

Throws:

MXException

java.rmi.RemoteException

getAttributesSearchMboSet

public MboSetRemote getAttributesSearchMboSet()
                                       throws MXException,
                                              java.rmi.RemoteException

07-17112: get the MboSet from which attribute search is launched

Returns:

Throws:

MXException

java.rmi.RemoteException

wasDescGenerated

public boolean wasDescGenerated()
                         throws MXException,
                                java.rmi.RemoteException

07-16935:description needs to be generated by one specification mbo

Returns:

Throws:

MXException

java.rmi.RemoteException

setDescGenerated

public void setDescGenerated(java.lang.String desc)
                      throws MXException,
                             java.rmi.RemoteException

07-16935:description needs to be generated by one specification mbo

Throws:

MXException

java.rmi.RemoteException

toCreateNewSpecRecordsInMainObject

public boolean toCreateNewSpecRecordsInMainObject()
                                           throws MXException,
                                                  java.rmi.RemoteException

DO NOT OVERRIDE this method unless you need to. Currently, only JobTaskSpecSet and PDSpecSet overrides it. In most cases, the new specification recors created via AssetCatalogService.generateSpecSet(MboRemote) method are created in the relationship where the parent is the referenced object which for the most cases is the main object. However, there are cases in JOBTASKSPEC, and PDSEPC where the referenced object and the main objects are different.

Returns:

Throws:

MXException

java.rmi.RemoteException

isLinear

public boolean isLinear()
                 throws MXException,
                        java.rmi.RemoteException

08-13571: DO NOT OVERRIDE this unless your SpecificationSet is related to LINEAR functionality. In core MAXIMO, only FEATURESPEC, ASSETSPEC, and ASSETFEATURESPEC are linear. Default is false for other specifications.

Returns:

Throws:

MXException

java.rmi.RemoteException

getGeneratedDescWithQbe

public java.lang.String getGeneratedDescWithQbe(MboSetRemote dbRelationshipSet)
                                         throws MXException,
                                                java.rmi.RemoteException

08-15740: this SpecSet has qbe. This method gets from the db specification and compare the current specification set that has qbe.

Parameters:

dbRelationshipSet - : fetched from db that contains the whole set without qbe sql where

Returns:

Throws:

MXException

java.rmi.RemoteException

setCurrentClassSpecUseWithMbo

public void setCurrentClassSpecUseWithMbo(MboRemote classSpeUseWith)
                                   throws MXException,
                                          java.rmi.RemoteException

PERFORMANCE TESTING: passing the ClassSpecUseWith, instead of re-fetch.

Parameters:

classSpeUseWith -

Throws:

MXException

java.rmi.RemoteException

getCurrentClassSpecUseWithMbo

public MboRemote getCurrentClassSpecUseWithMbo()
                                        throws MXException,
                                               java.rmi.RemoteException

PERFORMANCE TESTING: passing the ClassSpecUseWith, instead of re-fetch.

Returns:

Throws:

MXException

java.rmi.RemoteException

sortThisSetByDisplaySeq

public MboRemote[] sortThisSetByDisplaySeq()
                                    throws MXException,
                                           java.rmi.RemoteException

09-12625: This spec set may be new mbos, need to sort in mboset

Returns:

Throws:

MXException

java.rmi.RemoteException

toCheckClassSpecUseWith

public boolean toCheckClassSpecUseWith()
                                throws MXException,
                                       java.rmi.RemoteException

12-11553/IV17979:DO NOT OVERRIDE this method unless you need to. Currently, Main change: PDSPEC(purchasing document specifications) is created based on ItemSpec. Under normal cases, ITEMSPEC set is copied to PDSPECSet, regardless of use with POLine,PRLine. This change is to check the ClassspecUseWith records for use-with PRLine,POLine,before copying the attribute and values.

Returns:

true if the copying logic is to check classspecuse before copying. false: not to check default is: false - not to check classspecusewith when generating(ex) PDSPEC from ITEMSPEC

Throws:

MXException

java.rmi.RemoteException