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

Forums / Developing with Sitefinity / Changing Document Library Upload Dates

Changing Document Library Upload Dates

5 posts, 0 answered
  1. Armysniper
    Armysniper avatar
    126 posts
    Registered:
    03 Mar 2005
    15 Oct 2009
    Link to this post
    I have a bunch of documents that were uploaded by my content authors that are not in the right order. They were uploaded at the same time but each content piece is a newsletter for a specific month and year. Which table in the database contains the actual items stored in the Images and Documents module so I can manually change the "upload" date to the date of true publication.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    15 Oct 2009
    Link to this post
    Hi Armysniper,

    The following table [sf_CmsContentVersion] contains DateCreated value of Images and Documents content items.

    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.
  3. Charles Lee
    Charles Lee avatar
    5 posts
    Registered:
    16 Jul 2009
    25 Nov 2009
    Link to this post
    It appears that this table identifies the various documents by GUID (in the ID column). What column(s) in which table(s) do I join this GUID column to in order to identify a particular document by a more friendly name?

    For example, if a document is called "September 2009 Newsletter", how do I identify the GUID in the ID column of the [sf_CmsContentVersion] table that corresponds to this document?

    Thanks
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    26 Nov 2009
    Link to this post
    Hi Charles Lee,

    You need to create inner joing between sf_GCMetaData and sf_CmsContentVersion. Sample query:

    select gc.KeyValue, gc.ShortText
    from sf_GCMetaData as gc
    INNER JOIN sf_CmsContentVersion as cc
    on gc.ContentID = cc.ID
    WHERE  gc.ContentID ='48C617C4-EA32-428B-AAC8-19CE9191D1A8' AND gc.KeyValue = 'Name'


    Best wishes,
    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. Charles Lee
    Charles Lee avatar
    5 posts
    Registered:
    16 Jul 2009
    02 Dec 2009
    Link to this post
    Thanks - that worked great.
Register for webinar
5 posts, 0 answered