betterbong / excel-connector

Automatically exported from code.google.com/p/excel-connector
0 stars 0 forks source link

Allow use of IN query on ID field types #16

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Query list of opportunity's based on some criteria
2. Try to query list of accounts by doing in on returned Account ID

What is the expected output? What do you see instead?
List of accounts matching account ID's in previous query
Instead it throws an error

What version of the product are you using? On what operating system?  With
what Salesforce.com edition?

11 Winter Release
XP
Professional

Please provide any additional information below.

Changing
{{{ If ((opr = "in" Or opr = "on") And field_obj.Type = "reference" Then }}}
To
{{{ If ((opr = "in" Or opr = "on") And (field_obj.Type = "reference" Or 
field_obj.Type = "Id") Then }}}
in s_force Module works for me

Original issue reported on code.google.com by tre...@gmail.com on 21 Jan 2011 at 11:35

GoogleCodeExporter commented 8 years ago
I like it, thanks.  I will include in the next build, probably in April

Original comment by vneh...@gmail.com on 11 Mar 2011 at 4:07