Dual Write Filter Error

(1) Share

Report

Posted on by lispyj

2,755

I added the SalesType field to the SalesOrderHeaderAttachmentEntity and am now trying to filter the Notes map to sync sales orders only. (We receive and error when we try to add a note to a Return Order in Finance. Which makes sense as returns are in a seperate table in CRM.

I have tried both filters below and they successfully filter return orders, but they also prevent sales order notes from syncing. What is my error?

((SalesType == SalesType::Sales) &&((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL")))

((SalesType == "Sales") &&((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL")))

All responses (2)

Answers (0)

Suggested answer

lispyj 2,755 on at

Like (0)

Report

Dual Write Filter Error

This is the winner!

(((SalesType==SalesType::Sales)) && ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL")))
lispyj 2,755 on at

Like (0)

Report

Dual Write Filter Error

Can someone tell me if && is the correct entry for AND in this syntax?

Also

What is the correct way to filter for enum? I tried the field = enum value as Text "Sales" and I also tried the field = enumType::Value without "". Is one of these correct?

I am pretty sure that the name of the field SalesType is correct because my value is not evaluating as I need it to. The filter I need is records having sales type of Sales and Note type of either Note or URL.

Thanks for any help you can give.