Developer forum

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

Data Integration - filter cross tables

E-mail notifications
Thomas Jensen
Reply
Posted on 14/05/2019 14:36:11

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 Dynamicweb Employee
Dmitriy Benyuk
Posted on 20/05/2019 15:37:13
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: 2
 
Thomas Jensen
Posted on 12/08/2019 12:04:49
Reply

Hi Dmitriy

I found that it dos not work in version 9.4.18
But testede it in a 9.6.6 and there it works, when using "Order provider" as source

Thanks

Regrads Thomas

 

You must be logged in to post in the forum