Overriding Views queries, Data module, etc.

Events happening in the community are now at Drupal community events on www.drupal.org.
tommyk's picture
Posted by tommyk on November 15, 2011 at 10:38pm

I'm working on a project in Drupal 6 where I am importing via Feeds what is basically a join table with node references using the Data module and I'm trying to display some of the relationships with Views.

I have a feeling that the data_node module that is part of the Data project isn't quite mature because I'm having issues with the SQL that comes out of the Views that are generated.

I don't fully understand all the table aliasing that is going on, but I've been able to take the Views SQL and tweak it so I get results in phpMyAdmin and then use hook_views_pre_execute() in a custom module to override the queries.

My Views aren't coming out exactly like I want still and I was hoping someone might have some experience working with some of these pieces.

I'm happy to post more on this thread or I'll be at the meetup tonight and at the end of the month too.

Tommy

Categories: ,

Comments

Details

Posted by rjbrown99 on November 17, 2011 at 5:33am
rjbrown99's picture

Can you provide some more details? Happy to help if I can. Things I would be curious about...

How is feeds configured? Parsers, processors, etc. Are you directly importing to CCK fields and then doing something to create node references? Or feeding directly in to node reference fields? Sounds like the data module is buried in there somewhere as well (which as far as I know has no D7 port or plans yet.)

Finally, what type of view is it? Nodes? Views 2.x or 3.x? Are you using search at all with the views for the nodereferences?