+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Custom Module Database

Custom Module Database

4 posts, 0 answered
  1. Asif
    Asif avatar
    110 posts
    Registered:
    18 Nov 2010
    11 Dec 2010
    Link to this post
    Hi,
    I am using the custom module (Products). I am not sure which table I should access and grab the Product's title. Also I have built the search functionality for user to write keywords and select product's categories and then click on search button.

    Question 1: What will be the table to get Product's title (My guess is table "sf_CmcContentBase" and column "URL")??
    Question 2: For search, How to link table "sf_CmsCategory" with the table I can grab the Product's Title? Because I can't find any categoryId in table "sf_CmcContentBase"
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    11 Dec 2010
    Link to this post
    Hi Asif,

    1. You do not have to use the database and query its tables manually. You can use the Generic Content API - Overview of Generic Content API

    The "Title" is a metakey and its is stored inside sf_GCMetaData

    2. You can create a custom search, actually you can reuse the code from this post Bonus Track Implementing Search Index for Products module

    All the best,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Asif
    Asif avatar
    110 posts
    Registered:
    18 Nov 2010
    14 Dec 2010
    Link to this post
    Hi,
    The scenario is, I am building a news search functionality. There will be a text field where suer can insert the news title and there will be a drop down where all news categories will be displaying. when user will click on Search button then page will show the news related to the selected category. I know I can't write my queries. So, what exactly APIs I should use for this functionality?
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    14 Dec 2010
    Link to this post
    Hello Asif,

    You have to use methods related to Finding Content Items. To filter by category you need to use IMetaSearchInfo filter.

    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
4 posts, 0 answered