Microsoft Content Management Server - Searching CMS Database for specific channel names

This is Interesting: Free IT Magazines  
Home > Archive > Microsoft Content Management Server > February 2006 > Searching CMS Database for specific channel names





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Searching CMS Database for specific channel names
Angela

2006-02-21, 7:48 am

Hi..we are trying to create an events structure and search..we need to have a
general events channel plus have specific events channels nested under
service channels in a different channel..the problem is how do we search from
the general channel and include the events under other channels
efficiently...can we do a search on the cms database to return posting
details of channels called a specific name..ie events..or can we search for
specific posting types ie all postings created via the events
template...channel structure example shown below....

Events
Services> Townships>Events

thanks for any help in advance
Angela

Mei Ying [MVP]

2006-02-22, 2:47 am

Hi

Well, if your site is reasonably small, you could set custom properties on
the channels/postings and use the Searches.GetChannelsByCustomProperty() or
Searches.GetPostingsByCustomProperty() to grab the relevant items.

But if you've got a huge site, these methods will take a long time to
retrieve results. In such a case, its probably best to build an index table.
Either use an out-of-the box search engine (if you've already puchased one)
or external SQL tables, populating them each time a posting is approved.


--
regards
Mei Ying
---
Blog: http://meiyinglim.blogspot.com
Book: http://www.packtpub.com/book/mcms
Contact: meiyinglim@hotmail.com
---


"Angela" wrote:

> Hi..we are trying to create an events structure and search..we need to have a
> general events channel plus have specific events channels nested under
> service channels in a different channel..the problem is how do we search from
> the general channel and include the events under other channels
> efficiently...can we do a search on the cms database to return posting
> details of channels called a specific name..ie events..or can we search for
> specific posting types ie all postings created via the events
> template...channel structure example shown below....
>
> Events
> Services> Townships>Events
>
> thanks for any help in advance
> Angela
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com