Developer forum

Forum » Development » RE: SQLIndexBuilder - Missing source

RE: SQLIndexBuilder - Missing source

Jeppe Jakobsen
Reply

Hi everyone

I watched "Indexing Everything" https://vimeo.com/132530134 - by Jeppe Agger and found it very helpful, but there is a discrepancy with the video and the available choices when creating a field on a Index. If you create a build using either a content-, user- or productbuilder, and then add a new field, the available sources will be displayed in the dropdown menu. I imagine this feature comes from the builder, which seems to me missing from the SqlIndexBuilder. About 6 minutes into the video, Jeppe Agger clearly shows how you can select a column with a SqlIndexBuilder, by typing the name in the source input, but in my version (8.7.0.3) the dropdown is simply empty and no input is possible. I know i have data because my IndexQuery yields results when i don't specify any fields, but if create a field without selecting a source i simply get a "Value cannot be null. Parameter name: key" and the index won't build.

Am i misunderstanding something here or does this render the SqlIndexBuilder useless?


Replies

 
Jeppe Eriksson Agger Dynamicweb Employee
Jeppe Eriksson Agger
Reply
This post has been marked as an answer

Hi Jeppe,

 I'm glad you found the video helpful.

We changed the user interface in 8.7 from requiring a manual entry of field source to the dropdown. I can see that there's an issue with the SqlIndexBuilder, as you correctly state. I have registered a bug to get this fixed. The bug report has number 19971.

In the meantime, you can work around the problem by manually setting the field source in the xml file for the index.

- Jeppe

Votes for this answer: 1
 
Jeppe Jakobsen
Reply

Thank you for a quick response, i will try to do that instead.

 
Kristian Kirkholt
Reply
This post has been marked as an answer

Hi Jeppe

The problem TFS#19971 "SqlIndexBuilder does not populate the field source dropdown"  has now been fixed in version 8.7.2.3

You are able to find this build in the download section:

http://developer.dynamicweb-cms.com/downloads/dynamicweb-8.aspx

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Votes for this answer: 1

 

You must be logged in to post in the forum