[TYPO3-mvc] query for objects with at least one category

[Claus Due]

Hi again Dmitri,

See below :)

On Jun 20, 2011, at 7:51 PM, Dmitri Pisarev wrote:

> Hey!
> Once again I'm stuck...
> I need to write a query, that shall select all of the objects (with any pid, $query->getQuerySettings()->setRespectStoragePage(FALSE);), that have at least one category assigned (Categories only from storagePid).
> The only way which I could think out was $query->matching($query->in('category', $categories)); where $categories I have to pass to repository action. Not convinent and didn't work right away.
> 
> The other solution would if I could temporary use category field of tt_news as simple int, instead of as a relation, e.g I need this query SELECT * FROM tt_news where category > 0
> But how do I do it? Set a custom mapping for this field, and map it to a custom property like category_count? Will this work?
> Any better advice?
> 
> Sorry for being silly and annoying!

Interference from WiFi which makes my Magic TrackPad spazz out is silly and annoying... this is just fun ;)

Perhaps this could work:

$constraints = array(
	$query->equals('newsitem.categories.pid', $categoryPid),
	$query->not($query->equals('newsitem.categories', 0)) // this, because the relation field is actually a count of the number of relations.
);
$query->matching($query->logicalAnd($constraints));

(freestyled again).

Very unsure if this works as expected...

Cheers,
Claus

> Regards,
> Dmitri.
> 
> 
> PS:I use the tables from tt_news:
> config.tx_extbase{
> 	persistence {
> 		classes {
> Tx_Lister_Domain_Model_Article.mapping.tableName = tt_news Tx_Lister_Domain_Model_Category.mapping.tableName = tt_news_cat
> 		}
> 	}
> }
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc