Friday, May 20, 2005

Posting - Posting - Channel Relationship

Everyone knows that there can be relationship between posting - posting (connected postings) and posting - channel (patent of the posting). But how they are really connected? To understand that, we must have a look at MCMS database schema.

All the objects in MCMS are referred as Nodes in database level. If we take a node of a posting, it will have NodeGuid(Guid of the posting), ParentGuid and FollowGuid. Each node has a type. Type 16 can be a page object or a Posting object. If the IsShortcut value is 1 then the item is a Posting. If it is 0 then it is a Page object. Placeholders are bound to the Page objects. The FollowGuid of the Posting Object points to it's underlying Page object. (Thanks for the clear explanation Stefan!)

  • Posting-Posting

    So all the connected postings will have the same FollowGuid. Because placeholders are bound to the Page objects (IsShortcut=0), connected postings will have reference to the same placeholders.

  • Posting-Channel

    All the posting will have a ParentGuid which are the Guids of the channels. So relationship between posting and channels are maintained via this. So until ParentGuid gets changed, the relationship will be always there.

As a conclusion, Change to any - other than these Guids and IsShortcut, won’t change the relationship. Which means renaming channels, postings wont change relationship.

N.B: This blog is only to make a clear understanding on how postings and channels are related. Handling MCMS database directly or using any undocumented API to handle the database will break the Microsoft support boundary - don't do that.

24 Comments:

Anonymous Stefan Goßner [MSFT] said...

Hi Chester,

not completly true.
Each node has a type. Type 16 can be a page object or a Posting object. If the IsShortcut value is 1 then the item is a Posting. If it is 0 then it is a Page object.
Placeholders are bound to the Page object. The FollowGuid of the Posting Object points to it's underlying Page object.

It would be great if you could set the last sentence in bold red. ;-)

Cheers,
Stefan

5:19 PM  
Blogger Chester said...

Hi Stefan,

I've modified my post. Thanks for making it more clear :)...

As per requested, I've made it in bold-red!

Cheers,
Chester

6:32 PM  
Anonymous Stefan Goßner [MSFT] said...

Hi Chester, you might want to correct the typo: IsSortcut should read IsShortcut.

Cheers,
Stefan

7:46 PM  
Blogger Chester said...

Hi Stefan,

Changed :)

Cheers,
Chester.

7:21 AM  
Anonymous Anonymous said...

try visit your site in Firefox...

2:32 PM  
Blogger Chester said...

I checked it in Firefox and it looks fine... Any problem?

Cheers,
Chester.

2:53 PM  
Anonymous cbretana said...

chester,

Thanks so much! this has been driving me crazy. Could you also add a short comment (if you know) about revisions ?

i.e., are revisions tracked against Pages, or against Postings? Are Placeholders changes also tracked for revisions ? And is all this also done in the node table?

11:25 PM  
Blogger Chester said...

Hi,

Actually revision is also a new page object - bounded to a new set of placeholders. For any posting, there will be only one posting object in database - but can have any number of page objects.

Cheers,
Chester.

1:32 PM  
Anonymous cbretana said...

In your blog, you say

"FollowGuid of the Posting Object points to it's underlying Page object." and ...

"So all the connected postings will have the same FollowGuid"

That implies that Page object is parent of the Posting Object(s),

So your comment above that
"For any posting, there will be only one posting object in database - but can have any number of page objects." can't also be true.. It is saying that Page object is CHILD of Posting object.

12:26 AM  
Anonymous cbretana said...

In playing around with the actual data in the Node table, I have discovered that there are multiple Nodes with type=16, IsShortCut =1, and the same FollowGuid. But there seem to be, potentially up to two nodes with that NodeGuID(= to common FollowGuid), one with ApprovalStatus = 0, and one with ApprovalStatus = 1.

But I do not see any relationship or indication of where nodes might be created to represent Historical revisions...

4:14 AM  
Blogger Chester said...

Sorry, I took more time to reply as I went on a vacation and came back today :).

There was a mistake in my previous statement (I was saying about published one with unapproved one). For revision histories, they have a node which points to its page object with ArchiveSourceGuid.

