This is a quick and dirty sandbox environment for playing with Pipeline Scripts. You can enter your raw script and data on the page and see the output easily once you click the "Run" button at the bottom left. View the source code to see how it works.

Pipeline Script

// Line Comments are supported
/* Block Comments are also supported*/

// Turn all normal numbers into objects with a val property that contains the number
select("$ => {val: $}")

// Output the transformed values
log("selected")
// Using the new .val property on each object sort the records
sort("a, b => b.val - a.val")
log("sorted")

// Get only unique .val records
distinct("$.val")
log("distinct")

// Execute a map/reduce operation to classify everything as even or odd
mapReduce(
  "{key: $.val % 2?'odd':'even', value: [$.val]}",
  "key, curr, next => curr.concat(next)"
)
log("mapReduced")

// rename value key output from reduce to values
select("{key: $.key, values: $.value}")
log("selected")

// Unwind all of the values arrays creating a lot of new records
unwind("values")
log("unwound")

// Add str as a new property
select("{key: $.key, value: $.values, str: \"Some String\"}")
log("selected")

// Convert back from objects to numeric array of numbers
select("$ => $.value")
log("selected")

// Pull 4 or 5 records (middle -2 to middle +2) depending on array size from the middle
mid("Math.max(0, (this.length / 2) - 2)", "Math.min(this.length-1, (this.length / 2) + 2)")
log("mid")

// Only use even numbers
pick("!($ % 2)")
log("Final")

// And convert it over to an array in the end
toArray()

Aggregate.js Pipeline Script example

Pipeline Script

Data

Output