[TYPO3-dam] Fetch all items in a category from the DAM Table

[Dr. Ronald P. Steiner]

Hi Benjamin,

thanks a lot for the hit. It really looks good, and seams to be the 
right track, but somehow I can't figure it out.
This code is a most simple, but not working test to use pi_exec_query:

$res = $this->pi_exec_query('tx_dam',0,' AND sys_language_uid=0');
while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))    {
            $items[] = $row;
}
debug($items);

but it does not work. I expected to get all items from the tx_dam table. 
What am I doing wrong?

greetings

Ron



Benjamin Mack schrieb:
> Hey Ron,
>
> have a look at the function in tslib_pibase:
> pi_exec_query() (or something like that)
>
> There is a variable $mm_cat to get the information of a certain category.
> The $mm_cat needs "tx_dam_cat" as foreign-table and "tx_dam_mm_cat" as 
> mm-table. The third parameter in this array can be used to load only 
> certain categories.
>
> Hope this helps a bit.
>
> greetings,
> benni.
>
> Dr. Ronald P. Steiner wrote:
>> Hi Benjamin,
>>
>> there is a table "tx_dam_mm_cat". But I can't find any info regarding 
>> which item belongs to which category.
>> Isn't there a function to get the items to a category?
>>
>> any hints?
>>
>> Ron
>>
>>
>> Benjamin Mack schrieb:
>>> Hey Ronald,
>>>
>>> Dr. Ronald P. Steiner wrote:
>>>> It first seamed to work, but unfortunately in the DB-Table field 
>>>> tx_dam -> category not the category itself is stored but the 
>>>> numbers of categories the item is associated with. I could not find 
>>>> where to get the information which item is in which categories.
>>> Yes, there is a category table and a category_mm table. These 
>>> include the needed info about the association with categories.
>>>
>>> Is this for the frontend or the backend?
>