In List Validator

Specification

{
  "validatorType": String,
  "name": String,
  "description": String,
  "fields": FieldSelectorSpec,
  "validValues": Array[String],
  "isNot": Boolean
}

Structure Values

Field Name

Type

Description

Required

Default

validatorType

String

The type of validator to construct

Required

name

String

The name of the validator. Must be unique within the validation suite.

Required


description

String

Expanded validator information.


None

fields

Object

A Field Selector Spec

Required

validValues

Array[String]

An array of values to pass to the SQL IN statement.

Required

isNot

Boolean

Flag for whether to use not in the where clause

Required

Example

{
  "validatorType": "inList",
  "name": "sample_inList_validator",
  "description": "I can check enumerated values",
  "fields": {
    "fieldSelectorType": "SingleField",
    "fieldName": "col_name"
  },
  "validValues": ["1", "2", "3"],
  "isNot": false
}



Was this article helpful?
0 out of 0 found this helpful