Media Center expression language-NEW: Difference between revisions

From wiki.jriver.com
Jump to navigation Jump to search
No edit summary
No edit summary
 
(29 intermediate revisions by the same user not shown)
Line 1: Line 1:
this page can be deleted now.
==Overview==

The J. River Media Core database engine supports Excel-style functions for use in view schemes, searches, displayed columns, and tag editing.

An expression is a mixture of text, fields, and functions. A function allows special operations to be performed. Functions are all listed with a name followed by an opening and closing parenthesis. When building expressions, the instructions you wish to pass to the function are placed inside these parenthesis, with multiple instructions separated by commas. When your expression is evaluated, any spaces entered after a comma are ignored. This allows you to compose complex expressions on multiple lines, making it easier to keep track of where you are in your expression. Occasionally, you will find that you want a space, or parenthesis character to be treated literally as part of your instructions, rather than expression syntax, and in these cases, the character is "escaped" by using a preceding forward slash.
As you progress with your expression building, you will begin nesting multiple functions into a single expression; always remember that a completed expression must contain a matching number of opening and closing parenthesis in order to work reliably.

The functions available to us range from highly functional, with a broad range of applicable uses, through specialised, limited use functions that only appeal to a select group of users, to seemingly redundant functions and obscure functions that MEDIA CENTER uses internally. The functions below are listed with those with the broadest appeal at the top, and the more obscure at the bottom.

Expressions can be used in many places within MEDIA CENTER, for varying reasons. Places that you might consider using expressions include:

* The player information bar
* The image playback caption
* A view scheme search list
* The "Rename, Move or Copy Files" tool
* The tag window
* Panes (''aka categories'')
* List columns
* Thumbnail text
* The search field
* The library field manager (''Create expression based library fields'')
* Theatre View
* The links manager (''Use expressions to format the URLs for your links'')

<ins>'''Any given expression can only work on any given single file. It is not possible to compare a field in one file with a field in another file.'''</ins>

====Fields====

Any text between brackets [] will be replaced with the corresponding field from your library. As an example, [Artist] would be replaced by Bob Dylan for any Bob Dylan tracks. If the text between brackets doesn't match any known fields, it will be left alone. After the field name, a comma can be placed followed by a 0 or 1 for whether the field should get formatted. So, [Duration] and [Duration, 1] will give "4:02" while [Duration, 0] will give "242". This is particularly important when working with the "Format" functions, where most times you will want the evaluator to work with the raw field contents rather than the formatted contents you see in the file list.

Function and field values in expressions are ''not'' case-sensitive.
Available functions with descriptions and examples are listed below.

====Using this page====
The 'Contents' box above contains a list of available functions roughly grouped by usage scenario, and each function name gives a fair indication of what it might do. Each of the group headers contain some basic information pertinent to the functions inside the group. Click on a function or function group header in the Contents box to be taken directly to more information about it on the page. At the bottom right of each section there is a "Back to top" link which will take you back up to the Contents box allowing you to quickly get to where on the page you would like to go next.

==Functions==

===If(...): Ask closed questions and control output dependent upon result.===

