Properties for advanced queries with the Data Discovery Suite search facility

The table below presents the properties you can use in advanced queries while the Data Discovery Suite search facility is active. For each property, the table shows the case-sensitive property name, the data type, a description, an example, and the equivalent structured search property, if any. Values for properties with a data type of string follow the rules for search terms in simple searches.

NoteYou cannot use $now for datetime values in advanced queries.
Advanced search propertyData typeDescriptionExampleStructured search equivalent
accesstimeDatetimeThe POSIX access time (atime) attribute for the object. Users and applications can change this metadata.accesstime:range (2011-11-12T05:00:00Z,max, from="GE")Access Time
archivedtimeDatetimeThe date and time the object was created in the namespace (that is, when the data was added to the namespace).archivedtime:range:(min,2011-11-01T05:00:00Z, to="LT")Ingest Time
attachmentStringThe name of a file attached to the email.attachment:"Sales Quotas 2012"Email Attachment Name
authorStringThe value of the Author metadata property that occurs in many Microsoft® Office and Adobe PDF documents.author:"lgreen"Author
bodyCompositeThe data content, name, title, and email subject of the object. This property is the equivalent of a simple search.1content:"medic*"Object Content
categoryStringThe value of the Category metadata property that occurs in many Microsoft® Office and Adobe PDF documents.category:"Sales Minutes"Category
changetimeDatetimeThe POSIX change time (ctime) attribute for the object. This is the last time the object metadata changed.changetime:range(2011-11-01T04:00:00Z,max, from="GE")Change Time
charsetStringThe character set or encoding used in the document. Use unknown for documents for which HCP cannot determine the character set.charset:string("utf-8")Character Set
contenttypeStringThe object MIME type.contenttype:string("application/zip")Object Type
dataindexedInt32

An indication of whether the object content and/or custom metadata is indexed and whether the object name is valid UTF-8 encoding. Valid values are the sum of any combination of these:

  • 0

    Object name is percent encoded, if necessary.

    Content is indexed.

  • 2

    Content is not indexed because HCP could not determine the MIME type.

  • 3

    DDS: Content is not indexed because it exceeds ten MB.

    HCP: Content is not indexed because it exceeds 50 MB.

  • 10

    Custom metadata is indexed.

  • 20

    Custom metadata is not indexed due to invalid XML.

  • 30

    DDS: Content is not indexed because it exceeds ten MB.

    HCP: Content is not indexed because it exceeds 50 MB.

  • 90

    Object has no custom metadata.

  • 100

    Object name is valid UTF-8 encoding.

dataindexed:range(100,190,from="GE",to="LT")N/A
emailbccStringThe email address of one blind-copied email recipient.emailbcc:or("pcornflower@example.com")Email BCC
emailccStringThe email address of one copied email recipient.emailcc:rsilver@example.comEmail CC
emaildateDatetimeThe date the email was sent.emaildate:range(2011-11-14T04:00:00Z,2011-11-15T04:00:00Z,from="GE", to="LT")Email Sent Date
emailfromStringThe email address of an email sender.emailfrom:"lgreen@example.com"Email From
emailmessageidStringThe ID of the email in the namespace.emailmessageid:"73495B59-04A3-59FC-573D-8380897A78BB@example.com-mbox.eml"Email Message ID
emailsubjectStringThe text in the email subject line.emailsubject:"Weekly SalesDepartment Meeting,Minutes -- 2/2/12"Email Subject
emailtoStringThe email address of one email recipient.emailto:rsilver@example.comEmail To
expirationtimeDatetime

The retention setting for the object. Valid values are:

  • For objects that can never be deleted:
    1970-01-01T00:00:03Z
  • For objects that can be deleted at any time:
    range(current-datetime,max)
  • For objects that expire at a specific date and time:
    range(datetime,datetime,from="GE",to="LE")

    In this criterion, the two variables specify the same date and time.

  • For objects that expire on a specific date:
    range(dateT00:00:00Z,date-plus-oneT00:00:00Z,from="GE", to="LT")

    In this criterion, the second date is one day later than the first.

  • For objects that do not yet have a retention setting:
    1970-01-01T00:00:02Z
  • For objects that have expired:
    range(1970-01-01T00:00:10Z,current-datetime)

Any of these values can return objects for which the retention setting is a retention class. This happens for objects that had a retention setting before being assigned to a class.

expirationtime:range(2015-01-13T00:00:00Z,2015-01-14T00:00:00Z,from="GE", to="LT")Retention
filenameStringAll or part of a path and object name, starting after fcfs_data, data, or rest.filename:"french/news_f/pres03_f/mou_16feb03_f.doc"Object Path
formatStringThe format of the object content. This is typically the name of the application used to create the content.3format:"Adobe Photoshop"Content Format
gidInt32The POSIX group ID of the owning group for the object.gid:24GID
gidStringThe cryptographic hash value of the object.hash:"9B6D8A603659B447DA4..."Hash
hashStringThe cryptographic hash value of the object.hash:"9B6D8A603659B447DA4..."Hash
holdInt32

An indication of whether the object is currently on hold. Valid values are:

  • 1

    The object is on hold.

  • 0

    The object is not on hold.

hold:"1"Retention Hold
languageDatetimeThe POSIX modify time (mtime) attribute for the object. Users and applications can change this metadata.modtime:not(range(2011-11-04T04:00:00Z,2011-11-10T04:00:00Z,from="GE", to="LE"))Modification Time
permissionsInt32The decimal equivalent of the octal value of the POSIX permissions for the object.4

permissions:420

This is equal to octal 644.

Permissions
retentionclassStringThe retention class specified as the retention setting for the object.retentionclass:"HlthReg-107a"Retention Class
shredInt32

An indication of whether the object will be shredded when it’s deleted. Valid values are:

  • 1

    The object will be shredded.

  • 0

    The object will not be shredded.

shred:"0"Shredding
sizeFloatThe object size, in bytes. This is the exact size of the object content. For example, to search for a two KB object, you need to specify 2048, not 2000.size:range(min, 5000, to="LT")Size
subjectStringThe value of the Subject metadata property that occurs in many Microsoft Office and Adobe PDF documents.subject:quotasSubject
titleStringThe value of the Title metadata property that occurs in many Microsoft Office and Adobe PDF documents.title:"Monthly Sales Statistics --February 2012"Title
uidInt32The POSIX user ID of the object owner.uid:72UID