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.