java.util.ArrayList |
getDataForGraph()
Returns the data needed to display the charts.
A SQL is formed in the following manner
select GROUPBY /DISPLAY BY Attribute, count(*)
from tablename
where query where clause
group by GROUPBY /DISPLAY BY Attribute
Data is into an array list to be passed on the client side for graph generation
The graph array list contains data as per following example
Records NumberInformation (Hashtable)
RSCONFIGIDUnique Id
1percent=50;value=WAPPR;count=5
2percent=50;value=APPR;count=5
java.lang.String |
getErrorMsg()
Returns if there was a general error.
|
java.util.Properties |
getGraphDetails()
Returns the information relating to query and attribute on which grouping was done.
|
java.lang.String |
getGraphErrorMsg()
Returns if there was a general error.
|
java.lang.String[] |
getGroupByAttribute()
Returns the name of the attribute on which data will be grouped by and graph has to be displayed
|
java.lang.String |
getKeyColumn()
Returns current unique attribute
|
java.util.ArrayList |
getNonPersistentAttributes()
Returns a collection of all non-persistent fields.
This is needed in the portlet to restrict user from filtering.
|
int |
getNoOfRecords()
Returns no of records in this query
|
java.lang.String |
getOriginalResultSetWhere() |
java.lang.String |
getQueryAppName()
Returns the name of the application being used in this portlet currently
|
java.lang.String |
getQueryId()
Returns the ID of the query being used currently
|
MboRemote |
getQueryInfo(long queryId)
Returns the QueryRemote for the given query
|
MboSetData |
getResultSetData(int start,
int rowcount,
java.lang.String sortBy,
java.util.Hashtable qbes)
Returns the MboValueData to be displayed on the portlet
The data will be fetched for current query based on its where clause>
Only records in the range given by start and rowcount will be
fetched
This method also takes into account specific cases of query belonging to WORKVIEW application.
Data is filtered based on the qbes passed on by the user on the
|
MboSetRemote |
getResultSetMboSet(java.lang.String orderBy)
Returns a MboSetRemote for the Query for this result set.
|
java.lang.String |
getResultSetWhere() |
java.lang.String |
getResultSetWhereWithoutOrderBy() |
boolean |
isErrorRunningQuery()
Returns if there was an error running the query to fetch teh result set data.
|
boolean |
queryExists()
Returns true if the related query exists
|
void |
resetErrorRunningQuery()
Resets the query error flag to false.
|
MboSetRemote |
runQuery(UserInfo ui,
java.lang.String sTableName,
java.lang.String sWhereClause)
Runs the current query and returns the set of data based on the given where clause
|
boolean |
setDetails(long selectedQueryId)
Called when a query is selected for Portlet configuration.
Sets the complete details based on the query id
Main steps are
Get application name for this query
Set query name in the portlet
Set attributes for the application of this query into this portlet
|
void |
setKeyColumn(java.lang.String col)
Sets current unique attribute for portlet linking
|
void |
setLookupValue(java.lang.String attrib,
java.lang.String value)
Sets the attribute name that was selected from lookup for condition or graph configuration
|
void |
setLookupValueFromSetGraphOptionsDialog(java.lang.String value)
Seperate method from setLookupValue which is called only from Set Graph options dialog from the start center
Validation for dot notation is done seperately and should be mixed with the one being done on Graph options
tab in the RSConfig app.
|
void |
setNoOfRecords(int num)
Sets no of records
|
void |
setQueryAppName(java.lang.String newAppName)
Sets the currently used application
|
void |
setQueryDetails()
Returns the ID of the query being used currently
|
void |
setQueryId(java.lang.String newQueryId)
Sets the Id of the query to be used for this portlet
|
void |
setUpDefaults()
Sets default values for virtual attributes and class variables
|
-
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, canAdd, 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
-
-
Constructor Detail
-
RSConfigSet
public RSConfigSet(MboServerInterface ms)
throws MXException,
java.rmi.RemoteException
Constructs the set of RSConfig.
- Parameters:
ms - the MboServerInterface
- Throws:
MXException
java.rmi.RemoteException
-
Method Detail
-
getColumns
public java.util.Vector getColumns()
throws java.rmi.RemoteException,
MXException
Returns a collection of attributes currently selected for display in the portlet
- Specified by:
getColumns in interface RSConfigSetRemote
- Returns:
- collection of array of names and description for selected attributes
- Throws:
java.rmi.RemoteException
MXException
-
setQueryId
public void setQueryId(java.lang.String newQueryId)
throws java.rmi.RemoteException,
MXException
Sets the Id of the query to be used for this portlet
- Specified by:
setQueryId in interface RSConfigSetRemote
- Parameters:
newQueryId - as String
- Throws:
java.rmi.RemoteException
MXException
-
getQueryAppName
public java.lang.String getQueryAppName()
throws java.rmi.RemoteException,
MXException
Returns the name of the application being used in this portlet currently
- Specified by:
getQueryAppName in interface RSConfigSetRemote
- Returns:
- String Name of related application
- Throws:
java.rmi.RemoteException
MXException
-
setQueryAppName
public void setQueryAppName(java.lang.String newAppName)
throws java.rmi.RemoteException,
MXException
Sets the currently used application
- Specified by:
setQueryAppName in interface RSConfigSetRemote
- Parameters:
newAppName - as the applications
- Throws:
java.rmi.RemoteException
MXException
-
runQuery
public MboSetRemote runQuery(UserInfo ui,
java.lang.String sTableName,
java.lang.String sWhereClause)
throws java.rmi.RemoteException,
MXException
Runs the current query and returns the set of data based on the given where clause
- Specified by:
runQuery in interface RSConfigSetRemote
- Parameters:
UserInfo - current user info
sTableName - object name
sWhereClause - where clause for the query
- Returns:
- MboSetRemote of given table based in give whereclause
- Throws:
java.rmi.RemoteException
MXException
-
getColumnsAsArray
public java.lang.String[] getColumnsAsArray()
throws java.rmi.RemoteException,
MXException
Returns an array of names of the currently selected attributes for display in the portlet
- Specified by:
getColumnsAsArray in interface RSConfigSetRemote
- Returns:
- String[] of names of the attributes
- Throws:
java.rmi.RemoteException
MXException
-
getKeyColumn
public java.lang.String getKeyColumn()
throws java.rmi.RemoteException,
MXException
Returns current unique attribute
- Specified by:
getKeyColumn in interface RSConfigSetRemote
- Returns:
- name of the unique attribute as String
- Throws:
java.rmi.RemoteException
MXException
-
getNoOfRecords
public int getNoOfRecords()
throws java.rmi.RemoteException,
MXException
Returns no of records in this query
- Specified by:
getNoOfRecords in interface RSConfigSetRemote
- Returns:
- number of records as integer
- Throws:
java.rmi.RemoteException
MXException
-
setKeyColumn
public void setKeyColumn(java.lang.String col)
throws java.rmi.RemoteException,
MXException
Sets current unique attribute for portlet linking
- Specified by:
setKeyColumn in interface RSConfigSetRemote
- Parameters:
unique - attribute name as String
- Throws:
java.rmi.RemoteException
MXException
-
getResultSetData
public MboSetData getResultSetData(int start,
int rowcount,
java.lang.String sortBy,
java.util.Hashtable qbes)
throws java.rmi.RemoteException,
MXException
Returns the MboValueData to be displayed on the portlet
The data will be fetched for current query based on its where clause>
Only records in the range given by start and rowcount will be
fetched
This method also takes into account specific cases of query belonging to WORKVIEW application.
Data is filtered based on the qbes passed on by the user on the
- Specified by:
getResultSetData in interface RSConfigSetRemote
- Parameters:
start - position
rows - to display
sort - by
hashtable - of qbes
- Throws:
java.rmi.RemoteException
MXException
-
getConditionAttribute
public java.lang.String getConditionAttribute()
throws java.rmi.RemoteException,
MXException
Returns the name of the condition attribute on which a condition is set
for color display
- Specified by:
getConditionAttribute in interface RSConfigSetRemote
- Returns:
- name of the attribute as String
- Throws:
java.rmi.RemoteException
MXException
-
getGroupByAttribute
public java.lang.String[] getGroupByAttribute()
throws java.rmi.RemoteException,
MXException
Returns the name of the attribute on which data will be grouped by and graph has to be displayed
- Specified by:
getGroupByAttribute in interface RSConfigSetRemote
- Returns:
- name of the attribute as String
- Throws:
java.rmi.RemoteException
MXException
-
getConditions
public java.util.HashSet getConditions()
throws java.rmi.RemoteException,
MXException
Returns the conditions set for this portlet.
Methods are called on PortletDisplaySetRemote
- Specified by:
getConditions in interface RSConfigSetRemote
- Returns:
- Conditions set as MboValueData[][]
- Throws:
java.rmi.RemoteException
MXException
-
addFromResultSetColumn
public void addFromResultSetColumn(java.lang.String appName)
throws java.rmi.RemoteException,
MXException
Copy attributes from resultsetcols to rsconfig for a giving application name
- Specified by:
addFromResultSetColumn in interface RSConfigSetRemote
- Throws:
java.rmi.RemoteException
MXException
-
getQueryId
public java.lang.String getQueryId()
throws java.rmi.RemoteException,
MXException
Returns the ID of the query being used currently
- Specified by:
getQueryId in interface RSConfigSetRemote
- Returns:
- String Id of the selected query
- Throws:
java.rmi.RemoteException
MXException
-
setQueryDetails
public void setQueryDetails()
throws java.rmi.RemoteException,
MXException
Returns the ID of the query being used currently
- Throws:
java.rmi.RemoteException
MXException
-
getGraphDetails
public java.util.Properties getGraphDetails()
throws java.rmi.RemoteException,
MXException
Returns the information relating to query and attribute on which grouping was done.
This will be used in displaying the graph.
- Specified by:
getGraphDetails in interface RSConfigSetRemote
- Returns:
- graph information as Properties
- Throws:
java.rmi.RemoteException
MXException
-
checkAttributeChange
public void checkAttributeChange()
throws java.rmi.RemoteException,
MXException
Checks if any attributes have changed in the Query's App's Main object.
This has to be done so that newly added persistent fields are available for
configuration
May 22, 2007
- Specified by:
checkAttributeChange in interface RSConfigSetRemote
- Throws:
java.rmi.RemoteException
MXException
-
isErrorRunningQuery
public boolean isErrorRunningQuery()
throws java.rmi.RemoteException,
MXException
Returns if there was an error running the query to fetch teh result set data.
- Specified by:
isErrorRunningQuery in interface RSConfigSetRemote
- Returns:
- Throws:
java.rmi.RemoteException
MXException
-
setLookupValue
public void setLookupValue(java.lang.String attrib,
java.lang.String value)
throws java.rmi.RemoteException,
MXException
Sets the attribute name that was selected from lookup for condition or graph configuration
- Specified by:
setLookupValue in interface RSConfigSetRemote
- Throws:
java.rmi.RemoteException
MXException
-
setLookupValueFromSetGraphOptionsDialog
public void setLookupValueFromSetGraphOptionsDialog(java.lang.String value)
throws java.rmi.RemoteException,
MXException
Seperate method from setLookupValue which is called only from Set Graph options dialog from the start center
Validation for dot notation is done seperately and should be mixed with the one being done on Graph options
tab in the RSConfig app. We need this because using the dialog on the start center, there are issues
with underlying RSConfigSet which comes different and hence some defualt values like queryobjectname, which are initialized
This also makes sure validation for dot notation is done seperately for case.
- Specified by:
setLookupValueFromSetGraphOptionsDialog in interface RSConfigSetRemote
- Parameters:
value -
- Throws:
java.rmi.RemoteException
MXException
-
deleteLabels
public void deleteLabels()
throws java.rmi.RemoteException,
MXException
Deletes labels related to this portlet when query is changed since portlet configuration is lost
- Specified by:
deleteLabels in interface RSConfigSetRemote
- Throws:
java.rmi.RemoteException
MXException
-
getNonPersistentAttributes
public java.util.ArrayList getNonPersistentAttributes()
throws java.rmi.RemoteException,
MXException
Returns a collection of all non-persistent fields.
This is needed in the portlet to restrict user from filtering.
- Specified by:
getNonPersistentAttributes in interface RSConfigSetRemote
- Returns:
- ArrayList of attribute names
- Throws:
java.rmi.RemoteException
MXException
-
getResultSetMboSet
public MboSetRemote getResultSetMboSet(java.lang.String orderBy)
throws java.rmi.RemoteException,
MXException
Returns a MboSetRemote for the Query for this result set. It always uses the current
completewhereclause, so getResultSetData must be called before this.
- Specified by:
getResultSetMboSet in interface RSConfigSetRemote
- Parameters:
orderBy -
- Returns:
- The mboset for the result set
- Throws:
java.rmi.RemoteException
MXException
|