I'm trying to determine if an array of records exist in the Smartstore based on their Name.
Ex. I have 'John', 'Bill', 'Frank' in the Smartstore and want to know if 'Bill' and 'Al' exist in one query.
Basically the equivlent of
IN in SOQL. I don't see any way to do that based on the smartstore query options, even using Smart SQL here:
Based on that link it looks like you currently can't include variables in the where clause.
My current plan is to just do the query everything option and iterate though it looking for my records, but it doesn't seem very efficient.
Has anyone accomplished this or something similar?