11:31 AM  
Blogger Tanya Roy said...

This comment has been removed by the author.

3:00 PM  
Blogger Tanya Roy said...


This is really sweet! Just wonderful post written by you. Thank you for your kind post...Impressive work…Independent Bangalore Escorts

3:01 PM  
Anonymous Escorte de Lux said...

Escorte Romania, Ghid de Bucuresti, dame de companie din Romania, fete tinere, studente, fetite blonde, brunete sau roscate, femei rafinate dar in acelasi timp focoase, escorte verificate cu imagini reale si descrieri detaliate disponibile pentru intalnire de scurta sau de lunga durata, escorte in compania carora te vei simti minunat - EscortGuide.ro

9:12 PM  
Blogger Sandeep saini said...

Ludhiana Escorts Service
Ludhiana Escort Service
Ludhiana call girls
Ludhiana Female Escorts
call girls in Ludhiana
Ludhiana Escorts Agency
Ludhiana Independent Escorts
Escorts in Ludhiana
Escorts Service in Ludhiana
VIP Escorts in Ludhiana
Independent Escorts in Ludhiana
Escorts in Ludhiana
Escorts Agency in Ludhiana
VIP Escort in Ludhiana
Ludhiana Escorts Services
Ludhiana escorts
Ludhiana escort

4:57 PM  
Blogger Cirali said...

Ludhiana Escorts Service
Ludhiana Escort Service
Ludhiana call girls
Ludhiana Female Escorts
call girls in Ludhiana
Ludhiana Escorts Agency
Ludhiana Independent Escorts
Escorts in Ludhiana
Escorts Service in Ludhiana
VIP Escorts in Ludhiana
Independent Escorts in Ludhiana
Escorts in Ludhiana
Escorts Agency in Ludhiana
VIP Escort in Ludhiana
Ludhiana Escorts Services
Ludhiana escorts
Ludhiana escort

1:36 PM  
Blogger Sofia shah said...

Chandigarh Call girl
Chandigarh Call girls
Call girl in Chandigarh
Call girls in Chandigarh
Chandigarh Call girls service
Chandigarh Call girl service
Call girl service in Chandigarh
Call girls service in Chandigarh
Chandigarh independent Call girls
Chandigarh independent call girl
Independent Chandigarh call girl
Independent Chandigarh call girls
independent call girls service in Chandigarh
Independent Chandigarh call girl service

6:55 PM  
Blogger chandigarhcallgirls said...

A larger a phase of them provides picked Chandigarh independent escort from their very own specific tendencies for satisfying libidinal craving and erotic appetite. Because the closing effects of it, they have selected it as their low maintenance employment of leisure spending and prevailing a little sum right today. In this manner, their dedication and energy ranges are better than the rest. This is certainly the objective you should get the correct pleasure of this diversion.
Chandigarh escorts
Escort in Chandigarh
Escorts in Chandigarh
Chandigarh escort
Escorts service in Chandigarh
Escort service in Chandigarh
Chandigarh escorts service
Chandigarh escort service
Chandigarh call girls
Chandigarh call girl
Chandigarh independent escorts
Independent escorts in Chandigarh
Chandigarh vip escort
Chandigarh female escorts
Chandigarh female escort
vip escorts in Chandigarh
female escorts in Chandigarh
Chandigarh Call Girls

2:21 PM  
Blogger Desinasha said...

You will find people that poverty from relationship girls who've types in addition to varied physique gives to enjoy the service also. But relationship Company offers most kinds of Chandigarh Escorts service who are able to transportation the right appreciated relationship services. There are many kinds of Escorts include university girls, actresses and the versions etc. They're most information to exhibit numerous components. Additionally they starvation to move using individuals who appear lively and there's zero refutation on the part.
Desinasha
Chandigarh escorts
Escort in Chandigarh
Escorts in Chandigarh
Chandigarh escort
Escorts service in Chandigarh
Escort service in Chandigarh
Chandigarh escorts service
Chandigarh escort service
Chandigarh call girls
Chandigarh call girl
Chandigarh independent escorts
Independent escorts in Chandigarh
Chandigarh vip escorts
Chandigarh vip escort
Chandigarh female escorts
Chandigarh female escort
vip escorts in Chandigarh
female escort in Chandigarh
Chandigarh vip escorts
Chandigarh vip escort
Chandigarh female escorts
Chandigarh female escort
vip escort in Chandigarh
female escorts in Chandigarh

