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 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'); retData = taxComponent.xmlFile(xmlFile=arguments.filePath,taxonomyID=arguments.taxonomyID); return retData;