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

Forums / General Discussions / Save Widget data to Custom Table

Save Widget data to Custom Table

5 posts, 0 answered
  1. Joe
    Joe avatar
    3 posts
    Registered:
    21 Oct 2010
    14 Jan 2011
    Link to this post
    What is the best way to save data entered into a custom widget to tables that I created?  Can the page node id be used to retrieve that data for display purposes?  Is there any documentation for this?
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    19 Sep 2016
    20 Jan 2011
    Link to this post
    Hi Joe,

    You have to create a custom data layer that will persist your properties in the table you want. Generally all properties are saved to [sf_control_properties] table of the database by OpenAccessDecorator

    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
  3. Mansoor
    Mansoor avatar
    52 posts
    Registered:
    29 Jul 2013
    02 Dec 2015 in reply to Ivan Dimitrov
    Link to this post

    Hi Ivan,

    Similarly we looking Joe's query. We have some fields like first name,position, amount etc...user enter these information and submit  however we want to store these information in a separate table . how SF provide us easiest way.

    If we want to retrieve these information and display in a grid then we can write a query but where can we write this query.?

     

     

  4. gregory hernandez
    gregory hernandez avatar
    59 posts
    Registered:
    10 Jul 2009
    02 Dec 2015 in reply to Mansoor
    Link to this post

    Hi All,

    Pardon my ignorance. But, i'm curious as to the reasoning behind creating one's own tables vs. getting data from SF generated tables.

    Just trying to learn about that approach and any of its related benefits.

    Thanks in advance,
    Gregory

  5. Nikola Zagorchev
    Nikola Zagorchev avatar
    424 posts
    Registered:
    23 Sep 2016
    07 Dec 2015
    Link to this post
    Hi,

    If it is a widget property, it is saved in the sf_control_properties table and you can query the data from there. If it is designer/widget specific you can use custom designer or other way to persist the data wherever you want.

    http://docs.sitefinity.com/tutorial-extend-sitefinity-s-data-model


    Regards,
    Nikola Zagorchev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
5 posts, 0 answered