Mathematical operators in CBFS Storage query language are represented by addition, subtraction, multiplication and division. Usual relational operators (=, >, <, >=, <=) are supported. There are three logical operations: NOT, AND, OR. A particular operator D was introduced for explicit conversion of String to DateTime.
not, ~, !
Logical negation (NOT)
Addition. If you add a Number to DateTime, the result will be of type DateTime with number of days, increased by the value of Number operand.
Subtraction. If you subtract a Number from DateTime, the result will be of type DateTime with number of days, decreased by the subtrahend.
Subtraction of a DateTime from DateTime results in a Number which contains difference in days. In this case time is not taken into account.
Division. Division by zero rises exception.
Not equal to
Greater than or equal to
Less than or equal to
IS[ NOT] NULL
IS returns True if the value is NULL, and False otherwise. IS NOT acts in the opposite way.
IS[ NOT] TRUE
IS returns True if the value is True, and False otherwise. IS NOT acts in the opposite way.
IS[ NOT] FALSE
IS returns True if the value is False, and False otherwise. IS NOT acts in the opposite way.
This condition allows to incorporate wildcards into string tag search and perform pattern matching. LIKE supports two wildcards: % and _.
% allows to match any string of any length. Example: "From LIKE '% Smith'". This query selects all files received from all people with the second name Smith.
_ allows matching of a single character. Example: "From LIKE 'John Sm_th'". This query selects all files received from all Johns, which second name consists of five characters, begins with 'Sm' and ends with 'th' (Smith, Smyth, Smeth, etc).
Optional ESCAPE parameter can be used to search for values which include wildcard characters % or _. Example: "From LIKE 'John!_Smith' ESCAPE '!'". Here ! is defined as escape character, and the query will select all files received from John_Smith.
A more complicated example of using ESCAPE is the following: "From LIKE 'John!_%' ESCAPE '!'". In this example, all names beginning with John_ will match the query.
Returns the name of the current file
Returns the full name of the current file starting from the root directory "/"
Returns full path to the current file including the final path separator
Returns True if the current file is NOT a directory, and False otherwise
Returns True if the current file is a directory, and False otherwise
Returns True if the current file is a link, and False otherwise
If the current file is a link, returns its target. Otherwise, returns the full name of the file (i.e., the result is the same as if calling the FullName).
Returns time and date when the current file has been created
Returns the time and date when the current file has been accessed last time
Returns the time and date when the current file has been modified last time
Returns the size of the current file. For directories, returns 0 (zero).
Returns file attributes in the form of a number
Returns True if the current file is encrypted, and False otherwise
Returns True if the current file is compressed, and False otherwise. May return True also for directories that contain files, compressed by default.
Intrinsic functions and constants
Converts String to DateTime. Conversion pattern is described in Type Conversion section.
Returns True if Value is NULL
Returns True if Value is not a NULL
Returns the smallest of Value1 and Value2
Returns the biggest of Value1 and Value2
Returns current system date and time
Returns current system date