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

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -