Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 4

changes.mady.by.user user-3484a

Saved on

compared with

New Version 5

changes.mady.by.user user-3484a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Where, 1 is the organization ID, and 60 is the number of days.

Anchor
disablecalcvalidation
disablecalcvalidation

To disable calculated field validation

Calculated fields are validated before they are saved into the database, in order to determine the data type of their resulting field. However, it is possible to disable this validation for all calculated fields (including those created via Freehand SQL).

Use the following SQL to do so:

Code Block
INSERT INTO Configuration(IpOrg, ConfigTypeCode, ConfigCode, ConfigData) values(<IP_org>, 'SYSTEM', 'VALIDATECALCONSAVE', ‘FALSE’);

Where ConfigData = TRUE enables validation, and ConfigData = FALSE disables it.