I have many cck content types all having a common shared date field (called activity_date)
What i want is a view that will display data from different nodes for the same date.

This what i did
in views FILTERS - i added node type and selected two such node types (both have shared field activity_date)
in views FIELDS - i selected one field each from each of the nodes (session report from one and activity name from another)

But when i view - grouped by date - while the date comes neatly once at the top (like a header)
the fileds come repeated - it lists both the fields twice (see attached image) - each field blank in each instance.
This would obviously look terrible if i had many fields from each node.

what i want is - under the date - fields 1a, 1b etc from node type 1 and fields 2a, 2b etc from node type 2.

any guidance appreciated

CommentFileSizeAuthor
Clipboard01.jpg13.41 KBratnesh aarohi

Comments

esmerel’s picture

esmerel commented
Status: Active » Closed (fixed)

This issue is a year old, it's likely either resolved or no longer relevant.

charlie-s’s picture

charlie-s commented

I'd like to reopen this issue. I have created 2 content types and shared 1 CCK date field between them. When I create a new View and display this CCK date field while also filtering for the 2nd content type, no data is displayed. I can see in the Views SQL preview that it's attempting to select from the wrong database. Is this an issue within Views or CCK?

dawehner’s picture

dawehner
Primary language German
commented
Status: Closed (fixed) » Active

That's not true. The database prefix is added on the query level of drupal. Drupal does this by replacing the table names manually. That's not something what will be displayed in the preview.

charlie-s’s picture

charlie-s commented

An update to the issue -- I deleted the CCK field from the 2nd content type and refreshed the Views edit screen; the data appeared in the preview and the SQL preview showed that the correct table was being queried.

charlie-s’s picture

charlie-s commented

Thanks for responding so quickly. I'm not following what you're saying. What is the "something" that will/won't be displayed in the preview?

dawehner’s picture

dawehner
Primary language German
commented

It's {table}

After this drupal comes and looks up whether {table} is a shared table and replaces it with the real table name.

charlie-s’s picture

charlie-s commented

I understand that. It doesn't seem to be replacing it with the (correct) real table name for me. In my case, the Views SQL summary was showing:

...
LEFT JOIN content_type_media_series node_data_field_media_date ON node.vid = node_data_field_media_date.vid
...

Where "content_type_media_series" is actually the wrong table. There are no entries in this table that match the content type I filtered for. After deleting the CCK field from the 2nd content type, the View SQL summary showed the correct query:

...
LEFT JOIN content_type_media node_data_field_media_date ON node.vid = node_data_field_media_date.vid
...

Notice the "content_type_media" table join.

kars-t’s picture

kars-t commented
Status: Active » Fixed

Hi

I am closing this issue to clean up the issue queue. Feel free to reopen the issue if there is new information and the problem still resides. If not please make sure you close your issues that you don't need any more.

Maybe you can get support from the local user group. Please take a look at this list at groups.drupal.org.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.