Skip to content

Russ Ramirez

← Customer Feedback for OnePlace Solutions

My feedback

1 result found

  1. Email Date and Time fields in SharePoint Search Results

    0 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  OnePlaceMail (Desktop)  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    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" ?>

    <All_Results>

    <Result>

    <id>1</id>

    <workid>542</workid>

    <rank>79717428</rank>

    <title>xxxxxxxx xxx xxxxxxxxxxxx</title>

    <author_multival>Leska, Craig</author_multival>

    <author>Leska, Craig</author>

    <size>1230848</size>

    <url>http://jobportal-hun-arc/Huntair Dropbox/FW_ 1032 xxxxxxx xxxxx_1qu1kk9o.msg</url>

    <urlEncoded>http%3A%2F%2Fjobportal%2Dhun%2Darc%2FHuntair%20Dropbox%2FFW%5F%201032%20Kaiser%20Coils%5F1qu1kk9o%2Emsg</urlEncoded>

    <description></description>

    <opmto>John Albert</opmto>

    <opmfromname>Tim Lema</opmfromname>

    <opmreceived>6/8/2006</opmreceived>

    <opmattachmentnames>SCAN1677_000.pdf</opmattachmentnames>

    <opmattachmentcount>1</opmattachmentcount>

    <write>7/2/2012</write>

    <sitename>http://jobportal-hun-arc/Huntair Dropbox</sitename>

    <collapsingstatus>0</collapsingstatus>

    <hithighlightedsummary>

    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 />

    </hithighlightedsummary>

    <hithighlightedproperties>

    <HHTitle>

    FW: <c0>1032</c0> xxxxxxx xxxxx

    </HHTitle>

    <HHUrl>

    http://jobportal-hun-arc/Huntair Dropbox/FW_ <c0>1032</c0> xxxxxx xxxxx_1qu1kk9o.msg

    </HHUrl>

    </hithighlightedproperties>

    <contentclass>STS_ListItem_DocumentLibrary</contentclass>

    <isdocument>True</isdocument>

    <picturethumbnailurl></picturethumbnailurl>

    <popularsocialtags />

    <picturewidth>0</picturewidth>

    <pictureheight>0</pictureheight>

    <datepicturetaken></datepicturetaken>

    <serverredirectedurl></serverredirectedurl>

    <fileextension>MSG</fileextension>

    <ows_metadatafacetinfo></ows_metadatafacetinfo>

    <imageurl imageurldescription="Mail">/_layouts/images/icmsg.png</imageurl>

    </Result>

    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.

    Russ

    Russ Ramirez shared this idea  · 

Feedback and Knowledge Base

(thinking…)