i met a very surprising situation, where roll-up summary field is showing in object manager but not available in SOQL query,
Error :
ONB2__Status__c, ONB2__InitalMRR__c, ONB2__MRR__c, ONB2__MRUR__c FROM
^
ERROR at Row:3:Column:99
No such column 'ONB2__MRR__c' on entity 'ONB2__Subscription__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
SOQL Query : ONB2__Subscription__c result = [SELECT ONB2__Account__c, id, name, CreatedById, CurrencyIsoCode, ONB2__LastInvoiceRun__c, LastModifiedById,
ONB2__NextInvoice__c, OwnerId, ONB2__BankAccountOwner__c, ON_QuoteNumber__c, ONB2__RenewalDate__c,
ONB2__StartDate__c, ONB2__Status__c, ONB2__InitalMRR__c, ONB2__MRR__c, ONB2__MRUR__c FROM ONB2__Subscription__c
WHERE Id = :SubscriptionId];
I shall be grateful to you for your kind assitance.
Thanks and regards
답변 2개
