Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Query multi category
meodemsao
#1 Posted : Monday, December 05, 2011 8:39:07 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 5/24/2011(UTC)
Posts: 32
how can i query product from multi category,example : category,color,size by kooboo API

I try but seem not right

var tours = tourQuery.WhereCategory(regionQuery).WhereCategory(styleQuery).WhereCategory(durationQuery).WhereContains("Name", (object)keyword);
jifeng
#2 Posted : Monday, December 05, 2011 11:07:09 AM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China

Code:

@using Kooboo.CMS.Content.Query.Expressions;
@{
    var or = new OrElseExpression(new WhereEqualsExpression(null, "UUID", "uuid1"), new WhereEqualsExpression(null, "UUID", "uuid2"));

    var query = ContentHelper.TextFolder("Article").CreateQuery().WhereCategory(ContentHelper.TextFolder("Category").CreateQuery().Where(or));    
}


Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
meodemsao
#3 Posted : Tuesday, December 06, 2011 10:27:41 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 5/24/2011(UTC)
Posts: 32
i try but not right

var and = new AndAlsoExpression(new WhereEqualsExpression(null, "UUID", "uuid1"), new WhereEqualsExpression(null, "UUID", "uuid2"));

tours = tourQuery.WhereCategory(regionQuery.Where(and))
.WhereCategory(styleQuery.Where(and))
.WhereCategory(durationQuery.Where(and))
.WhereContains("Name", (object)keyword);

Or

var and = new AndAlsoExpression(new WhereEqualsExpression(null, "UUID", "uuid1"), new WhereEqualsExpression(null, "UUID", "uuid2"));

tours = tourQuery.WhereCategory(regionQuery.Where(or))
.WhereCategory(styleQuery.Where(or))
.WhereCategory(durationQuery.Where(or))
.WhereContains("Name", (object)keyword);

all result null :(
jifeng
#4 Posted : Tuesday, December 06, 2011 2:40:00 PM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
You have one logic error, please use OrElseExpression!
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.498 seconds.