Email Date and Time fields in SharePoint Search Results
When performing a search in SharePoint 2010, the column EmDateReceived is returned in the results XML in the element , i.e. what I called it as a Managed Property. This wirks fine except that the Time part of the field (displayed everywhere else) is missing. Is this a known limitation?
Ilia Zhukov commented
Thank you for the details provided.
Could you please do the following:
1) Create new document library;
2) Add new column with DateTime type and "Date & Time" format for the values;
3) Upload any document (Word, Excel, txt) to this library using standard IE interface;
4) Put some value to the column from step # 2;
5) Create new Managed property, map it to the column from step # 2;
6) Reset Index under "Central Administration - Search Service Application: Search Administration";
7) Start all crawls, wait until it finished and execute the search against the library from step # 1.
Could you please provide XML results in this case?
Russ Ramirez commented
The search is performed within SharePoint 2010. The XML I'm referring to is that which SP is returning. Here is an example of one such Result element (more below):
<?xml version="1.0" encoding="utf-8" ?>
<title>xxxxxxxx xxx xxxxxxxxxxxx</title>
<url>http://jobportal-hun-arc/Huntair Dropbox/FW_ 1032 xxxxxxx xxxxx_1qu1kk9o.msg</url>
Tom McClung; Jim Tarala; Kaufman, Jeff <ddd /> 2006-06-08T12:11:20Z <ddd /> Attached is Kurt Schultheis’ xxxxxx quote with the coil construction data in the attachment. <ddd /> Subject: RE: <c0>1032</c0> xxxxxxxxxxxx <ddd />
FW: <c0>1032</c0> xxxxxxx xxxxx
http://jobportal-hun-arc/Huntair Dropbox/FW_ <c0>1032</c0> xxxxxx xxxxx_1qu1kk9o.msg
Notice is a formatted date value, but this is actually a managed property in the search Metadata, which I have mapped to Crawled property ows_EmDateReceived, and the type is "Date and Time". The other properties are all displaying fine, but are text strings for the most part - hard to compare them to a DateTime field. The SharePoint data includes the Time portion of the Date and Time representation of the values. If the raw search results do not contain the Time, then this cannot be used to sort the rows by this value.
Ilia Zhukov commented
thank you for your question!
To answer it, could you please provide more details about the issue?
Where do you perform the search?
Clarify what XML file is used and where?
Provide step-by-step screenshots of the process
Please feel free to send your answer to my e-mail: ilia (at) scinaptic.com
Hope to hear from you soon.