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.