Combine two views into one view

Question

I have two views that I would like to combine into one.

The first view shows all items of X where company ID = Y. This is to give preferential sort to the client first, and then everyone else.

So I created a second view, all items of X, where company ID != Y.

I created it as an Attachment to attach to the first view, but I don't think I got the intended result.

How can I combine these views so the first view results are listed first, and then the second view is too, using the same pager, filters, and arguments?

Is there any way of achieving this without programming it?

Answer 1

From a MySQL point of view, the order-by-field syntax would be the appropriate way to handle this. Example:

SELECT * FROM tickets ORDER BY FIELD(priority, 'High', 'Normal', 'Low');

It would be great if there is a module that add this kind of functionality to Views, but AFAIK, it does not exist.

If you want to solve this without programming, I think you can use the rules module to automatically set the 'sticky' checkbox on nodes where company ID = Y. With that in place, you can order the View on the sticky value.

Answer 2

for drupal 5 there was views union. Someone started something for D6, but I don't know how far they got.

http://drupal.org/node/275162

Answer 3

Along the lines of the 'sticky' idea, if you didn't want to override that, maybe you could add a checkbox field to the company type -- isClient. Make it false for everyone except the client, and sort by that.

I haven't done this, but maybe you need to create both versions as attachments, and attach them both to another display...?

Answer 4

Create the second view as an attachment and attach it to first.
Set all Inherit arguments, Inherit exposed filters and Inherit pager to Yes.

Answer 5

how is the client parameter passed to the view? as an url argument? if so, you can create your second view like i outline here and then select the exclude the argument option on the appropriate location.