• Created by user-cd56b, last updated on May 07, 2022 1 minute read

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

This must be specified if the Select/Omit Type is Range.

Range From

Mandatory.

Specify the lower value that the select/omit column should be compared to.

Rules

Allowable values are:

  • Character literal in quotes (e.g. 'BALMAIN').
  • Numeric literal (e.g.  1.54).
  • DateTime literal in quotes. (e.g. '2005-05-01 10:00:00') DateTime literals need to be entered as per the SUTC attribute of the field. If the SUTC attribute is enabled, enter the value as UTC, otherwise enter the value in local time.
  • Name of another column in the table definition.

S/O Range To

Mandatory.

Rules

Allowable values are:

  • Character literal in quotes (e.g. 'BALMAIN').
  • Numeric literal (e.g.  1.54).
  • DateTime literal in quotes. (e.g. '2005-05-01 10:00:00') DateTime literals need to be entered as per the SUTC attribute of the field. If the SUTC attribute is enabled, enter the value as UTC., otherwise enter the value in local time.
  • Name of another column in the table definition.


  • No labels