Groovy script - using flexible search to select query

 import de.hybris.platform.cronjob.enums.*

import de.hybris.platform.servicelayer.cronjob.PerformResult

import de.hybris.platform.servicelayer.search.*

import de.hybris.platform.servicelayer.model.*

import de.hybris.platform.catalog.enums.ArticleApprovalStatus

searchService = spring.getBean("flexibleSearchService")

modelService = spring.getBean("modelService")

query = new FlexibleSearchQuery("select * FROM {MSAVariantProduct AS product JOIN Product2SalesOrg AS pso ON {pso.source}={product.PK} JOIN SalesOrg AS so ON {so.PK}={pso.target}}");

searchService.search(query).getResult().each {

 

}