Selectable Fields for Query

This section lists the selectable fields for query objects.

Selectable Fields for Query
Field Description Output

description

Not used

 

expandtype

Find types that are children of types searched for?

True/False

hidden

Is this query defined as hidden?

True/False

id

Query identifier

Value

modified

The time and date the query was modified

Value

modified.generic

The time and date in generic format (independent of the MX_NORMAL_DATETIME_FORMAT and MX_DECIMAL_SYMBOL settings chosen by an Administrator) the query was modified

Value

name

Query name

Value

object[ ]

a corresponding business object

Returns a business object where the type matches the string in [ ] and the name is the same as the query's name. If no string is given, the object type is query, with case ignored. In a case sensitive environment if more than 1 type meets that criteria (such as both a Person type and a PERSON type), OR if there are more than 1 object with the same type and name that are not in the same revision chain, the object with the latest originated date is returned. When objects with same type and name are in the same revision chain, the latest revision is returned.

originated

Time and date the query was created

Value

originated.generic

The time and date in generic format (independent of the MX_NORMAL_DATETIME_FORMAT and MX_DECIMAL_SYMBOL settings chosen by an Administrator) the query was created

Value

owner

Value of owner field for query

value (see Selectable Fields for User)

property[].*

The associated properties

If property[ ] is specified, returns property names and values. If blank, returns all property names and values.

revision

Revisions to be included in search criteria.

Value

type

Types to be included in search criteria.

vault

Vaults to be included in search criteria.

vault name (see Selectable Fields for Vault)

where

Where clause of query

Value