Hi there,
for $x in (db:fulltext('work', 'string theory')/ancestor::*:Doc except db:fulltext('work', 'elastic')/ancestor::*:Doc) return substring(data($x/Publish/PubDate/@d), 7)
I am storing Dates in YYYYMMDD Format as <PubDate d="20040608"> tag. The above query will return the Date of the Document published for the searched criteria. Using the BaseX 7.5, I was able to run the query correctly. But with 7.6, I am getting error
*"Single item expected, ("20040608", "20040609") found"*