{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | If()
|style="border: 1px solid black" | This will be the function you will likely use more than any other. It is typically used in conjunction with one or more other functions and allows you to give specific instructions depending upon whether the result is positive (1) or negative (0). The positive instruction is always given first. ||style="border: 1px solid black" | '''if(''expression to test'',instructions if positive,''instructions if negative'')''' ||style="border: 1px solid black" | '''if(isequal([artist],bob dylan,1),Genius,Mediocre)'''
''Wherever this expression is applied, be it as an expression column or category, as part of a renaming rule, thumbnail text, if the artist tag is Bob Dylan, MEDIA CENTER will produce Genius, and for all other artists, it will produce Mediocre.'' The "IsEqual()" function is described in the first table below.

'''if(isequal([artist],bob dylan,1),Genius,if(isequal([album],Joshua Tree,8),Great Album,Mediocre))'''

''Here, we have two nested "If" functions. First we ask if the artist is Bob Dylan, if the result is positive, write "Genius". If the artist is not Dylan, we then ask if the album is "Joshua Tree", if yes, write "Great Album", and if no, write mediocre''
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
On it's own, "If()" is rather boring and not a lot of use. When used in conjunction with other functions, however, it becomes very powerful indeed. In the two examples above, the numbers 1 and 8 have been used. These are comparison mode switches used by the IsEqual function. There are 9 different compare modes in total, all of which are detailed below. Note how the second example ends with two closing parenthesis, one for each "If" function.

===Query, Test and Compare using "Is" Functions===

All of the functions in this section, when used on their own, will only ever return one of two values, 1 (true) or 0 (false). There is a "FormatBoolean()" function that can be wrapped around these and allows us to specify the output for each case and is discussed in more depth in the Format section. The real power and versatility of these "Is" functions is released when they are wrapped inside the If() function discussed above.

====IsEqual: Compares two values in one of nine specified modes====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsEqual()
|style="border: 1px solid black" | Compares two values in one of nine specified modes ("exact match", "Is greater than" etc.) and outputs 1 for a positive match and 0 for a negative match. If no compare mode is specified, the compare will default to 0. ||style="border: 1px solid black" | '''isequal(''1st value to compare'',2nd value to compare'',compare mode)'''

''Available Compare Modes:''
* 0: ''case-sensitive string compare for equality''
* 1: ''case-insensitive string compare for equality''
* 2: ''numeric compare for equality''
* 3: ''numeric less than''
* 4: ''numeric less than or equal to''
* 5: ''numeric greater than''
* 6: ''numeric greater than or equal to''
* 7: ''substring search (case sensitive)''
* 8: ''substring search (case insensitive)''
|style="border: 1px solid black" | '''isequal([artist],[album],1)'''
''If the 'artist' and 'album' values are the same, the output will be 1, otherwise, the output will be 0.''

'''if(isequal([artist],[album],1),Self Titled,[album])'''

''Wrapped inside an 'If' function, if the 'artist' and 'album' values are the same, the output will be 'Self Titled', otherwise, the output will be the 'album' value.''

'''if(isequal([artist],[album],1),Self Titled/,,[album]/))'''

''This example demonstrates the character 'escaping' mentioned in the overview. Here, we want the output to be either "Self Titled," (note the inclusion of the comma) or the album value with a closing parenthesis. In order to achieve this, the comma, and the closing parenthesis, are escaped using a preceding forward-slash character. This informs the expression evaluator that these characters are not part of the expression syntax and are to be treated literally''
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====IsEmpty: Tests to see if a field is empty====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsEmpty()
|style="border: 1px solid black" | Tests any given field for data. If the field is empty, the function returns 1, and if populated, the function returns 0. There are two different test modes available, a "string" test, and a "number" test. This is because as far as MEDIA CENTER is concerned, fields designated as containing numerical values that are populated with the number zero, are empty. If no test mode is specified, the function will default to 0.
Pay particular attention to the third example offered on the right, as it covers a caveat that comes with this particular function.
|style="border: 1px solid black" | '''isempty([field to test],test mode)'''
''Available test modes:''
* 0: ''String test (field must be empty to get a positive result)''
* 1: ''Numerical test (field must be empty, or contain 0 to get a positive result)''
|style="border: 1px solid black" | '''isempty([comment],0)'''
''If the comment field is empty, this expression will return 1, but if the comment field contains data, the expression will return 0.''

'''isempty([track #],1)'''

''This expression will perform a numerical test for data in the [track #] field. If the field is empty, or contains 0, the expression will return a positive result, 1, otherwise, the result will be negative, 0.''

'''if(isempty([disc #]),,[disc #])'''

''Here, by not entering any instructions to carry out for a positive result, the expression will do just that, and output nothing, but if the [disc #] field does contain data, the expression will write that out. Upon first look, you would think that this could work really well in the "Rename, Move and Copy Files" tool for only creating a \Disc #\ directory if needed. This will not work. When asking the rename tool to create directories from field data, it is smart enough to know that directories with no name are illegal in Windows, so when it encounters an empty field, it automatically converts it to "Unknown&nbsp;[Field&nbsp;Name]". It does this before the expression engine gets to see it, which means that the IsEmpty function will always return a negative result when used in the rename tool, even when the specified field is indeed empty. As we now know that empty fields are passed through the rename tool as "Unknown&nbsp;[field&nbsp;name]" we can use '''if(isequal([disc&nbsp;#],unknown,8),,[disc&nbsp;#])''' to achieve the desired result. Note that this only applies when using the rename files tool.''
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====IsRange: Tests a value for inclusion within a given range====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsRange()
|style="border: 1px solid black" | IsRange allows us to test if any given field falls inside any given range of values. If the field falls inside the given range, the function returns 1, and if outside the given range, the function returns 0. ||style="border: 1px solid black" | '''IsRange([Field to Test],Specified-Range)'''
''The range to test for can be letters or numbers, separated by a hyphen, without spaces, lowest value first, highest second. Letters and numbers cannot be mixed, the range can only be one or the other''
* ''1-100''
* ''a-z''
* ''c-d''
* ''23-7542''
|style="border: 1px solid black" | '''isrange([artist],a-c)'''
''Abba or Blondie will return 1 (positive), and ZZ Top will return 0 (negative).''

'''if(isrange([bitrate],96-191),Poor Quality,High Quality)'''

''This expression will output "Poor Quality" for any file where the bitrate fall between falls between 96 and 191, and "High Quality" for all others. Note that expressions are only as good as the instructions given, and that the above expression would label files with bitrates less than 96kbps as "High Quality". If this expression were used to add a category to a view, there would be two selectable choices in the category, Low Quality, and High Quality. Selecting either one would then filter the file list accordingly.''

'''[http://yabb.jriver.com/interact/index.php?topic=38566.msg262229#msg262229 This post]''' ''on Interact shows the use of IsRange in a Search List. (right click the link, open in new tab to keep this page open). The expression format in that post shows how to form expressions for use in standard MEDIA CENTER searches, something that is also covered later'' [[#When, Where and How to use expressions|on this page.]]
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====IsMissing: Tests to see if a file exists on the system====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsMissing()
|style="border: 1px solid black" | This function checks to see if a file exists on the system. If the file is missing, the function returns 1 (positive), and if the file is found, the function returns 0 (negative). It is possible to specify a specific file to check for, but if you know that much, it will be quicker to fire up explorer and check yourself. This function comes in handy for checking the integrity of your MEDIA CENTER library as you can use it to produce a list of any files in your library that MEDIA CENTER cannot find. However, be aware that the larger your library, the longer this list will take to produce as MEDIA CENTER will need to physically check each files' existance in turn. ||style="border: 1px solid black" | '''IsMissing(Full Path To File)'''
''If no file path is specified, the function will default to checking the current file.''
|style="border: 1px solid black" | '''ismissing()'''
''Checks if the current file exists, and returns 1 (positive) if the file does not exist, and 0 (negative) if the file does exist.''

'''ismissing(C:\Music\My Lost File.mp3)'''

''Checks for "My Lost File.mp3" and returns 1 (positive) if the file does not exist, and 0 (negative) if the file does exist.''

'''[=ismissing([filename])]=1'''

''This example also demonstrates how to construct an expression for use as a MEDIA CENTER search string. If you place this in the search field in the top right corner of the program while viewing all of your library, it will filter the list, leaving only the missing files on view. If your library is in good order, this list should be empty. You could also create a view scheme and use this string in the "Set rules for file display" search to give you a view that you can visit periodically to check that your library is intact

'''if(ismissing(),File is missing,File exists)'''

''Wrapped inside an "If()" function, the expression outputs "File is missing" or "File Exists" depending on the result returned by IsMissing()''

|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====IsRemovable: Tests to see if a file is stored on removable media====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsRemovable()
|style="border: 1px solid black" | Checks to see if a file resides on removable media and if so, returns 1 (positive), and if not, returns 0 (negative). There is not a lot to say about this function, especially since MEDIA CENTER comes equipped with a [Removable] field by default that is automatically populated with 1 for all files in the library that are on removable storage. The function works in exactly the same way as the IsMissing function described above, returning 1 (positive) if the file is on removable storage, and 0 (negative) if not. ||style="border: 1px solid black" | '''IsRemovable(Full Path To File)'''

''If no file path is specified, the function will default to checking the current file.''
|style="border: 1px solid black" | '''isremovable()'''

''Checks if the current file is on removable storage, and if so, returns 1 (positive), if not, the function returns 0 (negative).''
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====IsInPlayingNow & IsPlaying: Tests to see if a file is in the Playing Now playlist or currently being played====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsInPlayingNow()
|rowspan="2" style="border: 1px solid black" | These two functions will be dealt with together as from their names, they are self-explanatory. One checks to see if a file has been added to the playing now list, and the other checks if a file in a list is currently playing or not. With this in mind, their most practical use is as expression columns in a file list. To add an expression column to a list, right click on any existing column header and click on the "Add expression column" option. ||rowspan="2" style="border: 1px solid black" | '''IsInPlayingNow()'''

''Checks the current file, and if in the Playing Now list, returns 1 (positive), and if not, returns 0 (negative).

'''IsPlaying()'''

''Checks the current file, and if currently playing, returns 1 (positive), and if not, returns 0 (negative).
|rowspan="2" style="border: 1px solid black" | '''if(isinplayingnow(),Selected,Not Selected)'''

''As mentioned in the description, the ideal place for these functions is as 'expression columns'. If this example were used in an expression column, then files added to Playing Now will show as "Selected" and all other files would show as "Not Selected". If the idea here is to be able to quickly see which files have been added, this might look a bit 'busy' and defeat the purpose, to which end, it is perfectly acceptable to tell the expression that if a file is not in Playing Now, to output nothing, by simply not giving any instructions for the negative result, like so: '''if(isinplayingnow(),Selected,)'''. Now, this expression column will only show "Selected" against files that are in Playing Now, leaving all others empty, giving a much easier column to read.

Use'' IsPlaying ''in exactly the same way as IsInPlayingNow()''

''On the Interact support forum,'' '''[http://yabb.jriver.com/interact/index.php?topic=57461.0 mark_h describes how he puts these two functions to work for him]''', ''and rick.ca shows how he tweaked the idea when he answers the question:'' '''"[http://yabb.jriver.com/interact/index.php?topic=58137.msg393905#msg393905 is it possible to play an artist's full work when a genre is shuffling?]"'''
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | IsPlaying()
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
<br><br>
===Change how existing data is displayed using Format functions===

All of these functions (with the exception of FormatBoolean) take raw data from the library and allow us to present that data in a way that we choose. What does "raw data" mean? MEDIA CENTER stores duration information in seconds and converts that information into hours (if needed), minutes and seconds for display in the Duration column in a file list. Likewise, file size information is stored in bytes and is converted into Mb for display in the file list. Dates are stored using a UNIX system (use google if you want to know more about that) which means that the date field could contain 40121.8272916666683159 and MEDIA CENTER will display that as 04/11/2009 19:51 (if that is how your Windows locale setting displays date and time). So there you have it, raw data. The following section gives some idea of what is possible using the raw data and the Format functions. '''''To&nbsp;instruct the expression evaluator to use raw data, a zero is added to the library field, inside the square brackets, like so: [Date Imported,0]'''''
====FormatDate: Formats a date value in a specified manner====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | FormatDate()
|style="border: 1px solid black" | As mentioned in the section introduction above, MEDIA CENTER stores date information in a UNIX style, and converts that information into legible date/time information we can understand. By default, MEDIA CENTER presents dates using the system locale settings. This function can be applied to any default library field that contains date information in order to have that information displayed in a non-default format. ||style="border: 1px solid black" | '''formatdate([date field,0],Format,Output if date is empty)'''

''Available format choices:''

* Year ''Returns the full year, i.e. 2010''
* Month ''Returns the full month, i.e. April, November.''
* Day ''Returns the day in number format, i.e. 23 (note that single numbers have no leading zero)''
* Filename ''Returns a filename friendly date format that also includes the seconds&nbsp;information to help avoid file names clashing, i.e. 20040521-032221''
* Elapsed ''Returns "how long ago" information, i.e. 2.43 Days or 1.85 Years''
* DateTime ''Returns the date and time using the system format on the machine running the expression.''
* hour ''Returns the hour from dates with time information. (note that single numbers have no leading zero)''
* minute ''Returns minutes from dates with time information. (note that single numbers have no leading zero)''

''Flexible formatting is also available: ('''Note that these <ins>are case sensitive</ins>)'''''

* yy ''Returns the last two digits of the year''
* yyyy ''Returns the full year''
* MM ''Returns the month as two digits''
* MMM ''Returns the month as three letter abbreviations''
* MMMM ''Returns the month in full''
* dd ''Returns the day as two digits''
* ddd ''Returns the day as three letter abbreviations''
* dddd ''Returns the full day''

Output if date is empty: ''If the date is empty, anything placed here will be output instead. This could be plain text, such as "No Date", or a library field. This value is optional, and if not given, the expression will default to return nothing if the date is empty.''

|style="border: 1px solid black" | '''formatdate([last played,0],yyyy//MM//dd,Not Yet)'''
''This will return the last played date as year/month/day without the time, and regardless of the system locale setting. If a file has no last played info, the expression will output "Not&nbsp;Yet" instead.''

'''formatdate([date imported,0],month)'''

''This will return the month a file was imported, written in full. For example, December, as opposed to 12.

'''formatdate([date imported,0],month)&datatype=[month]'''

''If you were to use the previous expression to create a view category that contained the months your files were imported, it would list the months alphabetically, with April first and September last. Thankfully, we can specify "data types" for expressions which further fine tune how MEDIA CENTER displays the results. In this case, a data type of month has been specified, therefore MEDIA CENTER will list the months in the correct chronological order. Data types are discussed [[#Specify data types for expression based fields|further down this page]].

|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====FormatNumber: Formats a number in a specified manner====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | FormatNumber()
|style="border: 1px solid black" | '''FormatNumber()''' allows to format any given value to a set number of decimal places. ||style="border: 1px solid black" | '''FormatNumber(Value to format,number of decimal places)

''The "Value to format" could be a library field, such as [replay gain] or the result of a [[#Math()|Math()]] expression. Any numerical value you encounter where you would like to limit the number of decimal places displayed can have this function applied.''

''If the "Number of decimal places" value is not specified, the function will default to using zero, and if you would like the function to return as many decimal places as necessary, use -1 for the number of decimal places''
|style="border: 1px solid black" | '''formatnumber([duration,0],2)'''
''This will return the duration of a track, in seconds, shown to two decimal places.''
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====PadNumber: Used to add leading zeros to a number====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | PadNumber()
|style="border: 1px solid black" | A ||style="border: 1px solid black" | B ||style="border: 1px solid black" | C
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====FormatDuration: Presents a duration of seconds in a reader friendly format====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | FormatDuration()
|style="border: 1px solid black" | A ||style="border: 1px solid black" | B ||style="border: 1px solid black" | C
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====FormatFileSize: Presents a number of bytes in a reader friendly format====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | FormatFilesize()
|style="border: 1px solid black" | A ||style="border: 1px solid black" | B ||style="border: 1px solid black" | C
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====FormatRange: Formats a value as a range====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | FormatRange()
|style="border: 1px solid black" | A ||style="border: 1px solid black" | B ||style="border: 1px solid black" | C
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
====FormatBoolean: Formats a boolean (true / false) value in a specified manner====
{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="3"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | FormatBoolean()
|style="border: 1px solid black" | A ||style="border: 1px solid black" | B ||style="border: 1px solid black" | C
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
===Now(): Retrieve and display the system date===

{| style="width: 100%; border: 1px solid black" align="top" border="1" cellpadding="5"
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=100 | Function
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Description
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Construction
! scope="col" style="background: #3CB371; color: black; border: 1px solid black" width=400 | Examples
|-
|- valign="top"
! scope="row" style="background: #A8E4A0; color: black; border: 1px solid black" | Now()
|style="border: 1px solid black" | A ||style="border: 1px solid black" | B ||style="border: 1px solid black" | C
|}
<div style="text-align:right;">([[#top|Back to top)]]</div>
==When, Where and How to use expressions==

===Specify data types for expression based fields===

Latest revision as of 18:37, 7 October 2010

this page can be deleted now.