Fetch products whose subscription type doesn't exists
For Every Product there are 3 records with the Same Product name but different Product Type(SAAS, Subscription, Perpectual)
For Example: For a product named Product A there exists 3 records:
Product Name Product Type
1. Product A SAAS
2. Product A Subscription
3. Product A Perpectual
Now there are some Products whose Product Type= Subscription doesn't exist.
How to get list of those Products.
@Parik I need to use Matrix Report for this .. right??
Can you suggest me some reference link with the above scenario that will be helpful.
Also can we fetch the records thru SOQL??
[object Object]: Aggregate query does not support queryMore(), use LIMIT to restrict the results to a single batch