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