Simple SQL Query Problem

Question

When performing a FullTextSQLQuery against my SharePoint site's document library and retrieving field 'Path', I occasionally get the likes of "Forms/DispForm.aspx?ID=45" returned at the end of a record's Path field. Instead of this - I want the url of the file (deemac.pdf for example). What field do I instead to refer to?

Answer 1

SharePoint Search will return the url to the document in Path when it thinks a file is a document (isDocument == 1), but if the file isn't a recognized file type SharePoint will treat it as a list item and return the url of the display form in Path.

You can add support for more file types by adding IFilters (see here for PDF: How to configure PDF iFilter for SharePoint Server 2010 or Search Server 2010) or just add the file type as described in How to add a file type to the content index in SharePoint 2010

You should also consider using KeywordQuery instead of FullTextSQLQuery as this isn't supported when using FAST search or in SharePoint 2013

Answer 2

FileRef will give you the URL of file

FileDirRef will give you path of folder the file exists in

and FileLeafRef is the name of the file!

Hope this helps!

Answer 3

What you are looking at IS the URL needed. Forms/DispForm.aspx?ID=45 Let's break that URL down. "Forms/" It's a form. "DispForm.aspx" That's the form used to display results; which is what the search spider used. But with out an ID entry, you won't get any form results, just the form. "?ID=45" that's the particular form results to pull up and display.

So simply put, what you got IS the URL needed to display the results. What is being shown is the result of a form submission.

Answer 4

Try with FileName field as follow:

select Title, Path, Filename from scope()

Hope it helps!! :)

It it's not then I believe, u have to go through the steps Per Jakobsen has mentioned above.