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!