JSON.ARRTRIM key path start stop
@json,
@write,
@slow,
Trim an array so that it contains only the specified inclusive range of elements
keyis key to modify.
pathis JSONPath to specify. Default is root $.
startis index of the first element to keep (previous elements are trimmed). Default is 0.
stopis the index of the last element to keep (following elements are trimmed), including the last element. Default is 0. Negative values are interpreted as starting from the end.
JSON.ARRTRIM is extremely forgiving, and using it with out-of-range indexes does not produce an error. Note a few differences between how RedisJSON v2.0 and legacy versions handle out-of-range indexes.
Behavior as of RedisJSON v2.0:
start is larger than the array's size or start > stop, returns 0 and an empty array.start is < 0, then start from the end of the array.stop is larger than the end of the array, it is treated like the last element.Create two headphone products with maximum sound levels.
redis> JSON.SET key $
"[{\"name\":\"Healthy headphones\",\"description\":\"Wireless Bluetooth headphones with noise-cancelling technology\",\"connection\":{\"wireless\":true,\"type\":\"Bluetooth\"},\"price\":99.98,\"stock\":25,\"colors\":[\"black\",\"silver\"],\"max_level\":[60,70,80]},{\"name\":\"Noisy headphones\",\"description\":\"Wireless Bluetooth headphones with noise-cancelling technology\",\"connection\":{\"wireless\":true,\"type\":\"Bluetooth\"},\"price\":99.98,\"stock\":25,\"colors\":[\"black\",\"silver\"],\"max_level\":[85,90,100,120]}]"
OKAdd new sound level values to the second product.
redis> JSON.ARRAPPEND key $.[1].max_level 140 160 180 200 220 240 260 280
1) (integer) 12Get the updated array.
redis> JSON.GET key $.[1].max_level
"[[85,90,100,120,140,160,180,200,220,240,260,280]]"Keep only the values between the fifth and the ninth element, inclusive of that last element.
redis> JSON.ARRTRIM key $.[1].max_level 4 8
1) (integer) 5Get the updated array.
redis> JSON.GET key $.[1].max_level
"[[140,160,180,200,220]]"With $-based path argument: Array reply of integer replies or null replies, where each element is the array's new size, or null if the matching value is not an array.
With .-based path argument: Integer reply representing the array's new size, or null reply if the matching value is not an array.
JSON.ARRINDEX | JSON.ARRINSERT