Finance | Project Operations, Human Resources, ...

Filter Not Working in FO side for Dual Write

(0) Share

Report

Posted on by Ashik Patel

275

Hello Team,

i applied filter in D365 Finance and operations in Dual Write but it is not working

Filter type : Not equal

i also tried below

(accountnumber ne null)

(accountnumber ne '')

(accountnumber != null)

(accountnumber != '')

please give me any suggestions

I have the same question (0)

All responses (10)

Answers (0)

André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (1)

Report

RE: Filter Not Working in FO side for Dual Write

Hi Ashik,

Are you applying the filter on the F&O side or Dataverse side? What is the field type you try to filter?

Was this reply helpful? Yes No
Ashik Patel 275 on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

I applied filter in F&O side and field type is string

Was this reply helpful? Yes No
André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

In that case, I would expect that accountnumber != "" should work. However, I have not used filters to exclude records where a certain field is empty.

Was this reply helpful? Yes No
ToddB on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

Hi Ashik,

I found the below documentation:

Customize column mappings, add transforms, and enable filtering

docs.microsoft.com/.../customizing-mappings

Was this reply helpful? Yes No
Suggested answer

Sheriffff 35 on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

Hi Ashik, this filter in the dual write FO and CE sides worked with me after several tries:

1. FO side filters:

A. Equal:

Single Enum filter: (FieldName == EnumType::Test)
Multiple Enum filters: ((FieldName == EnumType::Test) && (FieldName != EnumType::Test))

Single String filter: (FieldName like "Test")
Multiple String filters: ((FieldName like "Test") && (!(FieldName like "Test")))

B. Not equal:

Enum filter: (FieldName != EnumType::None)
String filter: (!(FieldName like "Test"))

2. CE side filters:

A. Equal:

Single Enum filter: FieldName == ‘Test’
Multiple Enum filters: FieldName == ‘Test’ and FieldName == ‘Test’

Single String filter: FieldName eq ‘Test’
Multiple String filters: FieldName eq ‘Test’ and FieldName eq ‘Test’

B. Not equal:
Enum filter: FieldName != ‘Test’ (not sure)
String filter: FieldName ne ‘Test’

All experts please feel free to add your inputs here please.

Don't forget the brackets!

If this is helping, please mark my answer.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Filter Not Working in FO side for Dual Write

Hi, Can you help me in applying Dataverse filter for Yes/No field? I have tried field = 1 but not working

Was this reply helpful? Yes No
Ashik Patel 275 on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

try this

Field == '1'

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

Tried this but not working

Was this reply helpful? Yes No
ToddB on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

Hi Mudassar,

If you are still needing assistance, please start a new thread regarding your filter question.

Thanks in advance.

Was this reply helpful? Yes No
pierre-olivier.pujo... 93 on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

Hello,

What about the records wich are attached to the Customer... When you filter out a customer, if you sync Sales Orders and the Customer is not in CRM, an error will prompt (due to Customer was not sync).

Is it possible to filter Sales Orders based on a filter on Customer ?

Thank you for any advice!

POP

Was this reply helpful? Yes No