0

I'm trying to filter Azure Table Storage using OData filters but for boolean values it always returns null results.

Here is list of filters that i've already tried:

  • IsBlocked eq {false}
  • IsBlocked eq '{false}'
  • IsBlocked eq 'false'
  • IsBlocked eq false
  • IsBlocked eq boolean'{false}'
  • IsBlocked eq bool'{false}'
DiPix
  • 5,755
  • 15
  • 61
  • 108
  • `IsBlocked eq false` should have worked. Can you please edit your question and include how the data looks like in your table? – Gaurav Mantri Oct 21 '21 at 10:24

1 Answers1

0

The problem was in my entire filter I had

$"(Code eq '{code}') and (IsBlocked eq false)"

rather than

$"(Code eq '{code}') and IsBlocked eq false"

I shouldn't put brackets...

DiPix
  • 5,755
  • 15
  • 61
  • 108