3:20 PM  
Blogger Sandeep saini said...

Hi Guy, I'm Impartial Escorts in Ludhiana and Divya Rana. Escorts in Ludhiana Girls could be flighty. A couple of days they have to venture out and various occasions in Ludhiana using call girls, then you definitely are in the best location.
Divyarana
Ludhiana Escorts Service
Ludhiana Escort Service
Ludhiana call girls
Ludhiana Female Escorts
call girls in Ludhiana
Ludhiana Escorts Agency
Ludhiana Independent Escorts
Escorts in Ludhiana
Escorts Service in Ludhiana
VIP Escorts in Ludhiana
Independent Escorts in Ludhiana
Escorts in Ludhiana
Escorts Agency in Ludhiana
VIP Escort in Ludhiana
Ludhiana Escorts Services
Ludhiana escorts
Ludhiana escort
escorts in Ludhiana
Ludhiana escorts
Ludhiana escort service
Ludhiana escorts service
escort in Ludhiana

6:23 PM  
Blogger Neha said...

As this helps to ensure that number payee particulars seem in your money or charge card claims nevertheless, in order to stay as unknown as you are able to you'll better-off producing your cost by money. Welcome towards the unique elegance of gold exotic shorelines and the huge area of the obvious orange ocean, the green high hills and also the imposing great forts. Hi5chandigarhescorts
Chandigarh Escorts
Chandigarh Escort
Escort In Chandigarh
Escorts In Chandigarh
Escorts service in Chandigarh
Escort service in Chandigarh
Chandigarh Escorts service
Chandigarh Escorts service
Chandigarh call girls
Chandigarh call girl
Call girl in Chandigarh
Chandigarh vip escort
Chandigarh independent escorts
Independent escorts in Chandigarh
Female escorts in Chandigarh
Vip escorts in Chandigarh

5:20 PM  
Blogger Desi Nasha said...

This is actually the relationship administration in Chandigarh. The culture includes a common variety of pleasant enchanting and tantalizing relationship youthful Escorts service in Chandigarh. Around you see therefore dependably a great-searching wherever you had been unpleasant for relationship youthful female that you simply the administration suggestion. Placement frequently a youthful female that is relationship having a relationship culture that is small. Below function unbiased educated top quality relationship women. A Lady of the well known anyone must extend precisely the conduit you've required.

3:58 PM  
Blogger Gurpreet kaur said...

There are many visitors who are having therefore very much exciting encounters which make them keep coming to the wonderful city of Chandigarh. Female escort in Chandigarh is offering the quality escorting solutions as it is usually the company where one would find sufficient of possibilities in terms of choices to discover the best take to provide you.Chandigarh escorts
Escort in Chandigarh
Escorts in Chandigarh
Chandigarh escort
Escorts service in Chandigarh
Escort service in Chandigarh
Chandigarh escorts service
Chandigarh escort service
Chandigarh call girls
Chandigarh call girl
Chandigarh independent escorts
Independent escorts in Chandigarh
Chandigarh vip escort
Chandigarh female escorts
Chandigarh female escort
vip escorts in Chandigarh
female escorts in Chandigarh
Chandigarh Call Girls

10:21 PM  
Blogger Sandeep saini said...

Ludhiana Female Escorts I'm broad minded and bold and similar to the brand new expertise's type. I'll have the ability to cordially encouraged one to my location or I'll have the ability to fulfill anyone regarding affiliate relaxing visit at your Ludhiana esorts that are selected that's appealing for just about any profile vip that is hi Ludhiana escorts.Ludhiana call girls

8:57 PM  

Post a Comment

<< Home