I have a managed metadata column 'VideoArea' tied to a Search Metadata Property named 'PuroCastVideoArea'. I am firing a full text query ( as below ). The problem is that the search service returns Metadata Property 'PuroCastVideoArea' only in the first case. IE for the second query, the results are returned but there is no PuroCastVideoArea node/data in it. Though in both the cases, rest of the custom properties like PuroCastVideoDescription etc is returned
Note that these queries are being fired via Javascript using SPServices library
Any idea what could be done to make the second query return the column values?
Query Returning Data
<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>
<Query>
<Context>
<QueryText language="en-US" type="MSSQLFT">SELECT Title, Path,PuroCastVideoDescription,PuroCastThumbNail,PuroCastDuration,PuroCastVideoArea, DocId FROM Scope() WHERE "Scope" = 'Videos' AND CONTAINS(PuroCastVideoArea, 'SharePoint')
</QueryText>
</Context>
</Query>
</QueryPacket>
Query not returning data
<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>
<Query>
<Context>
<QueryText language="en-US" type="MSSQLFT">SELECT TOP 12 Title, Path,PuroCastVideoDescription,PuroCastThumbNail,PuroCastDuration,PuroCastVideoArea, DocId FROM Scope() WHERE "Scope" = 'Videos' ORDER BY "PuratosCreatedDate" DESC</QueryText>
</Context>
</Query>
</QueryPacket>