How to fetch pretty advanced relation in Drupal 6 - Views 2? -
i have 3 content types: artist
, artwork
, exhibition
. exhibition has field 'artworks'
(unlimited values). artwork has field 'artist'
(1 value, required).
and there relation can't seem find views: want exhibitions artist ever participated in. means: on artist page, show exhibitions artworks of artist ever in.
the problem (i think) 1 field (exhibition.artworks) has many values. yet artwork.artist has 1 value.
i don't know problem =) it's not working , i've tried million things. @ point, i'll accept writing sql queries, drupal content database incredibly untransparent have no idea query , how.
obviously i'd happiest unhacked views solution, i'm not getting hopes up. experience relations this?
you can build dependent relationships should accomplish this. use relationship (artwork) on exhibition.artworks , relationship (artist) on (artwork).artist
it easier understand you're doing exports of views & content types.
the database structure content types in drupal works follows;
the node base table, nid index. content types have own tables, content_type_xxxxxx single entry fields (that aren't shared among content types) members of table. multiple entry , shared fields own table content_field_xxxxxx. of tables relate on nid field, , multiple entry fields use "delta" indicate entry order.
Comments
Post a Comment