[
https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin...
]
Christoph John updated TEIID-5688:
----------------------------------
Description:
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?
Thans for your help
was:
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
}
]
}
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?
Thans for your help
--
This message was sent by Atlassian Jira
(v7.12.1#712002)