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.