Override Distinct options/values when "Alternate Input" is checked.

[GoogleCodeExporter]

I use "Alternate Input" with a SQL query like you suggest on help:
SELECT post_title, ID
FROM [+table_prefix+]posts
WHERE post_type = 'wpsc-product'

But ID isn't saved in db, it only saves the "post_title" field.
Looking on the custom field box (in a new post linked to that custom field) in 
the input value only the "Post title" appears.

Thanks

Original issue reported on code.google.com by r...@wmr.it on 10 Feb 2014 at 12:35

[GoogleCodeExporter]

When you do this, the checkbox for "Distinct options/values? " still applies -- 
once you check that, the field (and the data saving) will behave in the way you 
want.

Original comment by ever...@fireproofsocks.com on 10 Feb 2014 at 5:25

• Changed state: Invalid

[GoogleCodeExporter]

Original comment by ever...@fireproofsocks.com on 10 Feb 2014 at 5:29

• Changed title: Override Distinct options/values when "Alternate Input" is checked.
• Changed state: Accepted
• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

I didn't check "distincti options/values" but I think that "sql" setting 
overwrite every other setting.

Original comment by r...@wmr.it on 10 Feb 2014 at 5:40

[GoogleCodeExporter]

Yes: that's why I changed this from a bug to a feature request.  Subscribe to 
the ticket if you want updates.  For now, check the "Distinct options/values" 
box.

Original comment by ever...@fireproofsocks.com on 10 Feb 2014 at 5:42

[GoogleCodeExporter]

Committed revision 854914.

Original comment by ever...@fireproofsocks.com on 10 Feb 2014 at 5:51

• Changed state: Fixed

[GoogleCodeExporter]

Thanks, with "distinct options/values" it works good. 
Maybe a good new feature an option to save in custom field an array with 
"label/id".

Original comment by r...@wmr.it on 11 Feb 2014 at 9:38