FQL v4 will be decommissioned on June 30, 2025. Ensure that you complete your migration from FQL v4 to FQL v10 by that date.

For more details, review the migration guide. Contact support@fauna.com with any questions.

`IsNull`

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.

IsNull( value )

is_null( value )

IsNull( value )

IsNull( value )

IsNull( value )

Description

The IsNull function returns true only if value is a null, otherwise it returns false.

Parameters

Parameter Type Definition and Requirements

Parameter	Type	Definition and Requirements
`value`	Any	Any value, which is to be tested to determine whether it is a `null` or not.

value

Any

Any value, which is to be tested to determine whether it is a null or not.

Returns

Returns a Boolean, indicating whether value was a null or not.

Examples

The following query uses Map to iterate over an array of all of the types of values that can be tested by a type-check function, passing each item into a Lambda function that returns an object, which contains the value and the result of calling IsNull with that value:

client.query(
  q.Map(
    [
      ['array'],
      true,
      false,
      new Uint8Array([1, 2, 3, 4]),
      [0x1, 0x2, 0x3, 0x4],
      q.Collection('Letters'),
      q.Ref('credentials/self'),
      q.Database('child_db'),
      q.Date('2019-11-12'),
      q.Ref(q.Collection('Letters'), 123),
      10.1,
      q.Function('double'),
      q.Index('letters'),
      10,
      q.Ref(q.Keys(), '1'),
      q.Query(q.Lambda('x', q.Var('x'))),
      null,
      { x: 10 },
      q.Role('employees'),
      q.Match(q.Index('letters')),
      'ten',
      '10',
      q.Time('2020-07-06T12:34:56.789Z'),
      q.Ref(q.Tokens(), '1'),
    ],
    q.Lambda('x', {
      value: q.Var('x'),
      IsNull: q.IsNull(q.Var('x')),
    })
  )
)
.then((ret) => console.log(ret))
.catch((err) => console.error(
  'Error: [%s] %s: %s',
  err.name,
  err.message,
  err.errors()[0].description,
))

[
  { value: [ 'array' ], IsNull: false },
  { value: true, IsNull: false },
  { value: false, IsNull: false },
  { value: Bytes("AQIDBA=="), IsNull: false },
  { value: [ 1, 2, 3, 4 ], IsNull: false },
  { value: Collection("Letters"), IsNull: false },
  { value: Ref(Credentials(), "268432748139512320"), IsNull: false },
  { value: Database("child_db"), IsNull: false },
  { value: Date("2019-11-12"), IsNull: false },
  { value: Ref(Collection("Letters"), "123"), IsNull: false },
  { value: 10.1, IsNull: false },
  { value: Function("double"), IsNull: false },
  { value: Index("letters"), IsNull: false },
  { value: 10, IsNull: false },
  { value: Ref(Keys(), "1"), IsNull: false },
  { value: Query(Lambda("x", Var("x"))), IsNull: false },
  { value: null, IsNull: true },
  { value: { x: 10 }, IsNull: false },
  { value: Role("employees"), IsNull: false },
  { value: Match(Index("letters")), IsNull: false },
  { value: 'ten', IsNull: false },
  { value: '10', IsNull: false },
  { value: Time("2020-06-15T21:24:28.259Z"), IsNull: false },
  { value: Ref(Tokens(), "1"), IsNull: false }
]

result = client.query(
  q.map_(
    q.lambda_("x", {
      "value": q.var("x"),
      "IsNull": q.is_null(q.var("x")),
    }),
    [
      ["array"],
      True,
      False,
      bytearray([1, 2, 3, 4]),
      [0x1, 0x2, 0x3, 0x4],
      q.collection("Letters"),
      q.ref("credentials/self"),
      q.database("child_db"),
      q.date("2019-11-12"),
      q.ref(q.collection("Letters"), 123),
      10.1,
      q.function("double"),
      q.index("letters"),
      10,
      q.ref(q.keys(), "1"),
      q.query(q.lambda_("x", q.var("x"))),
      None,
      {"x": 10},
      q.role("employees"),
      q.match(q.index("letters")),
      "ten",
      "10",
      q.time("2020-07-06T12:34:56.789Z"),
      q.ref(q.tokens(), "1"),
    ],
  )
)
print(result)

