correct XAM way to query for content passed the retention period

Hi all,

I'm using XAM to interact with Centera. I can't figure out the correct way to find the clips which are passed their retention period.

I thought about using the SQL-like query functionality like this:

select ".xset.xuid" where "app-vendor" = 'myVendorName' and "app-name" = 'myAppName' and

But I'm having two problems with that approach:

1) I can't figure out the "part to detect clips which are passed their retention period" in the where clause

2) This seems to be very slow if there are a lot of documents in Centera

So, should I use another method? If so, what would that look like? If not, what do I need to complete the where clause? Any advice is welcome.

Thanks,

Ludovic