Demo: Listing Docs including one or more TVs

craftsmancoding / query

Query offers a Snippet interface for querying any database collection, e.g. as an alternative to getResources

8 stars 0 forks source link

Demo: Listing Docs including one or more TVs #3

Open fireproofsocks opened 10 years ago

fireproofsocks commented 10 years ago

Screencast again...

adamwintle commented 9 years ago

I'm trying to figure this out, can you post an example?

fireproofsocks commented 9 years ago

Hmm... looks like there might be a bug here. The generated query comes out in part:

FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvars` `TemplateVars` ON `modResource`.`id:template` = `TemplateVars`.`contentid:templateid` ORDER BY `modResource`.`id` ASC

What is going on with the joins?

Oiy, this is a wormhole.