Dear colleagues

Do any of you have Crystal Reports or SQL queries that draw on the new (post-TMS 2014) Thesaurus module that you would be willing to share? I'm looking for something that would let me a choose a term in the thesaurus, and show me all its descendants, with some indication of what their ancestors are, so that I could export the data to some other format (e.g. CSV/Excel) and review the hierarchy - and suggest some remappings - there.

Any help would be gratefully received!

With thanks and best wishes

Rupert

Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]<mailto:[log in to unmask]>
Tel: +44 (0)20 7747 5921

[The National Gallery, Trafalgar Square, London WC2N 5DN]<http://www.nationalgallery.org.uk>
[Chris Ofili: Weaving Magic exhibition]<http://www.nationalgallery.org.uk/whats-on/exhibitions/chris-ofili-weaving-magic>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.