[CSHARP-2120] Unable to filter nested document with oData Created: 07/Dec/17  Updated: 10/Dec/20  Resolved: 10/Dec/20

Status: Closed
Project: C# Driver
Component/s: Linq
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: justin teaw Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates CSHARP-1771 Support IIF method (i.e. ternary oper... Closed
Case:

 Description   

I am using oData and trying to filter the nested document's property. Filtering property on the root level works fine. When I start to filter state, I get an exception

"(IIF((

{document} {State}

== null), null, Convert(

{Address.State}

)) == True) is not supported."

{
"_id" : ObjectId("5a26b43b38a9447d8032e8a2"),
"personId" : UUID("50aa744d-95c3-4b77-9ffe-b2593c6d9732"),
"address" :

{ "state" : "california" }

}



 Comments   
Comment by James Kovacs [ 10/Dec/20 ]

This issue is the result of not translating IIF (AKA ternary operator) in the LINQ where clause. It is a duplicate of CSHARP-1771. Please follow that issue for updates.

Generated at Wed Feb 07 21:41:40 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.