How to export flexible search query result as a CSV from HAC or HMC ?

[Former Member]

Hello Experts,

How to export below flexible search query result as a CSV from HAC or HMC ?

  select {cp.name},{cp.uid},{pg.uid},{csp.position},{csp.uid} from {ContentPage as cp join  ContentSlotForPage as csp on {csp.page}={cp.pk} join PageTemplate as pg on {cp.masterTemplate}={pg.pk} }

Hybris version - 5.7 Thanks, Nagarjuna.

[Former Member]

why you are not using export scripts to export data from HAC, I think that would be easy.

[tescopolitan]

Did you get an answer that works? I have been trying to do something similar but the export scripts in HAC don't work when querying multiple types.

[Former Member]

Go to Hac->Console->Impex Export and use something like this:

  "#%impex.getImpExExportWriter().getExportWriter().setFieldseparator(',');"
  INSERT_UPDATE Category;code;description
  "#% impex.exportItemsFlexibleSearch(""Select {c.code},{c.description} from {Category as c}"");"
 

[knallapati]

this was failing as it is expecting pk as the first column. Here is the working one for me.

"#%impex.getImpExExportWriter().getExportWriter().setFieldseparator(',');"
INSERT_UPDATE Category;pk;code;description"#% impex.exportItemsFlexibleSearch(""Select {c.pk},{c.code},{c.description} from {Category as c}"");"