Force (Re)calculation of Calculated Fields

[cancan101]

Is there any way to tell Pimcore to calculate / recalculate a calculated field without having to iterate over all objects and save them?

i.e. I added a new, calculated field to my Object definition and I would to populate the column in the query table (e.g. so sorting or filtering works on the grid view).

from the docs:

The only data stored is the one in the object's query tables for being able to query for calculated values.

Values in the query table are only updated when the data object is saved. So be careful, the values in the query table might not be up-to-date depending on the caluclation parameters.

Yes, I can write my own command that iterates + calls save, but (a) I wanted to see if something exists already and (b) would be nice to not have to call save and bump the version count etc.

[blankse]

@cancan101 You can recalculated it via own command direct in the query db table. I don't know a command in the pimcore core for that.
Maybe we can add this one.

<?php

declare(strict_types=1);

namespace AppBundle\Command;

use Doctrine\DBAL\Connection;
use Pimcore\Console\AbstractCommand;
use Pimcore\Model\DataObject\ClassDefinition;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;

class UpdateCalculatedFieldCommand extends AbstractCommand
{
    public function __construct(private Connection $db)
    {
        parent::__construct();
    }

    protected function configure(): void
    {
        $this->setName('app:update:calculated_field')
            ->addArgument(
                'class-name',
                InputArgument::REQUIRED,
                'Class name'
            )
            ->addArgument(
                'field-name',
                InputArgument::REQUIRED,
                'Field name'
            );
    }

    protected function execute(InputInterface $input, OutputInterface $output): int
    {
        $className = $input->getArgument('class-name');
        $fieldName = $input->getArgument('field-name');
		
        $class = ClassDefinition::getByName($className);
        $listingClass = "\\Pimcore\\Model\\DataObject\\$className\\Listing";
        $listing = new $listingClass();
        $listing->setUnpublished(true);
        $listing->setOrderKey('id');
        $listing->setLimit(0);
        $totalHitCount = $listing->getTotalCount();
        $bulkCount = 10;
        $listing->setLimit($bulkCount);

        do {
            foreach ($listing->getData() as $object) {
                $oldValue = $this->db->fetchOne(
                    sprintf('SELECT %s FROM object_query_%s WHERE oo_id = ?', $fieldName, $class->getId()),
                    [$object->getId()]
                );
                $newValue = $object->get($fieldName);
                if ($oldValue !== $newValue) {
                    $output->writeln(sprintf('%s => %s', $oldValue, $oldValue));
                    $this->db->executeStatement(
                        sprintf('UPDATE object_query_%s SET %s = ? WHERE oo_id = ?', $fieldName, $class->getId()),
                        [$newValue, $object->getId()]
                    );
                }
            }
            $listing->setOffset($listing->getOffset() + $bulkCount);
        } while ($listing->getOffset() < $totalHitCount);

        return 0;
    }
}