Operation Details
Description: Searches taxonomy terms by name and locale. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced.
Sterotype: nsmulti
SQL 
SELECT
    TaxonomyTerm.taxonomyTermID,
    TaxonomyTerm.nameTextID,
    TaxonomyTerm.code,
    TaxonomyTerm.definitionTextID,
    TaxonomyTerm.facetCode,
    TaxonomyTerm.bibliographicRefTextID,
    TaxonomyTerm.commentsTextID,
    TaxonomyTerm.creationDate,
    TaxonomyTerm.lastModifiedDate,
    TaxonomyTerm.status,
    TaxonomyTerm.customTermInd,
    TaxonomyTerm.parentTermID,
    TaxonomyTerm.codeUpper,
    TaxonomyTerm.countryCode,
    TaxonomyTerm.versionNo
INTO
    :taxonomyTermID,
    :nameTextID,
    :code,
    :definitionTextID,
    :facetCode,
    :bibliographicRefTextID,
    :commentsTextID,
    :creationDate,
    :lastModifiedDate,
    :status,
    :customTermInd,
    :parentTermID,
    :codeUpper,
    :countryCode,
    :versionNo
FROM
    TaxonomyTerm,
    LocalizableText,
    TextTranslation
WHERE
    TaxonomyTerm.nameTextID = LocalizableText.localizableTextID AND
    LocalizableText.localizableTextID = TextTranslation.localizableTextID AND
    TextTranslation.localeCode = :locale AND 
    TextTranslation.upperShortText LIKE :name