Hello Ana,
this is actually very conveniently done using group by (you can see some more examples of group by in our documentation at docs.basex.org). Should look something like this:
for $row in //row let $author := $row/column[@name = "NOMECOMPLETO"] group by $author return $author || ":" || string-join(($row/column[@name = "TITULO"]), ", ")
Cheers Dirk
On 11/16/2015 12:09 PM, Ana Victória Ladeira wrote:
Good morning.
I have an XML file of the following format:
<?xml version="1.0" encoding="UTF-8"?>
<resultsets> <resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <row> <column name="TITULO">A Adequação de Sistemas Baseados em Casos no Sequenciamento Inteligente de Ações</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Sistemas Distribuídos Inteligentes</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Uma Arquitetura para Planejamento Inteligente</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Navegação de robôs móveis com Lógica Paracpmsistente Anotada e método de Campos Potenciais</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> <row> <column name="TITULO">Adaptation in a Traffic Control System</column> <column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column> </row> ...
The file contains titles for articles and their authors..
I was asked to develop a query that returns the author's name followed by the titles of all of its articles, so the result would be something like this:
<Author1>:<Article1>, <Article2>, <Article3>... <Author2>:<Article1>, <Article2>... ...
Any ideas on how can I do it?
Thank you in advance.