Forums (Obsolete)


Member	alien_271-hotmail - 12/1/2009 7:52:50 AM Use search box in custom table I want to search something (phrase, word, etc.) in a custom table using the search box dialog. Is that possible?


Member	alien_271-hotmail - 12/1/2009 3:24:59 PM RE:Use search box in custom table Could somebody help?

Kentico Developer

kentico_martind - 12/17/2009 3:59:48 PM

RE:Use search box in custom table

Hello,

Regrettably, searching in custom table is not natively supported. If you use search box and search results web parts, you could add e.g. repeater with custom query to page with search results and use search expression passed to page in query string in where condition of this repeater so it displays only records containing given expression. You can use query string macros in where condition to get value(s) from query string. Please see 'Appendix A - Macro expressions' section in Dev.Guide for more details.


Member	scott_hancock-urmc.rochester - 9/23/2010 9:32:59 AM RE:Use search box in custom table Then why can you create an index on a custom table?

Kentico Consulting

kentico_mirekr - 9/24/2010 7:08:21 AM

RE:Use search box in custom table

Hi,

In Kentico CMS 5.5 you are able to search custom tables (in custom table module) with smart search:

http://devnet.kentico.com/docs/devguide/custom_tables_module_overview.htm
http://devnet.kentico.com/docs/devguide/smart_search_defining_ct_index_content.htm

Your initial question was about "search box" and custom tables and not about "smart search box" web part.

Smart search module indexes and searches custom tables from custom table module from version 5.5.

Best regards,
Miroslav Remias.


Member	jwbanning-gmail - 12/7/2011 3:28:39 PM RE:Use search box in custom table Within my site I am pulling content in a Custom Table to dynamically populate an accordion on several page according to the Where clause that is generated. What I would like is to index the content that is in the table. But when I go to set up the index on custom table, no tables are available to select. See image.


Kentico Support	kentico_jurajo - 12/8/2011 2:41:52 AM RE:Use search box in custom table Hi, What is the custom table configuration in your CMS? Is the custom table assigned to appropriate site? Best regards, Juraj Ondrus


Member	jwbanning-gmail - 12/8/2011 9:34:14 AM RE:Use search box in custom table Yes. Within the custom table configuration, under the sites tab, the site is assigned to the table.


Kentico Support	kentico_jurajo - 12/10/2011 2:17:00 AM RE:Use search box in custom table Hi, Thank you for letting us know about this issue. Regrettably, this seems to be a bug in the current version. I'm very sorry for this inconvenience. We will try fix it in the next version or in the next hotfix package for this particular Kentico CMS version. Best regards, Juraj Ondrus