News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Dual-write table mappi...

Finance | Project Operations, Human Resources, ...

Answered

Dual-write table mapping filtering

(1) Share

Report

Report

Posted on by Migoed

49

Hello all,

Hope I've posted it in the correct section.

Question in regards to dual-write table mapping filtering. I am not yet familiar with the filter expressions used within FO.

We have set up a table mapping to put over transports from FO to dataverse (CE). Here we'd like to set up that FO only looks at the transports that have the status "Completed". Looked into some documentation, Customize table and column mappings - Finance & Operations | Dynamics 365 | Microsoft Learn.

Based on how I've read it, I've set up the following filter on the FO side: (STATUS == STATUS::Completed)

Not sure if it's correct or if it should be different.

Someone familiar with setting up these filters within FO and can help me?

dw question.png

All responses Img

All responses (2)

Answers Img

Answers (1)

Migoed 49 on at

Like (1)

Report

Dual-write table mapping filtering

Hello Layan Jwei,

We have done this yesterday. Turns out that the field was an enum field so the query in the filter was correct. The name of the status field within devbox was not status howver, but a different custom name. So instead it would be; (STATUS == DUYTransportStatus::Completed).

This managed to do the trick.

Regards,

Mick
Verified answer

Layan Jwei 7,780 Super User 2025 Season 1 on at

Like (2)

Report

Dual-write table mapping filtering

Hi Migoed,

you said that you are not sure if it's correct, did you test and see if transports with other statuses go to CE? in this way you can confirm if what you did is correct. But looking at the documentation it looks what u did is correct

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,241 Super User 2025 Season 1

#2

Martin Dráb 232,982 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans