Select non-null fields

Filter array elements where value is not null

jq '[.[] | select(.value != null)]' data.json
tool
jq17 commands
tags
jq

More jq commands

  • Group by field
    jq 'group_by(.status) | map({status: .[0].status, count: length})' data.json

    Count records grouped by status field

  • Flatten nested array
    jq 'flatten(1)' nested.json

    Flatten one level of nested arrays

  • Convert array to object (index_by)
    jq 'INDEX(.[]; .id)' items.json

    Build an object keyed by the id field

  • Merge two objects
    jq -s '.[0] * .[1]' base.json override.json

    Deep merge two JSON objects (right wins on conflicts)

  • Extract nested value safely
    jq '.config?.database?.host // "localhost"' config.json

    Optional chaining with fallback default value

all 17 jq commands