[{'value': ['array'], 'IsNull': False}, {'value': True, 'IsNull': False}, {'value': False, 'IsNull': False}, {'value': bytearray(b'\x01\x02\x03\x04'), 'IsNull': False}, {'value': [1, 2, 3, 4], 'IsNull': False}, {'value': Ref(id=Letters, collection=Ref(id=collections)), 'IsNull': False}, {'value': Ref(id=282032258185953792, collection=Ref(id=credentials)), 'IsNull': False}, {'value': Ref(id=child_db, collection=Ref(id=databases)), 'IsNull': False}, {'value': datetime.date(2019, 11, 12), 'IsNull': False}, {'value': Ref(id=123, collection=Ref(id=Letters, collection=Ref(id=collections))), 'IsNull': False}, {'value': 10.1, 'IsNull': False}, {'value': Ref(id=double, collection=Ref(id=functions)), 'IsNull': False}, {'value': Ref(id=letters, collection=Ref(id=indexes)), 'IsNull': False}, {'value': 10, 'IsNull': False}, {'value': Ref(id=1, collection=Ref(id=keys)), 'IsNull': False}, {'value': Query({'api_version': '4', 'lambda': 'x', 'expr': {'var': 'x'}}), 'IsNull': False}, {'value': None, 'IsNull': True}, {'value': {'x': 10}, 'IsNull': False}, {'value': Ref(id=employees, collection=Ref(id=roles)), 'IsNull': False}, {'value': SetRef({'match': Ref(id=letters, collection=Ref(id=indexes))}), 'IsNull': False}, {'value': 'ten', 'IsNull': False}, {'value': '10', 'IsNull': False}, {'value': FaunaTime('2020-07-06T12:34:56.789Z'), 'IsNull': False}, {'value': Ref(id=1, collection=Ref(id=tokens)), 'IsNull': False}]

result, err := client.Query(
	f.Map(
		f.Arr{
			f.Arr{"array"},
			true,
			false,
			f.BytesV{0x01, 0x02, 0x03, 0x04},
			f.Arr{0x1, 0x2, 0x3, 0x4},
			f.Collection("Letters"),
			f.Ref("credentials/self"),
			f.Database("child_db"),
			f.Date("2019-11-12"),
			f.Ref(f.Collection("Letters"), 123),
			10.1,
			f.Function("double"),
			f.Index("letters"),
			10,
			f.Ref(f.Keys(), "1"),
			f.Query(f.Lambda("x", f.Var("x"))),
			nil,
			f.Null(),
			f.Obj{"x": 10},
			f.Role("employees"),
			f.Match(f.Index("letters")),
			"ten",
			"10",
			f.Time("2020-07-06T12:34:56.789Z"),
			f.Ref(f.Tokens(), "1"),
		},
		f.Lambda("x", f.Obj{
			"value": f.Var("x"),
			"IsNull": f.IsNull(f.Var("x")),
		})))

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}

[map[IsNull:false value:[array]] map[IsNull:false value:true] map[IsNull:false value:false] map[IsNull:false value:[1 2 3 4]] map[IsNull:false value:[1 2 3 4]] map[IsNull:false value:{Letters 0xc0001621e0 0xc0001621e0 <nil>}] map[IsNull:false value:{280481857410171392 0xc000162300 0xc000162300 <nil>}] map[IsNull:false value:{child_db 0xc000162420 0xc000162420 <nil>}] map[IsNull:false value:{0 63709113600 <nil>}] map[IsNull:false value:{123 0xc0000902d0 0xc0000902d0 <nil>}] map[IsNull:false value:10.1] map[IsNull:false value:{double 0xc000090420 0xc000090420 <nil>}] map[IsNull:false value:{letters 0xc000090540 0xc000090540 <nil>}] map[IsNull:false value:10] map[IsNull:false value:{1 0xc000090690 0xc000090690 <nil>}] map[IsNull:false value:{[123 34 97 112 105 95 118 101 114 115 105 111 110 34 58 34 51 34 44 34 108 97 109 98 100 97 34 58 34 120 34 44 34 101 120 112 114 34 58 123 34 118 97 114 34 58 34 120 34 125 125]}] map[IsNull:true value:{}] map[IsNull:true value:{}] map[IsNull:false value:map[x:10]] map[IsNull:false value:{employees 0xc0000908a0 0xc0000908a0 <nil>}] map[IsNull:false value:{map[match:{letters 0xc0000909f0 0xc0000909f0 <nil>}]}] map[IsNull:false value:ten] map[IsNull:false value:10] map[IsNull:false value:{789000000 63729635696 <nil>}] map[IsNull:false value:{1 0xc000090ba0 0xc000090ba0 <nil>}]]

try
{
    Value result = await client.Query(
        Map(
            Arr(
                Arr("array"),
                true,
                false,
                BytesV.Of(0x1, 0x2, 0x3, 0x4),
                Arr(0x1, 0x2, 0x3, 0x4),
                Collection("Letters"),
                Ref("credentials/self"),
                Database("child_db"),
                Date("2019-11-12"),
                Ref(Collection("Letters"), 123),
                10.1,
                Function("double"),
                Index("letters"),
                10,
                Ref(Keys(), "1"),
                Query(Lambda("x", Var("x"))),
                null,
                Obj("x", 10),
                Role("employees"),
                Match(Index("letters")),
                "ten",
                "10",
                Time("2020-07-06T12:34:56.789Z"),
                Ref(Tokens(), "1")
            ),
            Lambda(
                "x",
                Obj(
                    "value", Var("x"),
                    "IsNull", IsNull(Var("x"))
                )
            )
        )
    );

    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}

