|
Home > Archive > Microsoft Content Management Server > February 2007 > Fillter Postings by User defined Date
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Fillter Postings by User defined Date
|
|
| jamiebrohan@gmail.com 2007-02-12, 1:16 pm |
| I'm trying to create a list page which will contain hyperlinks to
separate list pages which will filter postings by date.ie
An annual archive list:
<a href="..">2006<a>
<a href="..">2005<a>
<a href="..">2004<a>
Requirement: When you click on 2006 all the 2006 postings in a given
channel will be returned.
Problem I have is that all the archived postings (news items) will be
newly added, and that will mean all the postings' inbuilt mcms date
properties will refer to 2007.
What is the recommended way to associate a new date (say 2004) with a
new posting.
I thought of creating a new table within the mcms database which could
hold a required date and the postings nodeId. Is this safe or might it
cause issues with the mcms database?
Is it safe to put into a separate second database?
Or is there another alternative?
Again, I'm looking for advice on how to setup news items from previous
years which I can then filter by date.
Many thanks
| |
| Stefan Goßner [MSFT] 2007-02-13, 7:19 am |
| Hi Jamie,
I would suggest to set the StartDate of the posting to the desired date.
Then use SortByStartDate to get a sorted list.
btw: never ever do any modification to the MCMS database! This will break
the support boundaries for MCMS.
If you need a new table create it in a separate database but not in the one
used by MCMS.
Cheers,
Stefan
<jamiebrohan@gmail.com> wrote in message
news:1171301813.892487.98480@l53g2000cwa.googlegroups.com...
> I'm trying to create a list page which will contain hyperlinks to
> separate list pages which will filter postings by date.ie
>
> An annual archive list:
> <a href="..">2006<a>
> <a href="..">2005<a>
> <a href="..">2004<a>
>
> Requirement: When you click on 2006 all the 2006 postings in a given
> channel will be returned.
>
> Problem I have is that all the archived postings (news items) will be
> newly added, and that will mean all the postings' inbuilt mcms date
> properties will refer to 2007.
> What is the recommended way to associate a new date (say 2004) with a
> new posting.
>
> I thought of creating a new table within the mcms database which could
> hold a required date and the postings nodeId. Is this safe or might it
> cause issues with the mcms database?
> Is it safe to put into a separate second database?
>
> Or is there another alternative?
>
> Again, I'm looking for advice on how to setup news items from previous
> years which I can then filter by date.
>
> Many thanks
>
| |
| jamiebrohan@gmail.com 2007-02-14, 7:18 am |
| Hi Stefan,
Thank you for your help and advice.
I had tried to use the StartDate for postings but when I went to set
to a date from before 2007 and was getting a warning saying I couldnt.
Figured out I had to change the StartDate in the channels beginning
with the root channel.
Thanks again,
Jamie
| |
| Stefan Goßner [MSFT] 2007-02-14, 7:18 am |
| Hi Jamie,
you need to ensure that the start date of the channel holding these postings
is older than the start date of the items.
This is required as you cannot have a start date in a channel older than the
channel itself.
In addition: using Site Manager you cannot set a date before installing
MCMS.
But using the API this will work.
Cheers,
Stefan
<jamiebrohan@gmail.com> wrote in message
news:1171455702.494125.59040@v33g2000cwv.googlegroups.com...
> Hi Stefan,
> Thank you for your help and advice.
>
> I had tried to use the StartDate for postings but when I went to set
> to a date from before 2007 and was getting a warning saying I couldnt.
> Figured out I had to change the StartDate in the channels beginning
> with the root channel.
> Thanks again,
> Jamie
>
|
|
|
|
|