psdi.app.ticket

Interface TicketSetRemote

All Superinterfaces:

MboAccessInterface, MboSetRemote, java.rmi.Remote, Transactable

All Known Subinterfaces:

IncidentSetRemote, ProblemSetRemote, SRSetRemote

All Known Implementing Classes:

IncidentSet, ProblemSet, SRSet, TicketSet

public interface TicketSetRemote
extends MboSetRemote

Remote Interface to the set of Tickets.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	ACTIVITY Relationship to the Work Order's records, used to find the activities records for a given Ticket.
static java.lang.String	AFFECTEDPERSON Relationship to the Person records, used to find the person record associated with the affectedperson.
static java.lang.String	ALLMULTIASSETLOCCI
static java.lang.String	COMMLOG Relationship to the Communication Log records, used to find the communication log record for a certain class of ticket.
static java.lang.String	FAILUREREMARK Relationship to the Failure Remark records, used to find the failure remarks associated to a ticket.
static java.lang.String	FAILUREREPORT Relationship to the Failure Report records, used to find the failurecode records associated to a ticket.
static java.lang.String	LABOR Relationship to the Labor records, used to find the labor information associated to a ticket via the reportedby user.
static java.lang.String	LABTRANS Relationship to the Labtrans records, used to find the labor transaction information.
static java.lang.String	MULTIASSETLOCCI Relationship to the Ticket's multi Asset location CI records, used to find the all associated assets.
static java.lang.String	ORIGTICKET Relationship to the Ticket records, used to find the original ticket record.
static java.lang.String	ORIGWO Relationship to the Work Order records, used to find the originating Work Order record.
static java.lang.String	OWNERHISTORY Relationship to the Owner History records, used to find the owner of the ticket.
static java.lang.String	OWNERPERSON Relationship to the Person records, used to find the person information via the owner of the ticket.
static java.lang.String	PERSON Relationship to the Person records, used to find the person information via the reportedby user.
static java.lang.String	RELATEDGLOBALREC Relationship to the relatedrecord records, used to collect related global tickets .
static java.lang.String	RELATEDRECORD Relationship to the Related Record table.
static java.lang.String	RELATEDTICKET Relationship to the Related Record table by Related Record Class.
static java.lang.String	RELATEDWO Relationship to the Related Record table by Related Record Class used to find ticket of Work Order class.
static java.lang.String	SLARECORDS Relationship to the SLARECORDS, used to find the service level agreement record.
static java.lang.String	TICKET Relationship to the Ticket records, used to find the orginating ticket record.
static java.lang.String	TICKETPRIMARYASSET Relationship to the Ticket's multi Asset location CI records, used to find the primary asset.
static java.lang.String	TKCHANGESTATUS Relationship to the Tickets non-persistent TKCHANGESTATUS records.
static java.lang.String	TKFAILLIST Relationship to the Failurelist records.
static java.lang.String	TKGRANDTOTAL Relationship to the Tickets non-persistent TKGRANDTOTAL records.
static java.lang.String	TKRELATEDTOGLOBAL Relationship to the ticket records, used to collect global related tickets .
static java.lang.String	TKSERVICEADDRESS
static java.lang.String	TKSTATUS Relationship to the TKSTATUS records.
static java.lang.String	TKTEMPLATE Relationship to the TKTEMPLATE records, used to find the active tktemplate records.
static java.lang.String	TKTOTAL Relationship to the Tickets non-persistent TKTOTAL records.
static java.lang.String	WOACTIVITY Relationship to the WOACTIVITY records.
static java.lang.String	WORKLOG Relationship to the WORKLOG records.
static java.lang.String	WORKORDER Relationship to the WORKORDER records, used to collect all non activity workorders.
static java.lang.String	WORKVIEW Relationship to the workview record, used to find workview rocord .

Fields inherited from interface psdi.mbo.MboSetRemote

INSERTONLY, INSERTORUPDATE, UPDATEONLY

Method Summary

Modifier and Type	Method and Description
void	filterByLinearAsset(MboSetRemote fltrSet)
java.util.Hashtable	getOriginalTicketQbe()
java.lang.String	getOriginalTicketUserWhere()
void	setOriginalTicketQbe(java.util.Hashtable inQbe)
void	setOriginalTicketUserWhere(java.lang.String inWhere)

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

ACTIVITY

static final java.lang.String ACTIVITY

Relationship to the Work Order's records, used to find the activities records for a given Ticket.
(workorder.origrecordid = ticket.ticketid and workorder.origrecordclass = ticket.class and woclass in (select value from valuelist where listname ='WOCLASS' and value='ACTIVITY'))
The resulting set will contain zero or more records.

