Get Answer ID through Answer custom field value
We have written a query in attempts to get the Answer ID by the value of a custom field in Answer.
The attached query does not work for us, we have tried both query and queryObject methods to no avail. Any advice would be appreciated!
$string = "some custom field value"; $AnswerId = RightNow\Connect\v1_2\ROQL::queryObject("SELECT Answer.ID FROM Answer WHERE (CustomFields.c.custom_field_name='".$string."')")->next();