Filtering for the most recently created CDO record in a Shared Filter

Hello Community,

I have a use case where I need to build a Shared Filter in Eloqua to use on a Campaign Canvas for decision routing.

The filter needs to query records in a Custom Data Object (CDO) that has a 1:N relationship with Contacts. Specifically, I need the filter to evaluate only the most recently created CDO record for each contact.

Does anyone know if or how it’s possible to target the latest CDO record within a Shared Filter? Any workarounds or best practices would be greatly appreciated!