Check if there's a value in any version
I'm trying to build a filter that will only show list items that have values in them regardless of the version.
Is there an elegant way of checking for a non-zero value in any version?
The two ways I know of doing this is to create line items for each version using [SELECT: Versions.version] and adding them up.
Or using NEXTVERSION() nested.
This works ok until you have many versions in the model and the maintenance becomes a pain.
Are there any other ways of doing this?