See Also:

Constant Field Values

AFFECTEDPERSON

static final java.lang.String AFFECTEDPERSON

Relationship to the Person records, used to find the person record associated with the affectedperson.
(person.personid = ticket.affectedperson)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

COMMLOG

static final java.lang.String COMMLOG

Relationship to the Communication Log records, used to find the communication log record for a certain class of ticket.
(commlog.recordkey = ticket.ticketid and commlog.class = ticket.class)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

FAILUREREMARK

static final java.lang.String FAILUREREMARK

Relationship to the Failure Remark records, used to find the failure remarks associated to a ticket.
(failureremark.ticketid=ticket.ticketid and failureremark.ticketclass=ticket.class)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

FAILUREREPORT

static final java.lang.String FAILUREREPORT

Relationship to the Failure Report records, used to find the failurecode records associated to a ticket.
(failurereport.ticketid=ticket.ticketid and failurereport.ticketclass=ticket.class)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

LABOR

static final java.lang.String LABOR

Relationship to the Labor records, used to find the labor information associated to a ticket via the reportedby user.
(labor.labor=ticket.reportedby and labor.orgid=ticket.orgid)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

LABTRANS

static final java.lang.String LABTRANS

Relationship to the Labtrans records, used to find the labor transaction information.
(labtrans.ticketid=ticket.ticketid and labtrans.ticketclass=ticket.class)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

ORIGTICKET

static final java.lang.String ORIGTICKET

Relationship to the Ticket records, used to find the original ticket record.
(ticket.ticketid=ticket.origrecordid and ticket.class=ticket.origrecordclass)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

ORIGWO

static final java.lang.String ORIGWO

Relationship to the Work Order records, used to find the originating Work Order record.
(workorder.wonum=ticket.origrecordid and workorder.woclass=ticket.origrecordclass)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

OWNERHISTORY

static final java.lang.String OWNERHISTORY

Relationship to the Owner History records, used to find the owner of the ticket.
(ownerhistory.recordkey=ticket.ticketid and ownerhistory.class=ticket.class)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

OWNERPERSON

static final java.lang.String OWNERPERSON

Relationship to the Person records, used to find the person information via the owner of the ticket.
(person.personid=ticket.owner)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

PERSON

static final java.lang.String PERSON

Relationship to the Person records, used to find the person information via the reportedby user.
(person.personid=ticket.reportedby)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

SLARECORDS

static final java.lang.String SLARECORDS

Relationship to the SLARECORDS, used to find the service level agreement record.
(ownertable = :class and ownerid = :ticketuid)
The resulting set will contain zero or one record.

See Also:

Constant Field Values

RELATEDRECORD

static final java.lang.String RELATEDRECORD

Relationship to the Related Record table.
(relatedrecord.recordkey=ticket.ticketid and relatedrecord.class=ticket.class)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

RELATEDTICKET

static final java.lang.String RELATEDTICKET

Relationship to the Related Record table by Related Record Class.
(relatedrecord.recordkey=ticket.ticketid and relatedrecord.class = ticket.class and relatedrecord.relatedrecclass in (select value from valuelist where listname ='TKCLASS' and value in ('SR', 'PROBLEM', 'INCIDENT')))
The resulting set will contain zero or many records.

See Also:

Constant Field Values

RELATEDWO

static final java.lang.String RELATEDWO

Relationship to the Related Record table by Related Record Class used to find ticket of Work Order class.
(relatedrecord.recordkey=ticket.ticketid and relatedrecord.class = ticket.class and relatedrecord.relatedrecclass in (select value from valuelist where listname ='WOCLASS' and value in ('CHANGE', 'RELEASE','ACTIVITY', 'WORKORDER')))
The resulting set will contain zero or many records.

See Also:

Constant Field Values

TICKET

static final java.lang.String TICKET

Relationship to the Ticket records, used to find the orginating ticket record.
(ticket.origrecordid=ticket.ticketid and ticket.origrecordclass=ticket.class)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

TKCHANGESTATUS

static final java.lang.String TKCHANGESTATUS

Relationship to the Tickets non-persistent TKCHANGESTATUS records.
(TKCHANGESTATUS is a non-persistent object, no where clause)
The resulting set will contain zero records.

See Also:

Constant Field Values

TKFAILLIST

static final java.lang.String TKFAILLIST

Relationship to the Failurelist records.
(failurelist.parent = (select failurelist from failurelist where failurelist.failurecode = ticket.failurecode and parent is null) and orgid=:orgid)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

TKGRANDTOTAL

static final java.lang.String TKGRANDTOTAL

