Back to top

    ReQL command: default

    Command syntax

    value.default(default_value | function) → any

    sequence.default(default_value | function) → any

    Description

    Provide a default value in case of non-existence errors. The default command evaluates its first argument (the value it’s chained to). If that argument returns nil or a non-existence error is thrown in evaluation, then default returns its second argument. The second argument is usually a default value, but it can be a function that returns a value.

    Example: Retrieve the titles and authors of the table posts. In the case where the author field is missing or nil, we want to retrieve the string Anonymous.

    r.table("posts").map{ |post|
        {
            :title => post[:title],
            :author => post[:author].default("Anonymous")
        }
    }.run(conn)
    

    We can rewrite the previous query with r.branch too.

    r.table("posts").map{ |post|
        r.branch(
            post.has_fields("author"),
            {
                :title => post[:title],
                :author => post[:author]
            },
            {
                :title => post[:title],
                :author => "Anonymous" 
            }
        )
    }.run(conn)
    

    Example: The default command can also be used to filter documents. Retrieve all our users who are not grown-ups or whose age is unknown (i.e., the field age is missing or equals nil).

    r.table("users").filter{ |user|
        (user[:age] < 18).default(true)
    }.run(conn)
    

    One more way to write the previous query is to set the age to be -1 when the field is missing.

    r.table("users").filter{ |user|
        user[:age].default(-1) < 18
    }.run(conn)
    

    This can be accomplished with has_fields rather than default.

    r.table("users").filter{ |user|
        user.has_fields("age").not() | (user[:age] < 18)
    }.run(conn)
    

    The body of every filter is wrapped in an implicit .default(false). You can overwrite the value false with the default option.

    r.table('users').filter(:default => true) {|user|
        (user[:age] < 18)
    }.run(conn)
    

    Example: The function form of default receives the error message as its argument.

    r.table("posts").map{ |post|
        {
            :title => post["title"],
            :author => post["author"].default{ |err| err }
        }
    }.run(conn)
    

    This particular example simply returns the error message, so it isn’t very useful. But it would be possible to change the default value based on the specific error message thrown.

    Get more help

    Couldn't find what you were looking for?