function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Indusa AdminIndusa Admin 

Aggregate Expressions Use Field Aliasing

String query = 'SELECT Id, Name, Contract__r.Account.Name AccountName, Contract__r.Account.Industry Industry, Contract__r.Account.Sub_Industry__c SubIndustry, Contract__r.Account.Account_Owner_Alias__c AccountOwner, Contract__r.ContractNumber ContractNumber, Contract__r.Account.Owner.FirstName OwnerFirstName, Contract__r.Account.Owner.LastName OwnerLastName,Contact__r.FirstName ContactFirstName, Contact__r.LastName ContactLastName, Contract__r.Account.CSM__c CSMId, Contract__r.Account.CSM__r.FirstName CSMFirstName, Contract__r.Account.CSM__r.LastName CSMLastName,Product__r.Research_Area__c ResearchArea,Product_Code__c ProductCode,Contract__c ContractId,Contact__c ContactId,Contact__r.Title_Level__c TitleLevel,Status__c,Contract__r.AccountId AccountId,Product_Family__c ProductFamily FROM Contract_User__c  LIMIT 200';
        return Database.getQueryLocator(query);
Hardik ChavdaHardik Chavda
Can you please explain, where do you have issue?