web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) how to filter null loo...

Microsoft Dynamics CRM (Archived)

how to filter null lookup field

(0) Share

Report

Report

Posted on by KaeL

224

before on the Case entity we dont have field_PersonServiceId and now i want to get all of the Case without the field_PersonServiceId

and i try code like this

var filter = "?$filter=field_Patient/Id eq guid'" + patientId + "' and field_PersonServiceId/Id eq guid'" + null + "'";

and i got an error

Unrecognized 'Edm.Guid' literal 'guid'null''

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Ben Thompson 6,350 on at

Like (1)

Report
When an Entity Reference attribute is null the whole entity reference is null so the Id part doesn't exist.

var filter = "?$filter=field_Patient/Id eq guid'" + patientId + "' and field_PersonServiceId eq null";

should be all you need.

Was this reply helpful? Yes No
KaeL 224 on at

Like (0)

Report

Thank you so much sir, i tried that earlier but i put the null outside the " ". this one perfectly works. thanks again. God bless.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans