function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Neil WylieNeil Wylie 

Help with query

I am attempting to run the following query:
Set qr = g_SFApi.Query("Select * from Product where Neil__c = false", False)

I have created a custom field called Neil as a check box in the product table. The API name is
Neil double underscore c.

Any ideas?

Neil
foghornfoghorn
Your a brave man, messing with products ;)
Your query is running against the "old" product table.
Change product to product2 and you'll be fine.
Neil WylieNeil Wylie
Thanks for that, foghorn. It works fine. What's so scary about products?

Neil
foghornfoghorn

I suppose products are fine by themselves, but when you start talking about pricebooks/pricebookentry (many to 1 "instance" of a product)/line item/line item schedules that it starts to get hairy.
Neil WylieNeil Wylie
Guess what. That's where I'm at right now.