Need CoveredLevel PVO on OSMC algorithm with AssetId as query parameter
Dear experts,
I need to get max(EndDate) from Coveredlevel by passing CoveredAssetId as parameter in OSMC Algortihm ( I have code to get coveredassetid for the service line) equivalent to below query.
"Select max(EndDate) from oss_product_associations where covered_asset_id = 'xxxxxxxxx' "
To implement this I am to create a view object query function in the algorithm. But sadly there is no coveredlevel PVO available exposed to algorithm. Secondly there are certain VOs available in algo already for e.g. SubscriptionProductVO , ProductAssociationsOM etc. but these are not having any AssetId attribute.
Need your advise in this regard.
Thanks.
0