+ Start a Discussion
Vijay sidaraddiVijay sidaraddi 

im getting record id instead values for lookup fields

HI Friends,

Can someone help me where im wrong in this query as im getting only record id instead its values which i have highlighrd fields  in bold which are lookup fields. even if i tried for relationship still im getting record ids.


        lstAssignment = [SELECT ENQ_Project_Name__c,ENQ_AFE__c,ENQ_Inspection_Level__c,
                         ENQ_Status__c,ENQ_Surveillance_Discipline__c,ENQ_Other__c,ENQ_QSC_Contact__r.Name,
                         ENQ_QSC__c,ENQ_Enbridge_Work_Order_Number__c,ENQ_Vendor_Shop_Number__c,ENQ_QSC_Work_Order__c,
                         ENQ_Supplier_Tracking_Number__c,ENQ_QSC_Report_Number__c,ENQ_Prime_Supplier_Name__c,                  ENQ_Sub_Supplier_Name__c, ENQ_Prime_Supplier_Contact__c,ENQ_Sub_Supplier_Contact__c,ENQ_Estimated_of_Visits__c,ENQ_Scheduled_Start_Date__c, ENQ_Estimated_Assignment_Hours__c,ENQ_Scheduled_End_Date__c,ENQ_Actual_Hours__c,ENQ_Estimated_Travel_Distance__c,ENQ_Hours_Remaining__c,ENQ_Unit_of_Distance__c,ENQ_Actual_Distance_Miles__c,ENQ_Distance_Remaining__c,ENQ_Comments__c  FROM ENQ_Assignment_Package__c
                   WHERE Id = :ApexPages.currentPage().getParameters().get('Id')];
                               
    
Vijay sidaraddiVijay sidaraddi
got it now..
 
JeffreyStevensJeffreyStevens
Be sure to post your answer and markt it as the correct one.