public class QueryMagic
extends Object
implements RemoteAccess
Modifier and Type | Field and Description |
---|---|
static String |
ALL_I |
static String |
ALL_RELEASED |
static String |
AUTHAPP |
static String |
CADNAMENOT |
static String |
CADNAMEREGEX |
static String |
CADNAMESM |
static String |
CADNAMEUSE |
static String |
configSpec_asStored |
static String |
configSpec_latest |
static String |
CONTAINER |
static String |
CONTAINERREGEX |
static String |
CONTAINERSM |
static String |
CREATORNOT |
static String |
CREATORREGEX |
static String |
CREATORSM |
static String |
CREATORUSE |
static String |
CSVEXPORT |
static String |
DOCTYPE |
static String |
DOEPMDOC |
static String |
DOEPMDOCM |
static String |
DOWTDOC |
static String |
DOWTDOCM |
static String |
DOWTPART |
static String |
DOWTPARTM |
static String |
EXCELEXPORT |
static String |
EXCLUDECADSUBTYPES |
static String |
FILTERCADASM |
static String |
FILTERCADCOM |
static String |
FILTERCADDRW |
static String |
FOLDERNOT |
static String |
FOLDERREGEX |
static String |
FOLDERSM |
static String |
FOLDERUSE |
static String |
GLOBAL_SM |
static String |
HTTPGWHOSTNAME |
static String |
IBANAMEREGEX |
static String |
IBANAMEREGEX2 |
static String |
IBANAMESM |
static String |
IBANAMESM2 |
static String |
IBANOT |
static String |
IBANOT2 |
static String |
IBANOTEXISTS |
static String |
IBANOTEXISTS2 |
static String |
IBAUSE |
static String |
IBAUSE2 |
static String |
IBAVALUEREGEX |
static String |
IBAVALUEREGEX2 |
static String |
IBAVALUESM |
static String |
IBAVALUESM2 |
static String |
INFO |
static String |
IV |
static String |
IV_NOT |
static String |
IV2 |
static String |
IV2_NOT |
static String |
LATEST_I |
static String |
LATEST_IOV |
static String |
LATEST_RELEASED |
static String |
LATEST_V |
static String |
LCSNOT |
static String |
LCSSTATE |
static String |
LCSSTATEREGEX |
static String |
LCSSTATESM |
static String |
LCSUSE |
static String |
LOCATIONNOT |
static String |
LOCATIONREGEX |
static String |
LOCATIONSM |
static String |
LOCATIONUSE |
static int |
MAJOR |
static int |
MINOR |
static String |
MODIFIERNOT |
static String |
MODIFIERREGEX |
static String |
MODIFIERSM |
static String |
MODIFIERUSE |
static String |
NAMENOT |
static String |
NAMEREGEX |
static String |
NAMESM |
static String |
NAMEUSE |
static String |
NUMBERNOT |
static String |
NUMBERREGEX |
static String |
NUMBERSKIPLIST |
static String |
NUMBERSKIPMODE |
static String |
NUMBERSKIPMODE_CSV |
static String |
NUMBERSKIPMODE_REGEX |
static String |
NUMBERSM |
static String |
NUMBERUSE |
static String |
OBJSUBTYPENOT |
static String |
OBJSUBTYPEREGEX |
static String |
OBJSUBTYPESM |
static String |
OBJSUBTYPEUSE |
static String |
OID |
static String |
OP_API |
static String |
OP_SQL |
static String |
OPMODE |
static String |
QUERYLIMIT |
static String |
QUERYLOGIC |
static String |
QUERYLOGICIBA |
static String |
RELEASED_TAG |
static String |
REVISIONNOT |
static String |
REVISIONREGEX |
static String |
REVISIONSM |
static String |
REVISIONUSE |
static String |
RMIHOSTNAME |
static boolean |
SERVER |
static String |
SM_EQUALS |
static String[] |
SM_FIELDS |
static String |
SM_NONE |
static String |
SM_REGEX |
static HashMap<String,String> |
SM_SELECT |
static String |
SM_SQLLIKE |
static String |
SM_SQLLIKEIC |
static String[] |
SM_VALIDATORS |
static String |
SM_WILDCARD |
static String |
STATE |
static String |
WEBAPPNAME |
static String |
WTHOME |
Constructor and Description |
---|
QueryMagic() |
Modifier and Type | Method and Description |
---|---|
static String |
buildQuery(String targetclass,
HashMap<String,String> queryParams)
build SQL query string
|
static List |
findRunningPromotionsForObject(Persistable per) |
static List |
findWorkflowsForObject(Persistable per,
String stateRegEx)
find all workflows where given persistable is used.
|
static Map<String,Mastered> |
getAllBusinessObjWithinContainer(String containerOID) |
static Map<String,Persistable> |
getAllBusinessObjWithinContainer(String containerOID,
boolean getLatest) |
static List<Persistable> |
getAllCheckedoutObjects(List<String> containerOIDs,
List<String> users) |
static List |
getAllDependentCADDocuments(WTArrayList seedlist,
boolean isRequired,
String configSpecType) |
static List<Master> |
getAllWTPartWithinContainer(String containerOID) |
static List<String> |
getCADDocTypes() |
static EPMDocumentMaster |
getCADModel(EPMDocument drawing) |
static ConfigSpec |
getConfigSpec(String configSpecType,
EPMDocument epmDoc) |
static String |
getContainerQueryRule(String containerEx) |
static HashMap<String,String> |
getDefaultParams()
returns default values for minimum parameter set.
|
static List |
getEPMStructureNodes(EPMDocument epmdoc,
String configSpec) |
static Map<String,String> |
getLifecycleStates() |
static Map |
getListAuthoringApps() |
static Map |
getListOfContainers() |
static Map |
getListOfContainers(boolean invert) |
static List<String> |
getObjWithinContainer(String containerOID,
String numberLike,
String numberStr,
boolean doEPM,
boolean doWTPart,
boolean doWTDocument) |
static List<EPMDocument> |
queryEPMDocuments(String number,
String searchMode,
boolean latestOnly) |
static Vector<Map> |
queryObjects(HashMap<String,String> queryParams) |
static Vector<Map> |
queryObjectsViewableMagic(HashMap<String,String> queryParams,
Vector<String> dateFilter) |
static List<WTPart> |
queryWTParts(String number,
String searchMode,
boolean latestOnly) |
public static final int MAJOR
public static final int MINOR
public static final String RMIHOSTNAME
public static final String HTTPGWHOSTNAME
public static final String WEBAPPNAME
public static final String WTHOME
public static final boolean SERVER
public static final String OID
public static final String STATE
public static final String INFO
public static final String QUERYLOGIC
public static final String QUERYLIMIT
public static final String ALL_I
public static final String ALL_RELEASED
public static final String LATEST_I
public static final String LATEST_RELEASED
public static final String LATEST_V
public static final String LATEST_IOV
public static final String IV_NOT
public static final String IV
public static final String IV2_NOT
public static final String IV2
public static final String RELEASED_TAG
public static final String CONTAINER
public static final String CONTAINERREGEX
public static final String CONTAINERSM
public static final String DOWTPART
public static final String DOEPMDOC
public static final String DOWTDOC
public static final String DOWTPARTM
public static final String DOEPMDOCM
public static final String DOWTDOCM
public static final String FILTERCADCOM
public static final String FILTERCADASM
public static final String FILTERCADDRW
public static final String EXCLUDECADSUBTYPES
public static final String QUERYLOGICIBA
public static final String SM_REGEX
public static final String SM_SQLLIKE
public static final String SM_SQLLIKEIC
public static final String SM_WILDCARD
public static final String SM_EQUALS
public static final String SM_NONE
public static final String GLOBAL_SM
public static HashMap<String,String> SM_SELECT
public static final String NUMBERREGEX
public static final String NUMBERSM
public static final String NUMBERNOT
public static final String NUMBERUSE
public static final String REVISIONREGEX
public static final String REVISIONSM
public static final String REVISIONNOT
public static final String REVISIONUSE
public static final String FOLDERREGEX
public static final String FOLDERSM
public static final String FOLDERNOT
public static final String FOLDERUSE
public static final String LOCATIONREGEX
public static final String LOCATIONSM
public static final String LOCATIONNOT
public static final String LOCATIONUSE
public static final String NAMEREGEX
public static final String NAMESM
public static final String NAMENOT
public static final String NAMEUSE
public static final String CADNAMEREGEX
public static final String CADNAMESM
public static final String CADNAMENOT
public static final String CADNAMEUSE
public static final String MODIFIERREGEX
public static final String MODIFIERSM
public static final String MODIFIERNOT
public static final String MODIFIERUSE
public static final String CREATORREGEX
public static final String CREATORSM
public static final String CREATORNOT
public static final String CREATORUSE
public static final String IBANAMEREGEX
public static final String IBANAMESM
public static final String IBAVALUEREGEX
public static final String IBAVALUESM
public static final String IBANOTEXISTS
public static final String IBANOT
public static final String IBAUSE
public static final String IBANAMEREGEX2
public static final String IBANAMESM2
public static final String IBAVALUEREGEX2
public static final String IBAVALUESM2
public static final String IBANOTEXISTS2
public static final String IBANOT2
public static final String IBAUSE2
public static final String LCSSTATE
public static final String LCSNOT
public static final String LCSUSE
public static final String LCSSTATEREGEX
public static final String LCSSTATESM
public static final String AUTHAPP
public static final String DOCTYPE
public static final String OBJSUBTYPEUSE
public static final String OBJSUBTYPEREGEX
public static final String OBJSUBTYPENOT
public static final String OBJSUBTYPESM
public static final String NUMBERSKIPLIST
public static final String NUMBERSKIPMODE
public static final String NUMBERSKIPMODE_REGEX
public static final String NUMBERSKIPMODE_CSV
public static final String[] SM_VALIDATORS
public static final String[] SM_FIELDS
public static final String OPMODE
public static final String OP_API
public static final String OP_SQL
public static final String configSpec_latest
public static final String configSpec_asStored
public static String EXCELEXPORT
public static String CSVEXPORT
public static HashMap<String,String> getDefaultParams()
public static String buildQuery(String targetclass, HashMap<String,String> queryParams) throws Exception
targetclass
- queryParams
- Exception
public static Vector<Map> queryObjects(HashMap<String,String> queryParams) throws Exception
Exception
public static Vector<Map> queryObjectsViewableMagic(HashMap<String,String> queryParams, Vector<String> dateFilter) throws Exception
Exception
public static Map<String,String> getLifecycleStates()
public static Map getListAuthoringApps()
public static List<String> getCADDocTypes()
public static Map getListOfContainers() throws Exception
Exception
public static Map getListOfContainers(boolean invert) throws Exception
Exception
public static String getContainerQueryRule(String containerEx) throws Exception
Exception
public static ConfigSpec getConfigSpec(String configSpecType, EPMDocument epmDoc) throws Exception
Exception
public static List getAllDependentCADDocuments(WTArrayList seedlist, boolean isRequired, String configSpecType) throws Exception
Exception
public static EPMDocumentMaster getCADModel(EPMDocument drawing) throws WTException
WTException
public static List getEPMStructureNodes(EPMDocument epmdoc, String configSpec) throws Exception
Exception
public static List findWorkflowsForObject(Persistable per, String stateRegEx) throws Exception
per
- stateRegEx
- Exception
public static List findRunningPromotionsForObject(Persistable per) throws Exception
Exception
public static List<EPMDocument> queryEPMDocuments(String number, String searchMode, boolean latestOnly) throws Exception
Exception
public static List<WTPart> queryWTParts(String number, String searchMode, boolean latestOnly)
public static Map<String,Persistable> getAllBusinessObjWithinContainer(String containerOID, boolean getLatest)
public static List<Master> getAllWTPartWithinContainer(String containerOID)
public static Map<String,Mastered> getAllBusinessObjWithinContainer(String containerOID)
public static List<String> getObjWithinContainer(String containerOID, String numberLike, String numberStr, boolean doEPM, boolean doWTPart, boolean doWTDocument) throws Exception
Exception
public static List<Persistable> getAllCheckedoutObjects(List<String> containerOIDs, List<String> users)