Operators

JSONLogic operators

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

PBI Inspector operators

PBI Inspector adds additional operators beyond those provided by the JSONLogic library.

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.