Finance | Project Operations, Human Resources, ...

Filter Not Working in FO side for Dual Write

(0) Share

Report

Posted on by Ashik Patel

267

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

All responses (10)

Answers (0)

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
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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

Tried this but not working
Ashik Patel 267 on at

Like (0)

Report

RE: Filter Not Working in FO side for Dual Write

try this

Field == '1'
Community Member Microsoft Employee 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
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.
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
André Arnaud de Cal... 291,359 Super User 2024 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.
Ashik Patel 267 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
André Arnaud de Cal... 291,359 Super User 2024 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?