How to sort json data by date and time

by

You could use sort_by/1 on the fields, you’ll have to either normalize the date/time formats or conditionally parse them out using strptime/1. It returns an array of the date fields in significant order combine to a single array and sort_by will do the rest.

.data.monitor
  | sort_by([
    (.Date | strptime("%A %d %B %Y")),
    (.Time | split(" ")[0] | if contains(":") then
      strptime("%I:%M%p")
    else
      strptime("%I%p")
    end)
  ])

jqplay

More Related Contents:

  1. Passing bash variable to jq
  2. How to merge 2 JSON objects from 2 files using jq?
  3. Add new element to existing JSON array with jq
  4. Select objects based on value of variable in object using jq
  5. jq not working on tag name with dashes and numbers
  6. Iterating through JSON array in Shell script
  7. Accessing a JSON object in Bash – associative array / list / another model
  8. passing arguments to jq filter
  9. Modify a key-value in a json using jq in-place
  10. how to parse a JSON String with jq (or other alternatives)?
  11. How to convert a JSON object to key=value format in jq?
  12. Using jq how can I split a very large JSON file into multiple files, each a specific quantity of objects?
  13. How to filter an array of objects based on values in an inner array with jq?
  14. How to check if element exists in array with jq
  15. How to format a JSON string as a table using jq?
  16. Get outputs from jq on a single line
  17. How do I update a single value in a json document using jq?
  18. Exporting JSON to environment variables
  19. How to convert a JSON object stream into an array with jq
  20. Assigning an Array Parsed With jq to Bash Script Array
  21. Convert a JSON array to a bash array of strings
  22. How to use jq when the variable has reserved characters?
  23. How to get key names from JSON using jq
  24. Escape field name in jq that contains ‘@’ and ‘-‘? [duplicate]
  25. How to remove double-quotes in jq output for parsing json files in bash?
  26. Reusable function to group_by but return an object with group as key
  27. using jq to assign multiple output variables
  28. Create JSON using jq from pipe-separated keys and values in bash
  29. Constructing a JSON object from a bash associative array
  30. jq: recursively merge objects and concatenate arrays

Leave a Comment