You need to sign in to do that
Don't have an account?
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')];
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')];
got it now..
Be sure to post your answer and markt it as the correct one.