[teiid-issues] [JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid

groupby functionality not working with Teiid -------------------------------------------- Key: TEIID-5688 URL: https://issues.jboss.org/browse/TEIID-5688 Project: Teiid Issue Type: Bug Reporter: Christoph John Assignee: Steven Hawkins Priority: Major Hello together, I tried to get the distinct values of a certain column in a mysql table and used the following query https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr... However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows: { @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDiaryEntry,fkIdProductCode)", value: [ { @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)", idDiaryEntry: 17, fkIdProductCode: 17 }, { @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)", idDiaryEntry: 18, fkIdProductCode: 38 }, { @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)", idDiaryEntry: 19, fkIdProductCode: 482 }, { @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)", idDiaryEntry: 20, fkIdProductCode: 1564 }, { @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)", idDiaryEntry: 21, fkIdProductCode: 17 } ] } So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this? Thanks for your help