Developer forum

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

Data Integration - filter cross tables

Thomas Jensen


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


Dmitriy Benyuk
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