Fetch product details from order table via flexi query

[former_member701730]

hi ,

I have a requirement to fetch all the order data in single CSV.

I am stuck with fetching products details from order table.

I understand that, order has collection of order entries and order entry has product associated with it.

Can someone please provide me the query to fetch product details from order table.

Thanks in advance !