Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Function

Function: IF_NULL

Syntax: IF_NULL(value, fallback_if_null)

Description: Returns the first value or the second value (fallback) if the first one is null. The value and its fallback must have the same type.

Sample usage:

  • IF_NULL(assigned_at, created_at) returns the assigned_at field value or the created_at field value when the former is null.

  • IF_NULL(merged_by_username,”-”) returns the username of the person who merged the pull request or ”-” if the pull request has not been merged.

Did this answer your question?