Hej Nils!
I haven't tried this myself, but what if you use one of the odFolder.search() method formats that accept SQL as input? Wouldn't that allow you to use the "IN" operator freely, thereby allowing you to search both directly for DB values and also to search for multiple values at once?
Example of Method to use:
search(java.lang.String sql)
This method will search the folder.
Example of code, not tested:
odFolder.search("myFolderFieldname IN ('Val1','Val2','non-conformning value','val7')")
I guess you may have already tried this and it fails, just like you have described here?
Vänliga hälsningar,
/Lasse B