It is possible to process the data from a {tag} before it is used by PAD to construct the output.
This is done by using one of the below options.
dedup, end, first, group, last, page, random, reverse, row, rows, shuffle, slice, sort, splice, start, trim, where
The options run in the order they are written. where keeps the rows a quoted expression holds for, evaluated per row with the row's fields; when the options leave no row at all, the tag shows its @else@ branch. group folds the rows into one occurrence per value of a field, with subtotals - see grouping with subtotals.
|
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 20 |
| 11 12 13 14 15 16 17 18 19 20 |
| 21 22 23 24 25 26 27 28 29 30 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
| 20 21 22 23 24 25 26 27 28 29 30 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
| 21 22 23 24 25 26 27 28 29 30 |
| 21 22 23 24 25 26 27 28 29 30 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 30 31 32 33 34 |
| 16 17 18 19 20 |
| 21 22 23 24 25 |
| 26 27 28 29 30 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 |
| 11 12 13 14 15 16 17 18 19 20 |
| 40 |
| 31 32 33 34 35 36 37 38 39 40 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
| 21 22 23 24 25 26 27 28 29 30 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
| 21 22 23 24 25 26 27 28 29 30 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
| 21 22 23 24 25 |
| 11 12 13 14 15 16 17 18 19 20 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
| 11 12 13 14 15 16 17 18 19 20 36 37 38 39 40 |
| 21 22 23 24 25 |
| 11 12 13 14 15 16 17 18 19 20 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
| 11 12 13 14 15 16 17 18 19 20 36 37 38 39 40 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 |
| 28 26 24 14 38 30 16 11 18 15 20 35 29 13 23 21 25 40 31 34 19 39 32 36 27 37 22 33 17 12 |
| 27 29 19 13 36 17 28 25 34 40 16 18 39 12 33 24 15 26 31 35 37 38 21 20 32 22 23 30 14 11 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 25 29 35 14 12 17 37 30 39 22 24 19 36 16 21 11 18 34 32 33 |
| 11 13 14 15 16 18 21 22 25 26 27 28 29 30 32 33 34 35 38 40 |
| 37 36 23 23 23 25 17 25 23 19 12 17 38 16 26 27 14 15 16 19 |
| 14 14 15 19 22 22 23 25 25 25 26 28 29 33 35 35 36 37 39 40 |
With the 'negative' option, the result is the negative of the handling option.
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 |
| 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
| 31 32 33 34 35 36 37 38 39 40 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 |
| 11 12 13 14 15 16 17 18 19 20 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
| 11 12 13 14 15 16 17 18 19 20 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 |
| 11 12 13 14 15 16 17 18 19 20 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 |
| HTML | RESULT |
|---|---|
| 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
| 11 12 13 14 15 16 17 18 19 20 36 37 38 39 40 |
| 11 12 13 14 15 16 17 18 19 20 36 37 38 39 40 |
| 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
| HTML | RESULT |
|---|---|
| 36 37 38 39 40 |
| 21 22 23 |
| 21 22 23 |
| 11 12 13 14 15 16 17 18 19 20 |