Forum management
- Threads started by me
- Threads I participate in

Developer forum

Conditionals

E-mail notifications

Lars Pham

Posted on 15/02/2021 15:35:37

Hi,

I'm exporting products from ecomproducts table to xml using Data Integration.

How do I use conditionals to export products from a set of GroupIds?

I tried this with no luck.

"Groups - Contains - GroupX"
"Groups - Contains - GroupY"

And also this.

"Groups - Contains - GroupX, GroupY"

Is there a way to do this?

Also is it possible to exclude a set of groupids, for example "Groups - Not Contains - GroupX, GroupY"

Replies

Dmitriy Benyuk

Posted on 15/02/2021 20:04:06

Hi Lars,
It is not implement in the way you want it to use. You can use the workarounds like that:
1) have several EcomProducts tables in the mappings and each mapping has its relevant condition for just single Group, an example is here:
https://doc.dynamicweb.com/forum/integration/integration/putting-condition-at-integration
2) Create some custom table script class, compile and supply the dll to website bin. The script can set some Product custom field value like "KeepRow" to true to those rows
that you want to export to xml, then in the mappings you can add a condition for this column having value of true so the irrelevant rows will be skipped.
You can read more about table script here.
Kind regards, Dmitrij

You must be logged in to post in the forum