How to add up content of TVs

[dragonstyleGG]

Hi,

I have various sub-documents in a folder. These documents have a TV which each has a number. How can I add up these numerical values?

Do someone have an Idea?

[halftrainedharry]

In a snippet either use an SQL query like this

SELECT SUM(value)
FROM modx_site_tmplvar_contentvalues
WHERE ...

or load the values with xPDO ($modx->getCollection('modTemplateVarResource', $query), iterate over the result and add up the values.

[dragonstyleGG]

Thanks, that is a good starting piont for me.

[halftrainedharry]

Here is some more detailed example code (that works only for direct children of the resource):

<?php
$parent_id = 1;
$tv_id = 2;
$stmt = $modx->prepare("SELECT SUM(value) FROM modx_site_tmplvar_contentvalues WHERE tmplvarid = ? AND contentid IN (SELECT id FROM modx_site_content WHERE parent = ? AND published = 1 AND deleted = 0)");
$stmt->execute([$tv_id, $parent_id]);
$sum = $stmt->fetchColumn(0);
return $sum;

[dragonstyleGG]

Oh thank you very much. I do try this.