[support] Views subquery?

[John Fletcher]

Nodequeue is a nice module that does this sort of thing too.

The second and third nodes shown on the right at www.cai.org are grabbed
from "nodequeues".  The nodequeues are embedded in the front page template.

Regards,
Fletch.

-----Original Message-----
From: Christopher M. Jones 
Sent: Monday, 1 September 2008 5:28 PM
To: support at drupal.org
Subject: Re: [support] Views subquery?

Thanks for the help.

William Smith wrote:
> In that case your best bet is probably to create a page template file and
> render your Views programatically.  Unfortunately, I'm not developing with
> Drupal 6 yet, and haven't checked out the API changes in Views 2 so I
can't
> really advise further.  In D5, you would do something like "print
> views_build_view('embed', views_get_view('yourviewname'), $view_args,
FALSE,
> $limit);" and that may or may not still work in D6.
> 
> 
> On Mon, Sep 1, 2008 at 10:44 AM, Christopher M. Jones <
> cjones at partialflow.com> wrote:
> 
>> Yes, it looks like that would be the solution. But I forgot to mention
>> I'm running 6.x. Panels doesn't have a 6.x release. Any other
>> possibilities?
>>
>> William Smith wrote:
>>> It sounds like what you need is the panels module (
>>> http://drupal.org/project/panels)
>>>
>>> On Mon, Sep 1, 2008 at 6:10 AM, Christopher M. Jones <
>> cjones at partialflow.com
>>>> wrote:
>>>> I want to construct a page that displays a number of nodes. Each node
is
>>>> of a different type, as follows:
>>>>
>>>> Node 1: Page content, by node id.
>>>> Node 2: The most recent node assigned to specified taxonomy term
>>>> Node 3. Page content, by node id.
>>>>
>>>> This is an 'about' page that details a project (node 1), gives the
>>>> project's status (node 2), and explains the project's mission (node 3).
>>>> The first and third nodes don't get updated much, but the third node
>>>> needs to be the most recent update, with a history of updates viewable
>>>> elsewhere on the site as e.g., a category of blog posts, or some other
>>>> content type I may decide is more appropriate.
>>>>
>>>> For the first and third nodes, I can simply pass ids as view
parameters.
>>>> But I'm stuck on how to incorporate the second node. I guess what I'm
>>>> looking for is a way to do a view of views, or to create a view with a
>>>> subquery.
>>>>
>>>> Ideas?
>>>> --
>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>