SV Scalar Fields

This object query requests all scalar fields of Person objects whose LastName is Garn:

GET /Msgs/Person/_query?q=LastName:Garn&f=*

In XML, the result looks like this:

<results>

<docs>

<doc>

<field name="Department">Field Sales</field>

<field name="FirstName">Chris</field>

<field name="LastName">Garn</field>

<field name="Name">Chris Garn</field>

<field name="Office">Aliso Viejo 5</field>

<field name="_ID">07Z094KNjmEsqMoV/yNI0g==</field>

</doc>

<doc>

<field name="Department">Sales Operations</field>

<field name="FirstName">Jim</field>

<field name="LastName">Garn</field>

<field name="Name">Jim Garn</field>

<field name="Office">Aliso Viejo 5</field>

<field name="_ID">kUNaqNJ2ymmb07jHY9OPOw==</field>

</doc>

<doc>

<field name="Department">Admin</field>

<field name="FirstName">Doug</field>

<field name="LastName">Garn</field>

<field name="Name">Doug Garn</field>

<field name="Office">Aliso Viejo 5</field>

<field name="_ID">m1yYabbtytmjw+e8OCz1dg==</field>

</doc>

</docs>

</results>

In JSON:

{"results": {

"docs": [

{"doc": {

"Department": "Field Sales",

"FirstName": "Chris",

"LastName": "Garn",

"Name": "Chris Garn",

"Office": "Aliso Viejo 5",

"_ID": "07Z094KNjmEsqMoV/yNI0g=="

}},

{"doc": {

"Department": "Sales Operations",

"FirstName": "Jim",

"LastName": "Garn",

"Name": "Jim Garn",

"Office": "Aliso Viejo 5",

"_ID": "kUNaqNJ2ymmb07jHY9OPOw=="

}},

{"doc": {

"Department": "Admin",

"FirstName": "Doug",

"LastName": "Garn",

"Name": "Doug Garn",

"Office": "Aliso Viejo 5",

"_ID": "m1yYabbtytmjw+e8OCz1dg=="

}}

]

}}

The _ID field of each object is always included. SV scalar fields are returned only if they have values. If a group contains any leaf fields with values, they are returned at the outer (doc) level: the group field is not included.

When timestamp fields are returned, the fractional component of a value is suppressed when it is zero. For example:

2012-01-06 19:59:51

This value means that the seconds component is a whole value (51). If a seconds component has a fractional value, it is displayed with 3 digits to the right of the decimal place. Example:

2012-01-06 19:59:51.385