Oracle LISTAGG

[Filipe Sousa]

Hi,

I'm trying to implement this query using querydsl sql 4.1.0 with oracle database

SELECT
  bce.BOLETIM_CTESP_ID, listagg(e.ABREVIATURA, '/') WITHIN GROUP (ORDER BY e.COD_ESCOLA DESC) escolas
FROM BOLETIM_CTESP_ESCOLA bce
  JOIN IPB_ESCOLAS e ON bce.COD_ESCOLA = e.COD_ESCOLA
WHERE bce.BOLETIM_CTESP_ID = 568
GROUP BY bce.BOLETIM_CTESP_ID;

What I'm missing is the DESC order

QBoletimCtespEscola bce = QBoletimCtespEscola.boletimCtespEscola;
QIpbEscolas e = QIpbEscolas.ipbEscolas;
WithinGroup<Object>.OrderBy escolas = SQLExpressions.listagg(e.abreviatura, "/").withinGroup().orderBy(e.codEscola);

List<Tuple> fetch = queryFactory.select(bce.boletimCtespId, escolas)
        .from(bce)
        .join(e).on(bce.codEscola.eq(e.codEscola))
        .where(bce.boletimCtespId.eq(568))
        .groupBy(bce.boletimCtespId)
        .fetch();

Using .orderBy(e.codEscola.desc()) gives me a sintax error

Thanks.

[timowest]

Hi.

Could you create an issue for this on GitHub?

Timo

[Filipe Sousa]

https://github.com/querydsl/querydsl/issues/1848