You need to sign in to do that
Don't have an account?
MaheemSam
List is giving 0 in debug log from trigger even data exist
Hi,
This list is returning 0 values even if data existing for opportunity.
list<SBQQ__Quote__c> qt = [select id from SBQQ__Quote__c where SBQQ__Opportunity2__c = :trigger.oldmap.keyset()];
SBQQ__Quote__c is not a child object it has a lookup value of opportunity there is a no master child relationship. Please suggest me how to fix.
Thanks
Sudhir
trigger OpportuntiyDelete on Opportunity (Before Delete) { list<SBQQ__Quote__c> qt = [select id from SBQQ__Quote__c where SBQQ__Opportunity2__c = :trigger.oldmap.keyset()]; // Here it is always returning 0 even if it has data to return. for(opportunity opp: trigger.old){ opp.adderror('Opportunity record cannot be deleted' + ' ' + qt.size() + ' ' + opp.id + ' ' + cpqid + ' ' + trigger.oldmap.keyset()); } }
This list is returning 0 values even if data existing for opportunity.
list<SBQQ__Quote__c> qt = [select id from SBQQ__Quote__c where SBQQ__Opportunity2__c = :trigger.oldmap.keyset()];
SBQQ__Quote__c is not a child object it has a lookup value of opportunity there is a no master child relationship. Please suggest me how to fix.
Thanks
Sudhir
Change your query to :
If tthis doesn't give you any record, the only reason list size is zero is because related records dont exist for given Id(s).
Copy Id of any Opportunity that you want to delete, run following command in Developer Console -> Query Editor -> From here you will get to know whether given Opportunity has related records in SBQQ__Quote__cobject or not.
If this helps solve your problem, mark this as BEST ANWER