i have this flexisearch code:
import de.hybris.platform.core.model.order.*
import de.hybris.platform.core.model.product.*
import de.hybris.platform.jalo.flexiblesearch.FlexibleSearch;
query = """
Select {o:code}, {p:code}, {oe:rrp} from {
OrderEntry as oe
join Order as o on {oe:order}={o:pk}
join Product as p on {oe:product}={p:pk}
}
where {o:code} = ?orderCode
"""
result = FlexibleSearch.getInstance().search(query, [orderCode: "12345555"], [String.class, String.class, String.class], true, true, 0, -1).result
int i = 1;
for (result in result){
out.println(result.get(0) + "--" + result.get(1) + "--" + result.get(2));
i++
}
But I wanted to add multiple order codes to the query so I can fetch orders depending on the code. Something like:
orderCode: "12345555", "1576789", "56768"
What should be my query to achieve my requirement?