How to Export data from two types in a single export item script?

[Former Member]

How to Export data from two types in a single export item script? i.e to combined base product and variant product using export script ?

[VinayKumarS]

Hello Sandeep,

I have come across the same scenario earlier. below example might be useful for you.. it will retrieve the data from two tables...

 "#%impex.getImpExExportWriter().getExportWriter().setFieldseparator(',');"
 INSERT Order;code;discounts(code);discounts(currency(isocode));discounts(value)
  "#%impex.exportItemsFlexibleSearch(""select {o.pk} from {order as o join orderdiscountrelation as r on {o.pk}={r.source} join discount as d on {r.target}={d.pk}}"");"
 

[shiva_vaibhav_makam]

technically your are retriving the data from 1 table only.. i too have same question..i want data from 3 tables ...any idea ??