Umbraco Content picker and what happens in the database


Using the Content picker to link two pieces of “content” is very easy to do in the Umbraco backend. However, what happens in the back-end, although not hard, will take you some time to figure out. Hopefully, this will save someone some time out there.

The scenario was this:

In the members section, we had a content picker which would link to a section in the content tree. What I had to do was to provide a database query on how to get the “Content” node id to which the member was linked given the loginName. Here is the query I came up with:

In this case, we needed to get the associated content node ID given the LoginName. However, the cmsPropertyData would appear to be the linking table.

It’s not revolutionary but it’s simple when you know.

Advertisements
Tagged with:
Posted in Umbraco blogs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: