contacts.id in ()

Question

Hi,

I am trying to return a list of contacts for which I know the ids. I am using Rest v4.

I am running the get_entry_list procedure and it is working for returning all contacts, however when I add the following query it seems to fail and I get a NULL returned.

I am creating query programmatically, but this is what it looks like before it gets serialized. If it makes any difference, I am using VB.NET.

Key .query = "contacts.id IN ('332e3ad2-26ea-e908-34c7-548895071706', '799889b4-2b33-4568-57fb-54889544e640', '94b5837d-2139-97e9-a35d-5488959dd0f3')"

Thanks for looking.

Zev Roth · Accepted Answer

Hi,

It could be issue of SugarSQLValidator you may check the query and trace out in include/SugarSQLValidate.php

The subquery would be creating problem. You may try OR statements with the ids instead of IN()

Thanks,

Team Urdhva Tech

http://urdhva-tech.com