Typo3 Extbase Repository->findAll() returns empty

extbase typo3-6.2.x
Mario picture Mario · Jul 20, 2014 · Viewed 8.4k times · Source

I just can't findAll() make return anything even though I am able to access a specific record by findByUid().

I have taken note (and tried to workaround / set up) of the typoscript solution and the record storage page bug without any success.

I am using a dummy extension code made by the extension builder in TYPO3 (current version) for your convenience. I have tested with data manually added through the TYPO3 config ui.

Any help would be much appreciated.

All the best and thanks in advance

Mario

Answer

biesior picture biesior · Jul 21, 2014

For 99.9 % you didn't set your storagePid properly, it has to be the PID of the page where your records are stored. Effect: findAll() uses this PID to filter the records, while findByUid(uid) ignores PID (it searches by UID wherever record is stored.

Go to the main page > Templates and make sure that you included TypoScript from your new ext, then go to constant editor and set proper PID of page with your records. Clear whole cache at the end!

Also you can debug your SQL statement like in this answer, most probably at the end of statement you'll see something like AND your_table_name.pid IN (0) which definitely means that you didn't set storagePid or you didn't clear the cache.

Related questions

TYPO3: Pass multiple arguments to a partial from a fluid template

I have a fluid template, from where I call an often used snippet (called "partial"): Template: <f:render partial="fbLikeBox" arguments="{settings}"/> Partial fbLikeBox.html: <div id="fb-root"></div><script src="http://connect.…

Read More
TYPO3: get path out of file reference in Extbase

i've created a Custom Content Element with Fluid and Extbase (TYPO3 6.1), in which you can define a picture. In the picture-settings i can set a img-link, which is targetting a file. In my Controller i can access this data with $…

Read More
Extbase - get created sql from query

i want to get some database tables from my typo3 extensions. The Extension is based on extbase. The query always returns nothing but the data exists I've tried this: $query = $this->createQuery(); $query->statement('SELECT * FROM `my_table` …

Read More