Arr(ObjectV(value: Arr(StringV(array)),IsNull: BooleanV(False)), ObjectV(value: BooleanV(True),IsNull: BooleanV(False)), ObjectV(value: BooleanV(False),IsNull: BooleanV(False)), ObjectV(value: BytesV(0x01, 0x02, 0x03, 0x04),IsNull: BooleanV(False)), ObjectV(value: Arr(LongV(1), LongV(2), LongV(3), LongV(4)),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "Letters", collection = RefV(id = "collections")),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "295432763050295808", collection = RefV(id = "credentials")),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "child_db", collection = RefV(id = "databases")),IsNull: BooleanV(False)), ObjectV(value: FaunaDate(2019-11-12 12:00:00 AM),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "123", collection = RefV(id = "Letters", collection = RefV(id = "collections"))),IsNull: BooleanV(False)), ObjectV(value: DoubleV(10.1),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "double", collection = RefV(id = "functions")),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "letters", collection = RefV(id = "indexes")),IsNull: BooleanV(False)), ObjectV(value: LongV(10),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "1", collection = RefV(id = "keys")),IsNull: BooleanV(False)), ObjectV(value: QueryV(System.Collections.Generic.Dictionary`2[System.String,FaunaDB.Query.Expr]),IsNull: BooleanV(False)), ObjectV(value: NullV,IsNull: BooleanV(True)), ObjectV(value: ObjectV(x: LongV(10)),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "employees", collection = RefV(id = "roles")),IsNull: BooleanV(False)), ObjectV(value: SetRefV(System.Collections.Generic.Dictionary`2[System.String,FaunaDB.Types.Value]),IsNull: BooleanV(False)), ObjectV(value: StringV(ten),IsNull: BooleanV(False)), ObjectV(value: StringV(10),IsNull: BooleanV(False)), ObjectV(value: FaunaTime(2020-07-06T12:34:56.789Z),IsNull: BooleanV(False)), ObjectV(value: RefV(id = "1", collection = RefV(id = "tokens")),IsNull: BooleanV(False)))

Map(
  [
    ['array'],
    true,
    false,
    new Uint8Array([1, 2, 3, 4]),
    [0x1, 0x2, 0x3, 0x4],
    Collection('Letters'),
    Ref('credentials/self'),
    Database('child_db'),
    Date('2019-11-12'),
    Ref(Collection('Letters'), 123),
    10.1,
    Function('double'),
    Index('letters'),
    10,
    Ref(Keys(), '1'),
    Query(Lambda('x', Var('x'))),
    null,
    { x: 10 },
    Role('employees'),
    Match(Index('letters')),
    'ten',
    '10',
    Time('2020-07-06T12:34:56.789Z'),
    Ref(Tokens(), '1'),
  ],
  Lambda('x', {
    value: Var('x'),
    IsNull: IsNull(Var('x')),
  })
)

[
  { value: [ 'array' ], IsNull: false },
  { value: true, IsNull: false },
  { value: false, IsNull: false },
  { value: { '0': 1, '1': 2, '2': 3, '3': 4 }, IsNull: false },
  { value: [ 1, 2, 3, 4 ], IsNull: false },
  { value: Collection("Letters"), IsNull: false },
  { value: Ref(Credentials(), "302043979982045696"), IsNull: false },
  { value: Database("child_db"), IsNull: false },
  { value: Date("2019-11-12"), IsNull: false },
  { value: Ref(Collection("Letters"), "123"), IsNull: false },
  { value: 10.1, IsNull: false },
  { value: Function("double"), IsNull: false },
  { value: Index("letters"), IsNull: false },
  { value: 10, IsNull: false },
  { value: Ref(Keys(), "1"), IsNull: false },
  { value: Query(Lambda("x", Var("x"))), IsNull: false },
  { value: null, IsNull: true },
  { value: { x: 10 }, IsNull: false },
  { value: Role("employees"), IsNull: false },
  { value: Match(Index("letters")), IsNull: false },
  { value: 'ten', IsNull: false },
  { value: '10', IsNull: false },
  { value: Time("2020-07-06T12:34:56.789Z"), IsNull: false },
  { value: Ref(Tokens(), "1"), IsNull: false }
]

Query metrics:

bytesIn: 596
bytesOut: 1,535
computeOps: 2
readOps: 0
writeOps: 0
readBytes: 373
writeBytes: 0
queryTime: 20ms
retries: 0

This query operates on a pre-existing schema, which is not provided here.

Also, the query is executed via a client connection, that uses a secret acquired by calling the Login function (not shown here), so that Ref("credentials/self") returns a valid value.

Is this article helpful?

Tell Fauna how the article can be improved:
Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!

IsNull

Description

Parameters

Returns

Examples

Related functions

Keyboard shortcuts

While reading

While searching

URL fragments

`IsNull`