Query Salesforce Data Error - Query too complicated

[cdfisher89]

I am getting the below error when I query our opportunity (assignment) data from Salesforce.  How do I simplify the query?  Do I have to pull-in less fields?

[cdfisher89]

I am also getting this errror for a custom object.

[cdfisher89]

Help! Still having this issue!

[cdfisher89]

I solved it.  I just needed to go into the advanced query editor and reduce the number of fields

[Charles]

I'm having the same issue, but cannot work out how to edit the query to reduce the columns.

How can the columns be selected prior to the creating the connection?

[cdfisher89]

You need to Click on Edit in when you are loading the object - see image.  You then go into advanced Query editor and specify what columns you want.  Sorry for the late respocnc