web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How to add filter in Dual-write?

(0) ShareShare
ReportReport
Posted on by 90

Hi All,

We have try to filter data in dual-write(too for integration CRM-F&O).

We follow below Microsoft Document for filter but not get success.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dual-write/customizing-mappings

We got success in equal to filter like (numberofemployees == 1000) but when we tried same for 'le' or 'ge' at that time it`s not working.

When i applied '<' then also it apply 'equal to' filter.

Anyone can please help me to figure-out how to apply filter on dual-write.

Thanks in advance.

  • Suggested answer
    vinitgoyal2005 Profile Picture
    6,326 on at
    RE: How to add filter in Dual-write?

    Hi Maulik,

    If you are applying a filter to D365 FO side then you need to use a filter like : (ORGANIZATIONNUMBEROFEMPLOYEES > 1000)

    pastedimage1596660657146v4.png

    if you are applying a filter to CDS side then you need to use filter like : numberofemployees gt 1000

    pastedimage1596660498503v2.png

  • Maulik Lakhani Profile Picture
    90 on at
    RE: How to add filter in Dual-write?

    Thanks for the reply George Baluta.

    We tried to filter account base on "numberofemployees" which mention in Microsoft Document.

    We raise the ticket for that and discussion going on.

  • George_D365 Profile Picture
    on at
    RE: How to add filter in Dual-write?

    Hi Maulik Lakhani,

    I think this would be more suitable for a support request since we would probably need to look into the data that you are trying to filter on.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Product updates

Dynamics 365 release plans