Operators

JSONLogic operators

For a list of built-in JSONLogic operators see https://jsonlogic.com/operations.html.

PBI Inspector operators

[Documentation in progress]

count

Counts the number of items in an array.

diff

Accepts two JSON array parameters, treats them as non-ordered sets, and returns a JSON array representing the set difference between the first and the second parameter.

drillvar

Accepts a json pointer string and parses stringified JSON on the right of a '>' character.

equalsets

Accepts two JSON array parameters, treats them as non-ordered sets, and determines if they are equal.

intersection

Accepts two JSON array parameters, treat them as non-ordered sets, and returns a JSON array representing the intersection of both sets.

rectoverlap

Accepts a JSON array of rectangle ids, x and y coordinates and width, height and optional margin width. Returns an array of overlapping rectangle ids (inflated by the margin width).

strcontains

Accepts a search string and regular expression as parameters. Returns the count of regular expression matches in the search string.

symdiff

Accepts two JSON array parameters, treat them as non-ordered sets, and returns a JSON array representing the symmetric difference of both sets.

torecord

Accepts an array of key/value pairs as parameter. Return a JSON record.

tostring

Accepts a JSON node as parameter and returns the equivalent stringified JSON.

union

Accepts two JSON array parameters, treat them as non-ordered sets, and returns a JSON array representing the union of both sets.