Embeded types confusing with order by

[jt-helsinki]

I have an object with an embedded object (why, I don't know... ;o)

@Table()
export class Organisation {

    @PrimaryGeneratedColumn()
    id: number;

    @Column("string", { length: "250" })
    name: string;

    @Embedded(type => Contact)
    primaryContact: Contact;

}

@EmbeddableTable()
export class Contact {

    @Column("string", { length: "50", nullable: true })
    name: string;

    @Column("string", { length: "50", nullable: true  })
    email: string;

}

Note that each object has a "name" property. Which gives Organisation.name and Organisation.primaryContactName columns in the Database.

I try to do a select on this object ordering by organisation.name.

this.ormRepository
            .createQueryBuilder("organisation")
            .andWhere("organisation.organisationType = :organisationType")
            .andWhere("organisation.federationId = :federationId")
            .orderBy("organisation.name")
            .setParameter("organisationType", organisationType)
            .setParameter("federationId", federationId)
            .getMany();

The SQL that is generated is:

SELECT 
organisation.id AS organisation_id, 
organisation.name AS organisation_name, 
...
organisation.primaryContactName AS organisation_primaryContactName 
...
FROM organisation organisation WHERE organisation.id = ? 
..
ORDER BY organisation.primaryContactName ASC -- PARAMETERS: [..,10]

The orderby column is conflicting.

Cheers

JT

[pleerock]

released in 0.0.7-alpha.11