Datetime or int properties crawled by jdbc have no value in search results RRS feed

  • Question

  • hi

       i have  a property in jdbc called "completiondate",it is Datetime type in database.

      After crawling,In CA i add a Managed property called "Completiondate" and mapped it to completiondate(Datetime).

     In result.aspx i add a Fetched Properties <Column Name="Completiondate"/>  in "Search Core Results" webpart  .

    So ,the results is look like this,it is no value there,it is wired.


    But when  i changed the sql  converting  the "completiondate" to string datatype,and mapping it to completiondate(Text),of course recrawling it.

    it will have value in there ,it look like this :<completiondate>2012-10-10</completiondate>

    So ,my problem is ,is there any way to put no string property like Datetime or int to the search results,or is my step wrong?

    any one can help me?

    In God We Trust

    Wednesday, May 2, 2012 3:20 AM


  • hi

       Today is a lucky day ,it's ok now by setting "integer type" managed property mapping to "integer type" crawled properties.


    In God We Trust

    • Marked as answer by Fiyoung Friday, June 29, 2012 7:00 AM
    Friday, June 29, 2012 7:00 AM