Forums

Home / Developer Network / Forums / Sitefinity Older Versions (3.x): 3.x Pre-release forums (retired) > Generic Content Find and Replace

• bnye Master

  Posted on May 11, 2007 (permalink)

  I don't know if there is much of a demand for this. However, I came accross a scenario where it would be cool to do a global find and replace to change urls throughout a site.
  
  Sincerely,
  
  Ben

  Reply

• bnye Master

  Posted on May 11, 2007 (permalink)

  This script worked great for this:
  
  

  UPDATE    sf_CmsControlProperty

  SET              Value = REPLACE(Value, '/VirtualDirectory/', '/')

  WHERE     (Value LIKE '%/VirtualDirectory/%')

  
  Perhaps this will help someone.
  
  Sincerely,
  
  Ben

  Reply

• bnye Master

  Posted on May 14, 2007 (permalink)

  Oh yes but don't forget the Shared Content you must also run:
  
  

  UPDATE    sf_CmsTextContent

  SET              Content = REPLACE(Content, '/VirtualDirectory/', '/')

  WHERE     (Content LIKE '%/VirtualDirectory/%')

  
  Hope that helps,
  
  Ben

  Reply

• rmp

  Posted on Jul 13, 2007 (permalink)

  Thanks for the post Ben.
  

  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!
  

  
  

  Reply

• Bob Bob

  Posted on Jul 16, 2007 (permalink)

  Hello Mark,
  
  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.
  
  I hope this helps. Don’t hesitate to ask if you need further information.
  
  Best wishes,
  Bob
  the Telerik team

  
  Instantly find answers to your questions at the new Telerik Support Center

  Reply

• rmp

  Posted on Jul 16, 2007 (permalink)

  Thanks Bob - that was what I needed.
  

  Reply

• Zyad Rujeedawa

  Posted on Aug 12, 2010 (permalink)

  Hello,
  
  Has this changed since in the latest sitefinity version ?

  Reply

• Ivan Dimitrov Ivan Dimitrov

  Posted on Aug 12, 2010 (permalink)

  Hi Zyad Rujeedawa,
  
  The latest version of Sitefinity is 4.0 edition, where control properties are stored in [sf_control_properties]. The above post made by Bob is valid if you use Sitefinity 3.7.
  
  All the best,
  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

  Reply

Home / Developer Network / Forums / Sitefinity Older Versions (3.x): 3.x Pre-release forums (retired) > Generic Content Find and Replace