Filter on unique results

Summary

Is it possible to get unique items from an SDP or rest call response?

Content

Hello community,

Is it possible to get unique items from an SDP or rest call response?

An example to clarify using a car app. Our dataset includes a ‘car’ business object which contains brand, model and color.

We want to answer the question “which brands produce yellow cars?”

If we apply a filter on an SDP where we filter on the attribute color being equal to “yellow” we get an output that contains some brands multiple times because they have several models in that color. How can we best prevent that?