Keywords

The following shows EDL keywords grouped by type:

EDL Keywords	Examples
Operators	() [] + - * / ~ !~ = < <= > >= <> , : AND, OR, NOT, DIV, MOD
Date and Time	January-December, Jan-Dec Monday-Sunday, Business_Day, Weekend AM, PM, Second, S, Seconds, Minute, Minutes, M, Hour, Hours, H, Day, Days, Week, Weeks, Quarter, Year, Years
Sequence	First, Second, Third, Fourth, Fifth, st, nd, rd, th, Last, All, Start, End
Size	B, KB, MB, GB, TB
Miscellaneous	Ucase, Lcase Where, At, After, As, By, Before, From, To, Every, Of, Variable, Union, Intersect, Sorted_by, Hold

Note: The keywords are sorted alphabetically in the EDL editor dialog.

Use the keyword AS to provide user-defined names for output columns in query result tables and aliases (synonyms) in conditional expressions.

Use the keyword BY to provide a basis for aggregation (object or attribute) in defining queries that contain aggregate functions.

Use the keyword SORTED_BY to specify the sort order of query result.

Use the keyword TOP to limit the number of entries in the result table.

For more information, see the online help.