MarkLogic 12 Product Documentation

ordt.redactDatetime

ordt.redactDatetime(
   column as String,
   options as object?
) as columnBinding

Summary

This function redacts a column with date or datetime values either by masking part of the existing value or by generating a random value. This function can be used with op.bind or op.select .

Usage Notes

The options consist of the following properties:

• level: either parsed (the default) or random; the parsed level formats the existing datetime value (which may be parsed from a string); the random level generates a random datetime value.
• format: a picture string describing how to format the redacted value; required for the parsed level; allowed for the random level; specify the picture as with the fn.formatDateTime function.
• picture: a picture string describing how to parse the date or dateTime value from a string; allowed for the parsed level; ignored for the random level; specify the picture as with the xdmp.parseDateTime function.
• range: a comma-separated pair of years to bound generated values; ignored for the parsed level; allowed for the random level (defaulting to 1582 and the current year).

Example

const op   = require('/MarkLogic/optic');
const ordt = require('/MarkLogic/optic/optic-redaction.sjs');

op.fromView('main', 'expenses')
  .bind([
     ordt.redactDatetime(op.schemaCol('main', 'expenses', 'expenseDate'), {level:'parsed', format:'[M01]/[D01]/xx'})
     ])
  .result();

  

Example

const op   = require('/MarkLogic/optic');
const ordt = require('/MarkLogic/optic/optic-redaction.sjs');

op.fromView('main', 'expenses')
  .select([
     ordt.redactDatetime(op.schemaCol('main', 'expenses', 'expenseDate'), {level:'parsed', format:'[M01]/[D01]/xx'})
     ])
  .result();