Relationship to the Tickets non-persistent TKGRANDTOTAL records.
(TKGRANDTOTAL is a non-persistent object, no where clause)
The resulting set will contain zero records.

See Also:

Constant Field Values

TKSTATUS

static final java.lang.String TKSTATUS

Relationship to the TKSTATUS records.
(tkstatus.ticketid = ticket.ticketid and tkstatus.class = ticket.class)
The resulting set will contain zero or one records

See Also:

Constant Field Values

TKTEMPLATE

static final java.lang.String TKTEMPLATE

Relationship to the TKTEMPLATE records, used to find the active tktemplate records.
(tktemplate.class=ticket.class and tktemplate.status in (select value from valuelist where listname = 'TEMPLATESTATUS' and maxvalue = 'ACTIVE'))
The resulting set will contain zero or many records

See Also:

Constant Field Values

TKTOTAL

static final java.lang.String TKTOTAL

Relationship to the Tickets non-persistent TKTOTAL records.
(TKTOTAL is a non-persistent object, no where clause)
The resulting set will contain zero records.

See Also:

Constant Field Values

WOACTIVITY

static final java.lang.String WOACTIVITY

Relationship to the WOACTIVITY records.
(woactivity.origrecordid = ticket.ticketid and woactivity.origrecordclass = ticket.class and woactivity.woclass in (select value from valuelist where listname ='WOCLASS' and value='ACTIVITY'))
The resulting set will contain zero or many records

See Also:

Constant Field Values

WORKLOG

static final java.lang.String WORKLOG

Relationship to the WORKLOG records.
(worklog.recordkey = ticket.ticketid and worklog.class = ticket.class)
The resulting set will contain zero or many records

See Also:

Constant Field Values

WORKORDER

static final java.lang.String WORKORDER

Relationship to the WORKORDER records, used to collect all non activity workorders.
(workorder.origrecordid = ticket.ticketid and workorder.origrecordclass = ticket.class and workorder.woclass in (select value from valuelist where listname ='WOCLASS' and value !='ACTIVITY') )
The resulting set will contain zero or many records

See Also:

Constant Field Values

TKRELATEDTOGLOBAL

static final java.lang.String TKRELATEDTOGLOBAL

Relationship to the ticket records, used to collect global related tickets .
(ticket.globalticketid = ticket.ticketid and ticket.globalticketclass=ticket.class )
The resulting set will contain zero or many records

See Also:

Constant Field Values

RELATEDGLOBALREC

static final java.lang.String RELATEDGLOBALREC

Relationship to the relatedrecord records, used to collect related global tickets .
(relatedrecord.recordkey=ticket.globalticketid and relatedrecord.class=ticket.globalticketclass and (relatetype='ISGLOBAL' or relatetype='RELATEDTOGLOBAL'))
The resulting set will contain zero or many records

See Also:

Constant Field Values

WORKVIEW

static final java.lang.String WORKVIEW

Relationship to the workview record, used to find workview rocord .
(workview.recordkey=ticket.ticketid and workview.class=ticket.class)
The resulting set will contain zero or many records

See Also:

Constant Field Values

TICKETPRIMARYASSET

static final java.lang.String TICKETPRIMARYASSET

Relationship to the Ticket's multi Asset location CI records, used to find the primary asset.
(multiassetlocci.ticketid = ticket.ticketid and multiassetlocci.ticketclass = ticket.class and multiassetlocci.isprimary=1)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

MULTIASSETLOCCI

static final java.lang.String MULTIASSETLOCCI

Relationship to the Ticket's multi Asset location CI records, used to find the all associated assets.
(multiassetlocci.ticketid = ticket.ticketid and multiassetlocci.ticketclass = ticket.class and multiassetlocci.isprimary=0)
The resulting set will contain zero or many records.

See Also:

Constant Field Values

ALLMULTIASSETLOCCI

static final java.lang.String ALLMULTIASSETLOCCI

See Also:

Constant Field Values

TKSERVICEADDRESS

static final java.lang.String TKSERVICEADDRESS

See Also:

Constant Field Values

Method Detail

getOriginalTicketQbe

java.util.Hashtable getOriginalTicketQbe()
                                  throws MXException,
                                         java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

getOriginalTicketUserWhere

java.lang.String getOriginalTicketUserWhere()
                                     throws MXException,
                                            java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

setOriginalTicketUserWhere

void setOriginalTicketUserWhere(java.lang.String inWhere)
                         throws MXException,
                                java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

setOriginalTicketQbe

void setOriginalTicketQbe(java.util.Hashtable inQbe)
                   throws MXException,
                          java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

filterByLinearAsset

void filterByLinearAsset(MboSetRemote fltrSet)
                  throws MXException,
                         java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException