Can Complex types be used in a Filter
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.
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'