0

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?

dprian
  • 25
  • 7

0 Answers0