More in this section

Database

2 posts, 0 answered
  1. rmp
    rmp avatar
    13 posts
    Registered:
    26 Jun 2007
    13 Jul 2007
    Link to this post

    Can anybody help me come up with a SQL query that will find the most recent versions (i.e. Live) of controls in the sf_CmsControlProperty table?

    I'm having trouble knowing which versions of files I'm looking at, and I'd like to keep the history intact.

    Thanks!

  2. Bob
    Bob avatar
    330 posts
    Registered:
    30 Dec 2016
    16 Jul 2007
    Link to this post
    Hello Mark,

    I already answered your question in the other thread but since it is in the prerelease section I will post the answer here again.

    Here is the SQL statement:
    SELECT * FROM sf_CmsControlProperty  
    INNER JOIN sf_CmsCtrlLinks   
      ON sf_CmsControlProperty.ControlID = sf_CmsCtrlLinks.ControlID  
     

    sf_CmsCtrlLinks is the table that makes many-to-many relation to live pages. Relations to history are kept in table sf_StagedCtrlLinks.

    Sitefinity currently does not make use of many-to-many relation between pages and controls but this is planed for future features. When dropping a control on a page you will be able to specify it as reference to a control form other page instead of creating new instance.

    Kind regards,
    Bob
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
2 posts, 0 answered