You need to sign in to do that
Don't have an account?
Apex explorer/Data Loader question
Hi
I have a requirement where I have to extract couple of hundreds of rows and update price. Issue is in the query I have to use. When I try to use the following query with relationships and do an export in data loader no rows gets extracted.
Select p.product, p.shipment__r.name,p.id,p.name,p.unit_price__c from product_shipment__c p
where p.shipment__r.name like 'Test %'
and p.unit_price__c <> 0
My question is it possible to include relationships in dataloader query . If so, whats the issue with my query.
Also is there a way to export rows from apex explorer. When I click on the more button below the rows , I get a 'unhandled exception error '
Thanks in advance for your time
gvi
Don't use alias for your data loader query.
Select product, shipment__r.name,id,name,unit_price__c from product_shipment__c
where shipment__r.name like 'Test %'
and unit_price__c <> 0
Regards,
Kerwin
All Answers
"e." ??
-S
Try your query in apex explorer and check if it is valid and if you have any rows retrieved.
Regards,
Kerwin
Yeah When I run in apex explorer there are rows that are being returned
Only when I run in data loader it does not work
Hmm, then you should be able to retrieve the same data in Data Loader.
Have you checked that you are connecting to the same account for both explorer and data loader? have you checked the settings of explorer and data loader?
I did check . I am connecting to sandbox in both the cases
My question is when selecting fields from the object it does not show the child fields/master fields
Also how do I export rows from apex data explorer
Don't use alias for your data loader query.
Select product, shipment__r.name,id,name,unit_price__c from product_shipment__c
where shipment__r.name like 'Test %'
and unit_price__c <> 0
Regards,
Kerwin