Developer forum

Forum » Ecommerce - Standard features » Data Integration - filter cross tables

Data Integration - filter cross tables

Thomas Jensen
Reply

Hi

In Data Integration I'm trying to export some specifik orders

I'm filtring EcomOrders
OrderDate > {{DateDelimit||"@Code(System.DateTime.Now.AddMonths(-1))"}}
OrderShippingMethodeId = Ship10

Now I want to also export the EcomOrderLines that belong to those orders
How do i filter EcomOrderLines/OdrerLineOrderID for the filtert EcomOrders/OrdreId?

Regards Thomas

Replies

 
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Thomas,
you can use the Order provider as source provider and add EcomOrders and EcomOrderLines tables in the mapping. Then add conditions on the EcomOrders table. They should be applied on the EcomOrderlines table as well.
Regards, Dmitrij

Votes for this answer: 1

 

You must be logged in to post in the forum