Skip to content

NovaStar Database Reference / Functions / data_notverified


Overview

The data_notverified function checks if the flag E is not in a list of flags (a string).

It is defined in the data_flags.sql file distributed with the NovaStar installer.

Function Usage

The data_notverified function syntax is as follows.

data_notverified(
  IN flags text)

The function returns a boolean - true if E is not in flags.

Function parameters are as follows.

data_select(...) Function Parameters

Parameter         Description Default
flags String containing flags to check - typically the contents of the flags column of a data table.

For the set of flags (or string) M1, the following call would return true:

select * from data_notverified('M1');

Troubleshooting

See Also