API Questions on Kentico API.
Version 6.x > API > How to create a Smart Search index for table joins or table views? View modes: 
User avatar
Member
Member
lancetek - 6/17/2013 4:50:36 AM
   
How to create a Smart Search index for table joins or table views?
Hi,
What is the recommended way to create a SmartSearch index for a View?

We have quite a few complex custom table views that we'd like to have indexed for quicker searching. As an example, how would you create a Smart Search index for a normal Kentico view, like the View_CMS_Tree_joined ?

The tables are frequently updated, and I'd like the index to be updated in near-realtime whenever any of the underlying objects are changed. Some of the tables belong to Custom Document Types - so maybe I can just hook into the document creation, update and delete events.


I've been researching the Custom Smart Search Index in the developer docs and found a nice video from Miro: http://devnet.kentico.com/Videos/System-Management/Smart-Search-in-Kentico-CMS-6.aspx So I'm thinking that I need to create a custom smart search indexer, but I thought I'd ask since there are quite a few of these views that we need indexed.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 6/20/2013 1:37:45 AM
   
RE:How to create a Smart Search index for table joins or table views?
Hi,

Yes, creating a custom index content is the right way how to do it.

Best regards,
Juraj Ondrus

User avatar
Member
Member
Nel215 - 7/30/2013 3:59:50 AM
   
RE:How to create a Smart Search index for table joins or table views?
hi
I am new to Kentico and I have same problem as well. the document above is for a file search index, and it put the file content as the search document content, however for a table view, what should i put for the search document content

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 8/1/2013 12:51:36 AM
   
RE:How to create a Smart Search index for table joins or table views?
Hi,

Could you please clarify? I am not sure I understand what you want to achieve. What table view you mean?

Best regards,
Juraj Ondrus

User avatar
Member
Member
Nel215 - 8/1/2013 1:23:40 AM
   
RE:How to create a Smart Search index for table joins or table views?
sorry, English is not my first language and I hope I can express clearly.
I mean a view which is generated by database tables. I tried to make each row a search document and it did work as what I want.


User avatar
Kentico Support
Kentico Support
kentico_jurajo - 8/4/2013 1:35:14 AM
   
RE:How to create a Smart Search index for table joins or table views?
Hi,

I am really sorry but it does not make any sense to me. I got that you want to use some database view, right? But what you want to achieve is still unclear to me. Could you please explain e.g. on some example?

Best regards,
Juraj Ondrus