Using the API tool I’m testing out SQL queries prior to creating the ajax call from my app, am trying to use a filter with WHERE IN to limit my query but I can’t figure out what it wants the SQL syntax to look like.
If I try
filter: projectKey in (‘jdYSeNvdygt8vi6xj’, ‘B3JsENuwGSBXEfxq9’)
"message": “Failed to filter records from ‘maProject’.\nExpected list or null”,
filter: projectKey in (‘jdYSeNvdygt8vi6xj’)
This returns the expected record:
filter: projectKey in ‘jdYSeNvdygt8vi6xj’
But this returns an empty set:
filter: projectKey in ‘jdYSeNvdygt8vi6xj’, ‘B3JsENuwGSBXEfxq9’
What does it want a list of string values to look like? I’m at a complete loss.