ordt:mask-random( $column as item(), $options as map:map? ) as map:map
This function redacts a column with string values by replacing each value with random masking text. The same value may produce a different masked value every time the value is redacted. You can control characteristics such as the character set for the masked value. This function can be used with op:bind or op:select.
Parameters | |
---|---|
$column | The name of the column to be redacted. This can be either a string or the return value from op:col, op:view-col, or op:schema-col. |
$options | The options for masking the value the column. |
The options consist of the following properties:
any
(the default),
mixedCase
, mixedCaseNumeric
,
lowerCase
, lowerCaseNumeric
,
upperCase
, upperCaseNumeric
,
or numeric
.xquery version "1.0-ml"; import module namespace op="http://marklogic.com/optic" at "/MarkLogic/optic.xqy"; import module namespace ordt="http://marklogic.com/optic/redaction" at "/MarkLogic/optic/optic-redaction.xqy"; op:from-view("main", "employees") => op:bind(( ordt:mask-random(op:schema-col("main", "employees", "FirstName"), map:entry("character","mixedCase")), ordt:mask-random(op:schema-col("main", "employees", "LastName"), map:entry("character","mixedCase")) )) => op:result()
xquery version "1.0-ml"; import module namespace op="http://marklogic.com/optic" at "/MarkLogic/optic.xqy"; import module namespace ordt="http://marklogic.com/optic/redaction" at "/MarkLogic/optic/optic-redaction.xqy"; op:from-view("main", "employees") => op:select(( ordt:mask-random(op:schema-col("main", "employees", "FirstName"), map:entry("character","mixedCase")), ordt:mask-random(op:schema-col("main", "employees", "LastName"), map:entry("character","mixedCase")) )) => op:result()
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.