Parag Chapre

How to add filter in Dual-write

How to add filter in Dual-write
Spread the love

In today’s article, we will see how to add filter in Dual write when syncing data from FinOps to Dataverse and vice versa.

For Dataverse, we can use Odata filter expression using Dual-write but for FinOps, we have to use different techniques which can be later in this article.

Step 1: Go Data management > Dual-write and select your table map.

In this case, I am using worker entity.

Step 2: Click on filter button.

This will edit query dialog box and specify your filter in ( )

For example, you want to sync few workers to dataverse or only one then your condition should be below.

Syntax

(your condition)

We can use below examples to filter expressions.

If you like this article, feel free to share it with others who might find it helpful! If you have any questions, feel free to reach out to me.

2 Comments

  1. […] to use different techniques which can be later in this article. Step 1: Go Data management >…… Continue Reading → Read Complete Post and Comments SBX – Two Col […]

  2. Hi. How do you save the filter? I tried this one but the filter I input under finops edit query is not saving

Leave a Reply

Your email address will not be published. Required fields are marked *