0

I am new to Hybris. what I am trying to do is Export Data (code from product and name from catalog) of two joined tables using flexible search. I Wrote a query but cant understand how use it as impex export. This will be My Query

SELECT {p:code},{c:name} FROM {product AS p JOIN catalog AS c ON {p:catalog}={c:pk}} 
WHERE {p:description} LIKE '%meat%'

How write Impex header for this export ?

Pertsh Galstyan
  • 41
  • 7

1 Answers1

1

Try this

INSERT_UPDATE Product;code[unique=true];catalogVersion(catalog(name[lang=en]));
"#% impex.exportItemsFlexibleSearch(""SELECT {p:pk} FROM {product AS p} WHERE {p:description} LIKE '%meat%'"");"

For export with flexible search, you need to select only PK. To get the catalog's name from the product model, you need to get it from

product -> catalogVersion -> catalog -> name.

Note that name in the catalog is localized, hence I put "lang" there, change en to any language code that you use.

Adiputera
  • 171
  • 1
  • 2
  • 13