• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1016
  • Last Modified:

Abstract (characterization) from Microsoft Index Server (msidxs) not displaying in gridview

I am using MS Indexing Service to seach some files on the filesystem and then display the results in a search webpage based on a users query. Here is the query I am using:

SELECT filename, path, rank, characterization, write
FROM scope()
WHERE filename <> 'search.aspx'
AND FREETEXT(Contents, '" + txtSearch.Text + "')
ORDER BY rank DESC

When I put the results of these searches to a grid view, and set the grid view to autogenerate all columns,  I get the following columns:

filename, path, rank, write

The characterization column is missing. Not blank, mind you, but just not there. I have checked on "generate abstracts" in the Indexing service, and have rebuilt the catalog a few times already. What am I doing wrong here?

For the record, I noted that when I pass a column name that MSIDX does not support (anything, like "filecharactercountandsize") an error is thrown. So is is clear that is accepts the column name "characterization", but its not returning content (and it's hiding the column)
0
Ike23
Asked:
Ike23
  • 2
1 Solution
 
DreamMasterCommented:
Have you tried writing out the values without the use of a gridview, or even without using "AutoGenerateColumns" for that matter (that way you can define what columns you want to show and could check if it actually works)

Regards,
Max.
0
 
Ike23Author Commented:
Wow! that was it. Thankyou thank you thank you!
0
 
DreamMasterCommented:
Glad to have been helpful :)

Regards,
Max.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now