Magento DB Collection generate error on UNION

Question

I've try to resolve this issue many hours but end up with no luck.

Here is the senario:

I have a store locator and have 2 types of dealers. Master and General. I need to list Master dealer first and General Dealers 2nd. Best solution is to use UNION in collection

 $cloneSelect = clone( $collection1->getSelect() ); $collection1->getSelect()->reset()->union( array( "( ". $cloneSelect ." )", "( ". $collection2->getSelect() ." )", ) );

When I view $collection->getSelect()->__toString() this generate ( $collection1 ) UNION ( $collectio2 )

but when I apply $collection1->getSize() or any method it generate following error.

No table has been specified for the FROM clause

I know it generate this error becouse $collection need to have from clause, If that's the case dose anyone have IDEA how to do union and get collection

Thanks

Show the whole SQL please.

Amasty
– Amasty

2014-07-24 14:55:32 +00:00
Commented Jul 24, 2014 at 14:55 — Amasty
– Amasty, Commented Jul 24, 2014 at 14:55

Amasty · Accepted Answer · 2014-07-24 14:56:12Z

2

May be you can resolve it by sorting results? Like order by if(master_condition, 1, 0)

answered Jul 24, 2014 at 14:56

Amasty

6,2001 gold badge24 silver badges59 bronze badges

Add a comment |

Fabian Blechschmidt · Accepted Answer · 2014-07-24 15:15:03Z

2

Did you try:

$select = $collection1->getSelect()->union($collection2->getSelect());

answered Jul 24, 2014 at 15:15

Fabian Blechschmidt

35.4k8 gold badges76 silver badges183 bronze badges

Add a comment |

Francesco Salvi · Accepted Answer · 2016-05-23 13:48:53Z

I was having this problem when using union in the Widget_Grid block "_prepareCollection()" method, that in the process calls the getSize() method you mentioned.

I solved it by using a third auxiliary collection (of which I only selected one key field), and then joining it with my "united" collections on that same key.

Stack Exchange Network

Magento DB Collection generate error on UNION

3 Answers 3

Hot Network Questions

Magento DB Collection generate error on UNION

3 Answers 3

Related

Hot Network Questions