More in this section

Forums / Developing with Sitefinity / Where is stored module´s fields in SQL DB?

Where is stored module´s fields in SQL DB?

5 posts, 0 answered
  1. Ruben Herrera
    Ruben Herrera avatar
    38 posts
    Registered:
    10 Jul 2009
    09 Sep 2009
    Link to this post
    Hi, we have our own custom module with some fields.

    I need to get some specific fields (by SQL query) but I don´t know where is stored.

    For example I can see in "sf_CmsCategory" table modules and categories, where I can find each field?

    Regards
    Rubén
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    09 Sep 2009
    Link to this post
    Hi Ruben Herrera,

    If your module is GenericContent based it should use the common tables for storing the data.

    [sf_CmsCategory] - stores data for all categories
    [sf_CmsComment] - stores data for all commenst
    [sf_CmsContentBase] - stores data for all content items

    In the tables above your module provider can be found under Application column. Let us know if there is anything else that we can do for you.

    Greetings,
    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.
  3. Ruben Herrera
    Ruben Herrera avatar
    38 posts
    Registered:
    10 Jul 2009
    09 Sep 2009
    Link to this post
    Yes, It is GenericContent based, it´s http://www.sitefinity.com/blogs/ivan/posts/09-03-11/sample_generic_content_based_module_products_module.aspx based.

    For example:

    Name: John
    Address: First Avenue
    Country: EEUU
    Category: Someone

    I can´t find "Country" in  [sf_CmsCategory], [sf_CmsComment] or [sf_CmsContentBase] , is this field stored like xml field maybe?

    Thanks
    Rubén
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    09 Sep 2009
    Link to this post
    Hello Ruben Herrera,

    All these fields looks like as a  profile data that is kept under [telerik_UserMetaInfo] or metadata that is stored under [sf_GCMetaData].

    Regards,
    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.
  5. Ruben Herrera
    Ruben Herrera avatar
    38 posts
    Registered:
    10 Jul 2009
    09 Sep 2009
    Link to this post
    Great! Thanks!!
Register for webinar
5 posts, 0 answered