[[!getCache? &element=`getResources` &cacheExpires=`9000` &parents=`679,663,641,799,590` &depth=`0` &tpl=`related-article-in-page-listing` &limit=`6` &includeTVs=`0` &includeContent=`0` &showHidden=`1` &tvFilters=`Related Artist==[[*Related Artist]]` &toPlaceholder=`new` &resources=`-[[*id]]` ]]
<?php
$output = '';
$id = !empty($id) ? $id : 0;
$modx= new modX();
$modx->initialize('mgr');
$query = $modx->newQuery('modResource');
$query->where(array(
'parent' => 679,
'published' => 1,
'Related Artists.value:=' => 603 // this will be replaced with $id when I get it to work...
));
$query->limit(5);
$titles = $modx->getCollection('modResource',$query);
foreach ($titles as $k) {
$output.= '<li>'.$k->get('pagetitle').'</li>'; // let's just get the titles first
}
return '<ul>'.$output.'</ul>';
$tvId = 12; // ID of the TV
foreach ($titles as $k) {
if ($k->getTVValue($tvId) == 603) {
$output.= '<li>'.$k->get('pagetitle').'</li>'; // let's just get the titles first
}
}
$query = $modx->newQuery('modResource');
$query->leftJoin('modTemplateVarResource', 'tv_value'); //, array('tv_value.resourceid = resourceid')
$query->where(array(
'modResource.parent' => 679,
'modResource.published' => 1,
'tv_value.resourceid' => 679,
'tv_value.tmplvarid' => 603 // this will be replaced with $id when I get it to work...
));
$query->limit(15);
$titles = $modx->getCollection('modResource',$query);
$migx = new Migx();
$filter = 'related-artist==%603%';
$query = $modx->newQuery('modResource');
$migx->tvFilters($filter,$query);
$query->where(array(
'parent' => 679,
'published' => 1
));
$query->limit(15);
$titles = $modx->getCollection('modResource',$query);
$query->prepare();echo $query->toSql();
SELECT `modResource`.`id` AS `modResource_id`, `modResource`.`type` AS `modResource_type`, `modResource`.`contentType` AS `modResource_contentType`, `modResource`.`pagetitle` AS `modResource_pagetitle`, `modResource`.`longtitle` AS `modResource_longtitle`, `modResource`.`description` AS `modResource_description`, `modResource`.`alias` AS `modResource_alias`, `modResource`.`link_attributes` AS `modResource_link_attributes`, `modResource`.`published` AS `modResource_published`, `modResource`.`pub_date` AS `modResource_pub_date`, `modResource`.`unpub_date` AS `modResource_unpub_date`, `modResource`.`parent` AS `modResource_parent`, `modResource`.`isfolder` AS `modResource_isfolder`, `modResource`.`introtext` AS `modResource_introtext`, `modResource`.`content` AS `modResource_content`, `modResource`.`richtext` AS `modResource_richtext`, `modResource`.`template` AS `modResource_template`, `modResource`.`menuindex` AS `modResource_menuindex`, `modResource`.`searchable` AS `modResource_searchable`, `modResource`.`cacheable` AS `modResource_cacheable`, `modResource`.`createdby` AS `modResource_createdby`, `modResource`.`createdon` AS `modResource_createdon`, `modResource`.`editedby` AS `modResource_editedby`, `modResource`.`editedon` AS `modResource_editedon`, `modResource`.`deleted` AS `modResource_deleted`, `modResource`.`deletedon` AS `modResource_deletedon`, `modResource`.`deletedby` AS `modResource_deletedby`, `modResource`.`publishedon` AS `modResource_publishedon`, `modResource`.`publishedby` AS `modResource_publishedby`, `modResource`.`menutitle` AS `modResource_menutitle`, `modResource`.`donthit` AS `modResource_donthit`, `modResource`.`privateweb` AS `modResource_privateweb`, `modResource`.`privatemgr` AS `modResource_privatemgr`, `modResource`.`content_dispo` AS `modResource_content_dispo`, `modResource`.`hidemenu` AS `modResource_hidemenu`, `modResource`.`class_key` AS `modResource_class_key`, `modResource`.`context_key` AS `modResource_context_key`, `modResource`.`content_type` AS `modResource_content_type`, `modResource`.`uri` AS `modResource_uri`, `modResource`.`uri_override` AS `modResource_uri_override`, `modResource`.`hide_children_in_tree` AS `modResource_hide_children_in_tree`, `modResource`.`show_in_tree` AS `modResource_show_in_tree`, `modResource`.`properties` AS `modResource_properties` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `tv_value` ON WHERE ( `modResource`.`parent` = 679 AND `modResource`.`published` = 1 AND `tv_value`.`resourceid` = '679' AND `tv_value`.`tmplvarid` = '140' ) LIMIT 15
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ( `modResource`.`parent` = 679 AND `modResource`.`published` = 1 AND `tv_v' at line 1
$query->leftJoin('modTemplateVarResource', 'TemplateVarResources'); //schema has a defined aggregate TemplateVarResources
$query->where(array(
'modResource.parent' => 679,
'modResource.published' => 1,
'TemplateVarResources.tmplvarid' => 603 // this will be replaced with $id when I get it to work...
));$query->leftJoin('modTemplateVarResource', 'tv_value', 'tv_value.resourceid = resourceid'); //with a custom join-alias, you need to define a ON - statement
$query->where(array(
'modResource.parent' => 679,
'modResource.published' => 1,
'tv_value.tmplvarid' => 603 // this will be replaced with $id when I get it to work...
));
Catchable fatal error: Argument 1 passed to xPDOObject::load() must be an instance of xPDO, instance of modX given in /path/core/xpdo/om/xpdoobject.class.php on line 404
SELECT * FROM `modx_site_tmplvar_contentvalues` WHERE `tmplvarid` = '13' AND `value` LIKE '%603%'
$query = $modx->newQuery('modResource');
$query->leftJoin('modTemplateVarResource', 'tv_value', 'tv_value.resourceid = resourceid'); //with a custom join-alias, you need to define a ON - statement
$query->where(array(
'modResource.parent' => 679,
'modResource.published' => 1,
'tv_value.tmplvarid' => 13
));
$query->limit(15);
$titles = $modx->getCollection('modResource',$query);
[[!getCache?
&element=`getResources`
&cacheExpires=`9000`
&parents=`679,663,641,799,590`
&depth=`0`
&tpl=`related-article-in-page-listing`
&limit=`6`
&includeTVs=`0`
&includeContent=`0`
&showHidden=`1`
&tvFilters=`Related Artist==[[*Related Artist]]`
&toPlaceholder=`new`
&resources=`-[[*id]]`
]]
select content.* from [content-table] as content (join with modx_site_tmplvar_contentvalues as temp) where [pageID] like (679,663,641,799,590) and `temp.tmplvarid`=13 and `temp.value`=603
$query = $modx->newQuery('modResource');
$query->leftJoin('modTemplateVarResource', 'tv13', 'tv13.contentid = modResource.id'); //with a custom join-alias, you need to define a ON - statement
$query->where(array(
'modResource.parent' => 679,
'modResource.published' => 1,
'tv13.tmplvarid' => 13,
'tv13.value' => 613
));
$query->getSelectColumns('modResource','modResource');
$query->limit(15);
$o = array();
if ($collection = $modx->getCollection('modResource',$query)){
foreach ($collection as $object){
$o[] = $object->get('pagetitle');
}
}
return implode('<br />',$o);