Fiori List Report displays identical records despite underlying CDS View containing distinct data

[angeliev]

Hello guys,

I'm facing an issue with my Fiori List Report App where it displays identical records, even though the underlying CDS View contains distinct data. I have verified that the data in the CDS View is correct, but the app still shows multiple rows with the same values for all fields. I suspect there might be a problem with data binding or the OData service configuration, but I haven't been able to pinpoint the exact cause.

As you can see on my screenshot from the CDS View, the data there is being read successfully from the database, but in the Fiori App it's not showing properly. Is there any annotation that I should add additionally for batching the data or what should I do so that it works?

Any help would be greatly appreciated!

Thank you!

[junwu]

check what the odata returns you.

[hitesh2]

Hi Angeliev

If you are using transaction SEGW for a gateway service, go to the properties of the entity types and set the keys correctly according to the CDS views.

[Joel_John · Accepted solution]

The problem is the primary keys. They have to be unique for every row that is returned.

This should fix the problem.

[angeliev]

Hi hitesh2,

the issue was as you said in the primary key. Since I´ve chosen other primary key, the results are correct.

Thank you a lot for your response!

Best wishes
Angeliya

[M-K]

Hi Angeliya, are those entries complete duplicates or only for the date/time? 

Do you have duplicates for other times as well? Check out the binding of the rows with UI5 Inspector

[angeliev]

Hi and thank you for the fast response,

where exactly can I check the response from the OData ? Is it somewhere in the dev tools from the console ?

Thank you in advance !

Best wishes, 
Angeliya

[junwu]

dev tool, network tab

[angeliev]

Thank you for your response. I have checked the OData response and it returns correct data -

[angeliev]

Thank you for your response. I have checked the OData response and it returns correct data - it seems like the problem is the way Fiori displays it, since for instance the last search I become 4 data sets as result for every 15 minutes - 00:00, 00:15, 00:30, 01:00... Any further ideas ?

[junwu]

don't understand what you are talking