Skip to main content ↑ ↓
Topic: replacing the list page query by a complete custom one (Read 1618 times) previous topic - next topic

replacing the list page query by a complete custom one

To publish my table, i need the query:
SELECT
 *
FROM
  `klanten`
  LEFT OUTER JOIN `generators` ON (`klanten`.`klant_gen` = `generators`.`gen_id`)
  LEFT OUTER JOIN `businesses` ON (`klanten`.`klant_bs` = `businesses`.`bus_id`)


And i need the outer joins to also publish records from klanten that have no matching records in genersators and/or businesses.

I ve been looking around but cant find a way to use the outer. i can do the normal left and right in the 'default query configuration' (which implies there is a 'not default or special'  one too. Cant find it ...thanks for help

What i cant find either, are posibilities to manipulate queries or parameters in 'before show''before publish' etc clauses. please help