Reply
Visitor
SupportGuy
Posts: 2
0

FileExporter Attachement export - Need to filter on Cases fields

Hello,

We are using the ticketing module to manage our support cases.

We are migrating to another external application and want to retrieve attachment from a set of cases.

I know on which Case field to make a filter, but up to now I have'nt succeded in making a filter with FileExporter (modification of "beans.xml" file to modify SQL queries)

I have 2 questions :

1) Is it possible to make SQL join with FileExporter with another table thant "Attachment"?

2) If the response to above question is yes, how could I make a query to filter Attachments depending on Cases fields?

The join I'm trying to do looks like this:
SELECT Case.Type, Attachment.Id, Body FROM Attachment, Case WHERE Case.Type='IPTV' AND Attachment.ParentId=Case.Id

Without this filter atempt, FileExporter is working fine.

Visitor
SupportGuy
Posts: 2
0

Re: FileExporter Attachement export - Need to filter on Cases fields

May be I'm not in the propoer forum. Should I post this topic elsewhere? Is it that complicated to make simple SQL request in SalesForce?
Newbie
Qyers
Posts: 1
0

Re: FileExporter Attachement export - Need to filter on Cases fields

Hello, I am trying to do something similar, I was wondering if you found an answer?  I am trying to do the same I want to export 1200 attachments from particular account records. I have a custom field on the account which I can reference. If I don't apply this filter I will end up with over 200,000 attachments which neither I or my harddrive needs...