can me write flexible query result data into excel in Hybris

[former_member1113129]

I need to write my data fetched from flexible query into excel. result contains approx 20 K result rows. is their any way to get write this data directly in excel. Please suggest for this one.

[former_member659063]

If that is the case.. then I will suggest you to try the groovy.. It provides option to handle the file operations.. By using groovy you can play with the data as you want..

[former_member1113129]

Thanks for information. I will ask if i need any assistance further.

[former_member659063]

Hello .. For your case, you can try to use the impex export script with flexible query like as below.

insert_update MerchantOffer;code[unique=true];name;catalogVersion;approvalStatus "#% impex.exportItemsFlexibleSearch(""select {pk} from {MerchantOffer} where {CatalogVersion}=8796125003697"");"

[former_member1113129]

Thanks Kannan. Actually I need to get data from different tables as query has many joins and data is not like one column PK. it has four column like product code pc13 , pc9 , pc5 and its stock.

Please suggest if you have any suggestion.