Duplicate Values in Fiori Elements Value Help

[darsh1327]

Hi Community,

I am implementing App with SAP CAP backend and Fiori Elements as the frontend.

When implementing the filer fields, duplicate values are coming in the value help

Reason:

Because the entity assigned to this value help contains multiple records, so the values are repeating.

Fixes Tried.

Tried to create a view over my entity but is failing due to some errors, how can i achieve this without create new entities for this value helps, instead use the existing one itself.

Please find the attached screenshot regarding the same.

[darsh1327]

Any suggestions, when i am using the backend odata service for filters in sap fiori, the values are duplicated but when i am using local db or hana db i was able to create views on the DB and get the distinct records

[junwu]

why you cannot create new one? did you use select distinct?

[darsh1327]

Yeah i tried select distinct but its not working

[junwu]

your code please....