How to use UNION query with jDatabase

[mousebat]

Hi

This is a good one - can't seem to find an example of how to use

Code: Select all

$query->union

in getListQuery. At the moment I'm doing it old school and having to write the whole query out in the

Code: Select all

$query

variable.

I want to select similar data from different tables and use the join function that now exists in the query object.

SELECT field1,field2 FROM `#__mycomponent_table1` where field1 = 0
UNION
SELECT field1,field2 FROM `#__mycomponent_table2` where field1 = 0

etc...

[pe7er]

Check Joomla 3.2 /administrator/components/com_finder/helpers/indexer/query.php line 1269-1296

The union function is defined in the library file: /libraries/joomla/database/query.php line 1540

[alwarren]

I haven't been able to get union to work at all using query objects. It seems to be buggy. There are some tracker items about it.

[sravanvaranasi]

Thanks a lot pe7er. That worked for me.

[Bakual]

There is a PR for this: https://github.com/joomla/joomla-cms/pull/2735

Testing welcome