I have an interesting application for Content Profile, CCK and Views that would really help our community television station cement better use of our users' profiles. Here it is:

In abstract, I want to make views that return results based on matches in field values between fields held in Content Profile nodes and another custom nodes.

Our Content Profile nodes ask for a user's full name (first and last one field). This is a CCK field and we would use this field as a to match values in other nodes.

Separately, we publish nodes that represent the scheduled play time of a program. The content type is called Program, it has Date module fields as well as other custom fields. The Program nodes also contain a CCK field which stores the full name of the person who owns the television show.

In the case we have site users who are also owners of programs at our television schedule, we want that user's Content Profile node to display a view that is a list of the schedule of the programs on our channels.

I don't know how to first beat out the right relationship between those two fields. If anyone has any good ideas on how to make this relationship work, then I can handle the rest. I don't have a good head for relational database stuff, unless we were working in Filemaker, which sucks.

Thanks!

Comments

seaneffel’s picture

Title: Help in creating relationships to profile node fields? » Help in creating relationships to Content Profile fields?