Find matching records

Use where when you only want records that match a condition.

Source JSON

orders.json:

[
  {"id": 101, "status": "paid", "total": 80},
  {"id": 102, "status": "draft", "total": 25},
  {"id": 103, "status": "paid", "total": 120}
]

Query

jql "select {id, total} from 'orders.json' where status = 'paid'"

Result

[
  {"id": 101, "total": 80},
  {"id": 103, "total": 120}
]

The query reads almost like a sentence: select two fields from the file where the status is paid.