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

Forums / Developing with Sitefinity / Finding Categories for News Articles

Finding Categories for News Articles

2 posts, 0 answered
  1. Ben
    Ben avatar
    18 posts
    Registered:
    12 May 2008
    21 Sep 2009
    Link to this post
    My goal is to get a hierarchy of categories and subcategories for existing news articles.  Given that the articles themselves are stored in the sf_CmsTextContent tables, and the categories are contained in sf_CmsCategory, where in the database is the link between the two?  Given a row in sf_CmsTextContent, how do I navigate to the appropriate row in sf_CmsCategory?
       Thanks,
          Ben Furino
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    21 Sep 2009
    Link to this post
    Hi Ben,

    Category is a metadata, so the relation between a category and content item can be found under sf_GCMetaData table. We suggest using the API, because there are many  dependencies in the database and changing any table could break your website. You can find the following link useful: Categories Overview.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
2 posts, 0 answered