This seems like it may be quite a straightforward query for experienced XQuery people - so forgive me if so. However, I am very much a novice when it comes to XQuery and am having trouble pulling out the information I need.
Basically, I have a large repository of XML files, each of which contains information about a particular book. Each file has an ISBN tag (<isbn>), and some, but not all, files also have a <copyright> tag, giving info about its copyright status.
I want to run an XQuery that searches for all files that include a copyright tag, and then for these files return both the ISBN and also the text contained within the copyright tags.
Secondarily, I'd also like to be able to then search by date (eg all files with a date earlier than Jan 2014, and all files from Jan 2014 onwards etc)
Can anyone help with this? It would be hugely appreciated if so. If more information is required just let me know. Thanks in advance!