You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Connect API ROQL query for Answers by Product

Received Response
edited Aug 4, 2017 5:41PM in Integrations and APIs 8 comments


So I'm using an Ajax Controller from the customer portal to search for answers with a custom field value assigned to a specific product but the query keeps failing.

RNCPHP\ROQL::query("SELECT * FROM Answer where CustomFields.c.is_issueofday = 1")->next();

Returns perfectly, but I wanted to know what products are assigned to the answer and filter by them so I ran a describe query and found this:

RNCPHP\ROQL::query("DESCRIBE Answer")->next();

    [Name] => Products
    [Type] => SubTable
    [Path] => Answer.Products

So I tried this Query:

RNCPHP\ROQL::query("SELECT Answer.Products FROM Answer where CustomFields.c.is_issueofday = 1")->next();

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!