Can Complex types be used in a Filter

[former_member209944]

Hello,

We have Entity Type (Task) with a property (CreatedBy) which is a Complex Type (User). The Complex Type contains the properties UserId & FullName.

Is filtering on Complex Type supported? In other words, can I filter on CreatedBy-UserId?

How should the syntax be in the URL?

Regards, Paul Lauwers.

Application Engineer

IFF.

[AshwinDutt · Accepted solution]

Hello Paul,

Yes its possible.

If ' C_Type ' is your Complex Type which has ' Name ' and ' UserId '.

Then URL is ->

/sap/opu/odata/sap/Z_SERVICE/Dummy_Entity?$filter=C_Type/Name eq 'John' and C_Type/UserId eq '00001'

Regards,

Ashwin

[former_member209944 · Accepted solution]

Thank you.

[ChandraMahajan]

Hi,

try $filter=CreatedBy/UserId eq 'xyz '

Regards,

Chandra