Typo3 accessing an existing table to consume data of it

Question

I tried to integrate an existing table to my extension. The problem is that the content of the table isn't taken over. I created a new model with the name of the existing table and named the properties according to the existing column names. I also implemented the corresponding getters and setters of the properties.

The name of the existing table is tx_institutsseminarverwaltung_domain_model_event.

What is my failure in this case? Just want to access the data of an existing table from another extension.

Thanks in advance.

UPDATE:

I tried this:

/**
 * Protected Variable objectManager wird mit NULL initialisiert.
 *
 * @var \TYPO3\CMS\Extbase\Object\ObjectManagerInterface
 * @inject
 */
protected $objectManager = NULL;

and listAction():

/**
 * action list
 *
 * @return void
 */
public function listAction() {
    echo "test";
    $theRepository = $this->objectManager->get('\TYPO3\institutsseminarverwaltung\Domain\Repository\EventRepository');
    $yourRecords = $theRepository->findAll();
    $this->view->assign('events', $yourRecords);
}

But no results returned.

score 1 · Answer 1 · answered Mar 20 '18 at 09:22

1

You should use the repository linked to this table. Something like this :

$theRepository = $this->objectManager->get(\Your\VendorName\Domain\Repository\TheRepository::class);
$yourRecords = $theRepository->findAll();

answered Mar 20 '18 at 09:22

StatiX

854
6
21

I added some info in question above. No errors, but no data is fetched ... what could be a problem? – Felix Mar 20 '18 at 13:58
do I have to set the storage pid? – Felix Mar 20 '18 at 14:19

score 1 · Answer 2 · answered Mar 20 '18 at 09:27

How are you trying to "consume" or access the data from the other table in your extension?

Do you have a repository for the existing table (maybe there is already an existing repository, that you can reuse)?

See german typo3 board mapping existing tables and SO thread TYPO3 / How to make repository from existing table fe_users?

score 0 · Accepted Answer · answered Mar 20 '18 at 16:21

solution is:

    $querySettings = $this->objectManager->get('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Typo3QuerySettings');
    $querySettings->setRespectStoragePage(FALSE);

    $theRepository = $this->objectManager->get('TYPO3\\institutsseminarverwaltung\\Domain\\Repository\\EventRepository');
    $theRepository->setDefaultQuerySettings($querySettings);

    $yourRecords = $theRepository->findAll();
    $this->view->assign('events', $yourRecords);

Typo3 accessing an existing table to consume data of it

3 Answers3

Linked