Hi,

I'm facing problem having subquery.

Here is my query:

---------
QueryResult query = binding.query("select Title, "
    + " from ContentVersion v where "
    + "v.ContentDocumentId = '(select id from contentdocument c where c.latestpublishedversionid like \'<somevalue>%\')'");
 ----------

I tried couple other approaches to escape '%' but, no luck.

no viable alternative at character '%'  is the error I see on execution.

Did I miss anything?

Thanks,
Suresh

Hi,

I'm facing problem having subquery.

Here is my query:

---------
QueryResult query = binding.query("select Title, "
    + " from ContentVersion v where "
    + "v.ContentDocumentId = '(select id from contentdocument c where c.latestpublishedversionid like \'<somevalue>%\')'");
 ----------

I tried couple other approaches to escape '%' but, no luck.

no viable alternative at character '%'  is the error I see on execution.

Did I miss anything?

Thanks,
Suresh