sql server full text search: XML Ifilter Question -- sql server full text search

XML Ifilter Question

E F
9/21/2003 3:59:03 PM

sql server full text search:

I have a SQL 2000 running on .net 2003 server

for example i have the fallowing xml file as an image col, properly
indexed stec...

<?xml version="1.0" encoding="utf-8"?>
<SQLContentItemSerialization
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="Common.Libraries.ContentObjects.V3s">
<MyAttributes>
<Attributes>
<AttributeName>Author</AttributeName>
<AttributeValue>
<anyType xsi:type="xsd:string">Jon</anyType>
</AttributeValue>
</Attributes>
<Attributes>
<AttributeName>Subject</AttributeName>
<AttributeValue>
<anyType xsi:type="xsd:string">Hello world</anyType>
</AttributeValue>
</Attributes>
</MyAttributes>
</SQLContentItemSerialization>

since the The microsoft XML iFilter will index
* values of sub-elements of the root element when
the sub elements have no child elements.
* attributes of the root element and attributes of
sub-elements of the root element

Lets assume that i will later simplify the xml so it will have only the
level of elements, according to the Ifilter abilities.

How do i query a specific sub-element or an attributes
For example
Select * from tablename where CONTAINS(columnname, Author = " Jon "')
Or
Select * from tablename where Author = " Jon "'
Or something similar

In sharepoint and index server I first need to define the property? Both
use the same ifilter , so how can I do it via SQL server?

*** Sent via Developersdex http://www.developersdex.com ***

XML Ifilter Question

Hilary Cotter
9/22/2003 4:48:15 AM

Results from the xml iFilter are emitted by as properties
which SQL Server does not index.

I suggest you store your xml in a table and then apply
your indexing to this table.

You will get mixed results if you index your xml document
if you store it in a text column. However - it might give
you what you are looking for.
[quoted text, click to view]

Re: XML Ifilter Question

E F
9/22/2003 8:39:30 AM

what is the point in indexing an xml file if u dont have ability to
query the elements/attributes, its just like indexing a text file, and
having few more words on your dictionarry?

my question is also regarding any binary file saved as an image file.
what i'm trying to do is build a simple file storage based on SQL
server, and i want to take advantage of the basic info in known file
types.

lets take a word document, i index the document
using Sharepoint search abilites o index server which uses the same
ifilter, i can search for text in the document or text in other
properties like auther, subject, pages etc...
in sharpoint i can ask for all documents that their pages is more then
15, can i do it using SQL server?

*** Sent via Developersdex http://www.developersdex.com ***

Re: XML Ifilter Question

Hilary Cotter
9/22/2003 7:52:38 PM

In other versions of Microsoft Search products you can do precisely this.
However in SQL Server FTS it was designed to just index the contents of a
column/row or the contents of a document stored in an image datatype column.
By design you could not index the properties.

Perhaps in a future version of the product.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server full text search group.