Combine two views into one view

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 vie开发者_Go百科w is too, using the same pager, filters, and arguments?

Is there any way of achieving this without programming it?

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.

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...?

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

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

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.

usually the easiest way to achieve this is with a small hook_query_alter, but that requires a small amount of programming.

A little bit later... but I've found a better solution using only the Views module:

1. Create a Block View with that shows the first list that you need ("all items of X where company ID = Y")
2. Create another View that must be a "Page view" with the second list (all items of X, where company ID != Y)
3. In the "HEADER" settings of this second view, click "Add" and select "Global: View area".
4. In the "View to insert" list, select the first you have created (and check "Inherid contextual filters" if you are using it)

And that's it!