By exacube on

I have a content type (DATES) for the Type of Submission and the Due Date for submission. I have another content type (DESCRIPTIONS) with fields/descriptions for the submission (which are associated with each Type of Submission).

In views 2, how do I include the description from the DESCRIPTION content type that is associated with content in the DATES content type?

I tried using Taxonomy, but taxonomy only has one description field, which sucks.
I also watched a video tutorial on Relationships, but I couldn't understand how I could use it.

Any help will be appreciated!

⋅ Categories: Drupal 6.x

Comments

narayanis’s picture

narayanis commented

how do the two content types link to each other? are you using node reference or something like that?

stinky’s picture

stinky commented

subscribe

dekan’s picture

dekan commented

Hola!

I'm running into the same issue:
Content Type 1)
Kind of a clone of the page and is called 'Events' with some custom fields and just holds upcoming events and tradeshows the company is attending.

Content Type 2)
This is a Webform that holds training sessions, signup forms, ... In order to differentiate between an ordinary form and a training session I added fields like (radio buttons) () Training, () Mailing List, () Default .... and a checkbox to see if it's a public training and should appear in lists (or views for that matter).

What I want to do:
Create a view that displays all Events together with Webforms in one list, where the webform.type = 'Training' and webform.public_training = 'on'.

I can definitely check Events and Webforms in the filter but as soon as I add the 'public_training' variable, Views also looks for that in Events (where it doesn't exist) and does't show Events anymore at all.

Is there a way to tell the filter what content type it's supposed to look in for a special variable? Or is my approach completely wrong?

Thanks in advance!
dek

narayanis’s picture

narayanis commented

Your query is a little more complex than what Views can do by default. This leaves a couple of options:

-create two views (one for each content type) and display them both on the page
-use hook_views_query_alter() to modify the WHERE clause of your query. You can rewrite it to filter on public_training for the second content type

vibinano’s picture

vibinano commented

you can use use views php filter to create a filter using your sql query.
check it out it may help.

http://drupal.org/project/viewsphp

ks.yeoh’s picture

ks.yeoh commented

I'm trying join two fields from two content type as well.

Example:-
content type: type_a
text field: text_field_a (unlimited)

content type: type_b
text field: text_field_b (unlimited)

So, I've set the text field as unlimited.

For each content type node I have input like:-
text_field_a:
Test_A1
Test_A2

text_field_b:
Test_B1
Test_B2

Is it possible to create a combine them in Views and get a result like this?
Test_A1
Test_B1

Test_A2
Test_B2

What I'm getting so far is:-
Test_A1
Test_A2

Test_B1
Test_B2