MDREPO -- retrieve data from metadata repository

• Attention: This variable works only if MetadataRepository is in use. Otherwise, it always returns a zero length string.
• This retrieves data from the specified metadata repository table.
• Syntax: %MDREPO{ "table" ...}% (generic form), %MDREPO{ web="..." ...}% (web specific form)
• Parameters (generic form without web="..." parameter):

  Parameter	Description	Default
  "..."	Specify the table to retrieve	This or below is required
  table="..."	(Alternative to above)	This or above is required
  separator="..."	The separator string of records	"$n" (new line)
  format="..."	Format of one record. It may contain the following items. In addtion, the standard special tokens are handled accordingly. Item Description $_ or $_() the record ID $__ or $__() The record value in the following format: FIELD_NAME=FIELD_VALUE FIELD_NAME=FIELD_VALUE ... $marker or $marker() Expands to marker for the item matching selection only $_FILED_NAME or $_FIELD_NAME() Please be noted that you need to put _ (underscore) in front of a field name. $_FIELD_NAME$ yields the value of the specified field. If the specified field does not exist in the record, it returns the null string (""). ?FIELD_NAME?IF_FIELD_HAS_VALUE? If the specified field has value and it's neither 0 nor the null string (""), it's evaluated as IF_FIELD_HAS_VALUE. Otherwise, it's evaluated as the null string. This is like q/.../ in Perl. A non-word character following ?FIELD_NAME becomes the terminator; i.e. you can write: ?FIELD_NAME:IF_TRUE: Specifically, the following characters can be used as the delimiter: ! # % ' / : ? @ ^ ` | ~ = is excluded because it clashes with a parameter specification in a URL (?name=value). ?!FIELD_NAME?IF_FIELD_HAS_NO_VALUE? Similar to above but it's opposite. If the field has value, it's evaluated as the null string. Otherwise, it's evaluated as IF_FIELD_HAS_NO_VALUE. $question Replaced with ? after the ?FIEL_DNAME and ?!FIELD_ANME constructs are processed.	"| $_ | $__ |"
  selection="..."	The record ID to be regarded as the selected. It affects how $marker in the format is evaluated.	none
  marker="..."	Text for $marker in the format if the item matches selection	"selected"
  filter="..."	The regular expression of record IDs to filter records. Matching is case-insensitive	none
  exclude="..."	Comma separated list of record IDs to be excluded. You can use regular expression. If you specify Trash\d*, then Trash, Trash1, Trash2, ... are exluded but LightTrash and TrashBag are not excluded	none

• Example: %MDREPO{"webs" filter="^A" format="| $_ | $_admin | $_master |"}%
  This would show the metadata of webs whose names start with A.
• Paramerers (web specific form):

  Parameter	Description	Default
  web="..."	Specify the web. If it's a subweb, the corresponding top level web is specified	This is required
  "..."	Specify the format of the return value in the same manner as the format parameter in the generic form	$__
  default="..."	Specify the value to be returned when the specified or implied top level web does not exist in MDREPO	"" (null string)

• Example: %MDREPO{web="Foo/Bar" "$_admin"}%
  This would show the admin field of the Foo web.
• Category: AdministrationVariables, SystemInformationVariables
• Related: MetadataRepository