var getTopTerms = getTopTermsQueryForFacet(arguments.facetID,arguments.taxonomyID,arguments.orderby); var getTopTerms = QueryNew("temp"); var orderByText = ""; var orderByOptions = "ID,TermID,Name,TermName"; // Handle the ORDERBY parameter options if ( LEN(TRIM(arguments.orderby)) AND ListFindNoCase(orderByOptions,arguments.orderby) ) { if ( arguments.orderby EQ "ID" ) orderByText = "TermID"; else if ( arguments.orderby EQ "Name" ) orderByText = "TermName"; else orderByText = arguments.orderby; } SELECT * FROM TaxonomyDataView WHERE taxonomyid = AND facetid = AND (toptermname is not null OR toptermname != '') ORDER BY #orderByText# SELECT * FROM TaxonomyDataView WHERE TaxonomyName = AND FacetName = AND FacetID = ORDER BY TermName SELECT TaxonomyDataView.TaxonomyID, TaxonomyDataView.Taxonomyname, TaxonomyRelationshipType.TypeName AS AssociationName, TaxonomyRelationshipType.TypeDescription AS AssociationDescription, TaxonomyDataView.TermName AS SourceTerm, TaxonomyDataView.TermID AS SourceTermID, TaxonomyDataView.FacetID AS SourceFacetID, TaxonomyDataView.FacetName AS SourceFacetName, TaxonomyDataView_1.TermName AS TargetTerm, TaxonomyDataView_1.TermID AS TargetTermID, TaxonomyDataView_1.FacetID AS TargetFacetID, TaxonomyDataView_1.FacetName AS TargetFacetName FROM Term_Relationship INNER JOIN TaxonomyRelationshipType ON Term_Relationship.TaxonomyID = TaxonomyRelationshipType.TaxonomyID AND Term_Relationship.RelationshipType = TaxonomyRelationshipType.TypeName INNER JOIN TaxonomyDataView ON Term_Relationship.TaxonomyID = TaxonomyDataView.TaxonomyID AND Term_Relationship.IdSource = TaxonomyDataView.TermID INNER JOIN TaxonomyDataView AS TaxonomyDataView_1 ON Term_Relationship.TaxonomyID = TaxonomyDataView_1.TaxonomyID AND Term_Relationship.IdTarget = TaxonomyDataView_1.TermID WHERE TaxonomyDataView.TaxonomyID = AND AND AND TaxonomyDataView_1.FacetID = AND TaxonomyRelationshipType.TypeName = ORDER BY SourceTerm, targetTerm SELECT * FROM Taxonomy WHERE state = 1 ORDER BY Name SELECT DISTINCT FacetID, FacetName FROM TaxonomyDataView WHERE TaxonomyID = ORDER BY FacetName if( taxQry.recordCount ) facetStruct = server.ADF.objectFactory.getBean("Data_1_0").queryColumnsToStruct(taxQry, "FacetID", "FacetName"); var getTopTermsQry = getTopTermsQueryForFacet(arguments.facetID,arguments.taxonomyID,arguments.orderby); var termStruct = StructNew(); if( getTopTermsQry.recordCount ) termStruct = application.ADF.data.queryColumnsToStruct(getTopTermsQry, "TermID", "TermName"); var taxObj = getCSTaxObj(arguments.taxName); var rtnArray = ArrayNew(1); var facetID = taxObj.getFacetID(arguments.facetName); var topTermArray = getTopTermIDArrayForFacet(facetID,taxObj.getID()); var i = 1; for(i=1;i<=ArrayLen(topTermArray);i++){ rtnArray[i] = StructNew(); rtnArray[i].termID = topTermArray[i]; rtnArray[i].children = getNarrowerTermArrayOfStructs(taxObj.getID(),facetID,topTermArray[i]); } return rtnArray; var i = 1; var csTaxObj = createObject("component", "commonspot.components.taxonomy.taxonomy"); var rtnArray = ArrayNew(1); var termIDS = ""; csTaxObj.init(taxID, "false"); termIDS = csTaxObj.getNarrowerTermArray(facetID,termID,false); for(i=1;i<=ArrayLen(termIDS);i++){ rtnArray[i] = StructNew(); rtnArray[i].termID = termIDS[i]; rtnArray[i].children = getNarrowerTermArrayOfStructs(taxID,facetID,termIDS[i]); } return rtnArray; var retData = StructNew(); var taxComponent = Server.CommonSpot.api.getObject('Taxonomy'); var taxInfoQry = taxComponent.getList(); SELECT * FROM taxInfoQry WHERE ID = if ( taxInfoQry.RecordCount ) { retData.ID = taxInfoQry.ID[1]; retData.NAME = taxInfoQry.NAME[1]; retData.DESCRIPTION = taxInfoQry.DESCRIPTION[1]; retData.VERSION = taxInfoQry.VERSION[1]; retData.STATUS = taxInfoQry.STATUS[1]; } return retData; var retData = StructNew(); var taxComponent = Server.CommonSpot.api.getObject('Taxonomy'); var validData = StructNew(); var importData = StructNew(); if ( FileExists(arguments.filePath) ) { validData = taxComponent.validate(xmlFile=arguments.filePath,taxonomyID=arguments.taxonomyID); if ( StructKeyExists(validData,"isValid") AND validData.isValid ) { importData = taxComponent.import(xmlFile=arguments.filePath,taxonomyID=arguments.taxonomyID); retData = Duplicate(importData); if ( arguments.activate AND StructKeyExists(retData,"TaxonomyID") AND IsNumeric(retData.TaxonomyID) AND retData.TaxonomyID GT 0 ) { if ( getTaxonomyStatus(taxonomyID=retData.TaxonomyID) ) { retData.active = true; } else { try { taxComponent.activate(taxonomyID=retData.taxonomyID); retData.active = true; } catch (any ex) { retData.active = false; writedump(retData); writedump(ex); // Create Log Msg errorStr = arguments.filePath; logMsg = "[taxonomy_1_1.handleTaxonomyFileImport] Error attempting to import the File: #errorStr##Chr(10)##cfcatch.message#"; if ( StructKeyExists(cfcatch,"detail") AND LEN(TRIM(cfcatch.detail)) ) logMsg = logMsg & "#Chr(10)#Details: #cfcatch.detail#"; server.ADF.objectFactory.getBean("log_1_0").logAppend(logMsg); } } } retData.valid = true; } else { retData = Duplicate(validData); retData.valid = false; } } else { retData.message = "File Path is invalid or incorrect! " & arguments.filePath; retData.fileExists = false; } return retData; var taxInfo = getTaxonomyInfo(taxonomyID=arguments.TaxonomyID); if ( StructKeyExists(taxInfo,"STATUS") AND taxInfo.STATUS EQ "Active" ) return true; else return false;