DQL for thesaurus

lybelle

Hi! I know that by using the hint Enable(ft_thesaurus_search) would help us pull records with words in the thesaurs list. But now we would just like to know if there is a way in DQL to pull the uploaded thesaurus list?

For example we have in the thesaurus the following:

<skos:Concept rdf:about="http://www.my.com/#INTERNATIONAL">

  <skos:prefLabel>INTERNATIONAL</skos:prefLabel>

  <skos:altLabel>INTL</skos:altLabel>

  <skos:altLabel>INT’L</skos:altLabel>

  </skos:Concept>

  <skos:Concept rdf:about="http://www.my.com/#INTL">

  <skos:prefLabel>INTL</skos:prefLabel>

  <skos:altLabel>INTERNATIONAL</skos:altLabel>

  <skos:altLabel>INT’L</skos:altLabel>

  </skos:Concept>

  <skos:Concept rdf:about="http://www.my.com/#INTL.">

  <skos:prefLabel>INTL.</skos:prefLabel>

  <skos:altLabel>INTERNATIONAL</skos:altLabel>

  <skos:altLabel>INT’L</skos:altLabel>

  </skos:Concept>

We would to do a select statement like:

Select * from Thesaurus

Result:

INTERNATIONAL

INTL

INT'L

Andrea Paci

A thesaurus is installed on xPlore and leveraged while running fulltext searches. It cannot be directly accessed via DQL like a registered database table.

As per the xPlore administration guide:

You can view a list of thesauruses for each domain using xPlore administrator. Open Diagnostic and

Utilities > Thesaurus. Choose the domain (Documentum Content Server repository) for the thesaurus.

The list shows a thesaurus URI, indicates a default thesaurus, and the date it was imported.

Alternatively:

You can view thesauri and their properties in the xDB admin tool. Navigate to the /xhivedb/root-library/<domain>/dsearch/SystemInfo/ThesaurusDB library."