Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Retrieving By Category
Last Post 04/26/2011 2:09 PM by Peter Donker. 2 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Brendon
New Member
New Member
Posts:6


--
04/20/2011 5:08 PM
Looking for best solution, recommendation for a scenario where we need to retrieve entries by two sets of categories, a parent and child set. Entries would belong to the first AND second set.

Your CatShortList extension provides some custom SQL for querying by multiple categories using OR statement, but we need to go a step further in filtering that list by child categories with an AND statement.

Do you already have something like this in the API?
Brendon
New Member
New Member
Posts:6


--
04/20/2011 7:11 PM
Nevermind...I think. I just added another inner join to EntryCategories and did a Where clause on that. If you have another suggestion or there is a more built in function than writing SQL inline, I would like to hear it. Thanks.
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
04/26/2011 2:09 PM
There isn't something baked in, no. You'll need to bake your own based on the code of the CatShortList you have presumably.

Peter
You are not authorized to post a reply.