DynamicDropdownTV - exclude templates

vibedesign · November 29, 2019, 2:27pm

I’ve created 3 dynamic dropdown TVs like shown here. Now I would like to exclude certain templates or if possible generally all resources which are not containers (or parents) themselves. How would I do that?

bruno17 · November 29, 2019, 2:54pm

you can adjust the where - statement within your custom-processors

example here:

github.com

Bruno17/DynamicDropdownTV/blob/a11008237805a3ec83cbca8691781b47305704c5/core/components/dynamicdropdowntv/processors/mgr/resource_levels/getoptions.resource_level0.php#L49




$options = array();
$count = 1;


if (!empty($query)) {
	$c->where(array('pagetitle:LIKE' => $query . '%'));
} else {
	$options[] = array('id' => '', 'name' => $firstText);
}


$c->where(array('parent' => '0'));


//$c->prepare();die($c->toSql());
if ($collection = $modx->getCollection($classname, $c)) {
	$count += $modx->getCount($classname);
	foreach ($collection as $object) {
		$option['id'] = $object->get('id');
		$option['name'] = $object->get('pagetitle');
		$rows[strtolower($option['name'])] = $option;
	}
	ksort($rows);

vibedesign · November 29, 2019, 5:27pm

Thanks for all the help!

I managed to create the custom processor and assign it to the TVs, but I didn’t figure out, what exactly I need to change there. After some more research, my guess is I would need to check against isfolder to see if a resource is a container?

Would someone be able to give me further hints in that direction?

vibedesign · December 9, 2019, 1:57pm

@bruno17 I still couldn’t figure it out, you mind giving me another hint on this?

vibedesign · December 30, 2019, 10:40pm

Unfortunately I’m still stuck here, so I’ll send this as a last reach for some hints on where or how I need to exclude the unwanted template IDs within the custom-processor. Any help is highly appreciated

nuan88 · December 31, 2019, 1:33am

I think this thread will help

https://docs.modx.com/current/en/extending-modx/xpdo/class-reference/xpdoquery/xpdoquery.where

Mr_JimWest · December 31, 2019, 3:18am

That sounds right to me.

Are you looking for something like this…?

$c->where(array(
   'parent' => '0',
   'AND:isfolder' != 1,
   'AND:id:NOT IN' => array(15,16,17,20)
));

vibedesign · December 31, 2019, 10:29am

Thank you guys so much! I’m very new to xPDO but already amazed how easy it actually is (if you know where to look for).

@Mr_JimWest Thank you especially! Although I think there is a little syntax error in your example. Regarding to the docs and my testing your third line should look like this:

'AND:isfolder:!=' => 1,

Also I was actually looking for all resource which ARE containers, so I used:

'AND:isfolder:=' => 1,

// referring to the docs the following should be correct, but that didn't work (?):
'AND:isfolder' => 1,

But your code was a great example to easily understand the syntax, so here is my working code for future reference:

$c->where(array(
  'parent' => '0', 
  'AND:isfolder:=' => 1,
  'AND:template:IN' => array(0,9), 
  'AND:id:!=' => '103'
));

Mr_JimWest · December 31, 2019, 3:45pm

Ope, sorry about that. Glad you got it!

system · January 2, 2020, 3:45pm

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.