Connect API ROQL query for Answers by Product
Content
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();
0