I have a query that retrieves selective fields from a doc that are partially grouped. For example i am getting in the query 6 of posible 30+ fields for Agents and i would like to return them in the result as a
object called Agents and the have the fields inside
SELECT META(p1).id AS DocId,
p1.Record.Dates,
p1.Record.StandardStatus,
p1.Record.PreviousStandardStatus,
p1.Record.MajorChangeType,
p1.Record.Prices.OriginalListPrice,
p1.Record.Prices.ListPrice,
p1.Record.Prices.ClosePrice,
p1.Record.Agents.BuyerAgent.BuyerAgentFirstName,
p1.Record.Agents.BuyerAgent.BuyerAgentLastName,
p1.Record.Agents.BuyerAgent.BuyerOfficeName,
p1.Record.Agents.ListingAgent.ListAgentFirstName,
p1.Record.Agents.ListingAgent.ListAgentLastName,
p1.Record.Agents.ListingAgent.ListOfficeName
FROM p AS p1
ORDER BY p1.Record.Dates.ModificationTimestamp DESC