More in this section

Database

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
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