MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE Betriebsanweisung PDF herunterladen (Seite 39)

AssetQuery

Components User's Guide

metafilter

Metadata field name and

value

Uses metadata fields and values to narrow the query.

For example:

metafilter="(M.name='Reviewer') AND

(M.value='Steven')"

Will limit the query to assets with a metadata field

called "Reviewer" with a value of "Steven." Notice that

all data fields must be preceded by

You can query multiple metadata fields at one time, by

separating multiple metafilter definitions with a

semicolon. You can also link multiple filter statements

with

. For example:

 metafilter="(M.name='Reviewer') AND

(M.value='Steven');(M.name='Product')

AND (M.value='Collage')"

Limits the results to files reviewed by Steven for

the Collage product.

 Metafilter="(M.name='Reviewer') AND

(M.value='Steven' OR M.value='Nancy')"

Limits the results to assets that were reviewed

either by Steven or by Nancy.

 metafilter="((M.name='Reviewer') AND

(M.value='Steven')) OR

((M.name='Author') AND

(M.value='Steven'))"

Limits the results to assets that were either

authored or reviewed by Steven.

For date properties, you can also use the

M.ValueDateTime

statement with the following to

define more advanced filters:

 is null

: To limit results to assets for which no

date is defined, for example:

"(M.name='PurchaseDate') AND

(M.ValueDateTime is null)"

 is not null:

To limit results to assets for which

any date is defined, for example:

"(M.name='PurchaseDate') AND

(M.ValueDateTime is not null)"

 current timestamp

: To limit results based on the

current (most recent) timestamp. For example, to

return assets for which a metadata field is set to

an earlier date/time than the current date/time:

"(M.name='PurchaseDate') AND

(M.ValueDateTime <= current

timestamp)"

NOTE

For SQL and Oracle, the syntax for

current

timestamp

current_timestamp

Property Value Description

1 2 ... 34 35 36 37 38 39 40 41 42 43 44 ... 141 142

Kommentare zu diesen Handbüchern

Keine Kommentare

MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE Betriebsanweisung Seite 39

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE