
36
Serena® Collage® 5.1.3
Chapter 3 Design-Time Component Reference
filter (continued)
For date properties, you can also use the following to
define more advanced filters:
is null
: To limit query results to assets for which
a date property is undefined, for example:
A.StartDate is null
is not null:
To limit results to assets for which
any date is defined,
for example:
A.StartDate is not null
current timestamp
: To limit results based on the
current (most recent) timestamp. For example, to
return assets that are scheduled to expire in the
future:
( A.ExpireDate > current timestamp )
Greater than/less than (
< >
) statements
Greater than/less than or equal to statements (
<=
=>
)
Not equal statements (<>)
All data fields must be preceded by
A
. Possible values
are:
A.FileName
: Asset filename
A.assetid
: Asset ID number
A.Description
: Asset description
A.MimeType
: Asset MIMEType
A.Size
: Asset file size
A.CreateDate
: Asset creation date
A.
AssetType: Asset type name
A.Name
: Asset name
A.IsMasterPage
: "
1
" indicates that the asset is a
master page, "
0
" indicates that it is not
Property Value Description
Commenti su questo manuale