Re: Indexing Word Custom Document Properties


yell89@xxxxxxxxxxxxxx wrote:
I'm trying to index a custom document property setup in Word, but
without sucess.

The custom document property is called "Reviewdate" and is defined as a
"Date" in word.

In the index server reviewdate has been setup to be cached as type
"VT_Date". The index server has been stopped and restarted with a full
rescan requested on all the documents.

I'm then using ASP to query the database and have added the line:

Q.DefineColumn "ReviewDate (VT_FILETIME) =
d5cdd505-2e9c-101b-9397-08002b2cf9ae reviewdate"

However, I can't search on reviewdate and I can't write out the value
either (I just get a blank).

I have tried changing VT_FILETIME above to DBTYPE_DATE but that didn't
make any difference.

I do know the document is being indexed because the the ASP code can
find the document if I search on the document's text (rather than
searching on ReviewDate).

Does anybody have any ideas as to what I'm doing wrong?

I'm having a similar problem with date ranges. I have custom meta
properties for publish and expiration dates and I'm trying to limit the
results on documents with dates that fall between those.

My html props look like this:

<o:publishdate-html dt:dt="string">2006-01-01
12:00:00</o:publishdate-html>
<o:expirationdate-html dt:dt="string">2006-12-12
12:00:00</o:expirationdate-html>

They are set to cache as VT_FILETIME

My query looks like this:

({prop name=roleids-html}0 or 32{/prop}) and ({prop
name=keywords-html}keyword{/prop}) and ({prop name=publishdate-html} >
'2005/10/1 12:00:00'{/prop} and {prop name=expirationdate-html} <
'2007/10/1 12:00:00'{/prop})

I'm running out of ideas here. Thanks for your help!

.

Relevant Pages

  • Re: Indexing Word Custom Document Properties
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... In the index server reviewdate has been setup to be cached as type ...
    (microsoft.public.inetserver.indexserver)
  • Indexing Word Custom Document Properties
    ... I'm trying to index a custom document property setup in Word, ... The custom document property is called "Reviewdate" and is defined as a ... In the index server reviewdate has been setup to be cached as type ... I do know the document is being indexed because the the ASP code can ...
    (microsoft.public.inetserver.indexserver)
  • Re: Cross Tab query date format and sort order
    ... I created a Dates table and query with criteria as you instructed. ... > TheDate Between ReviewDate and ReviewDate + ReviewDays ... >>> Duane Hookom ...
    (microsoft.public.access.queries)
  • Re: Day, month, and current year
    ... >Can you post the SQL statement behind the query? ... The statement (in the criteria for ReviewDate) is: ... ReviewDate field, but the filter is being ... if I use (in the calculation for ReviewDate): ...
    (microsoft.public.access.queries)
  • Re: Day, month, and current year
    ... I don't know if it's relevant, but I noticed that every single reference to ... a table field in your query is fully qualified ... calculate the [ReviewDate] and return the other fields you want -- ... apply all criteria except the Between ... ...
    (microsoft.public.access.queries)
Loading