[TYPO3-english] Extbase file listing based on sys_category Typo3 6.2

[Arun Chandran]

Hi Guys,

I am trying to create a custom extension which can be used to display files
in frontend based on sys_category. I can see that there is an
"sys_category_record_mm" table managing the category assignment of files.
This table contains uid_local ( uid of the category ) and uid_foreign ( uid
of the file ).


I got all the sys_category uids from the table and I want to fetch the
files from sys_file table based on sys_category_record_mm relation. I am
using Typo3 Extbase Repository method and is there any default function to
fetch these data from sys_file?

$query = $this->createQuery();
$query->statement();

I know using $query->statement(), we can write manual queries. But is there
any other method to join these tables to get the data by passing
sys_category uid as an argument?

Thanks,
Arun.