DevForce Community Forum : Query using Take http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : Community Forum : Query using Take Fri, 10 Apr 2026 19:24:56 -700 Fri, 26 Oct 2012 17:41:10 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3745 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Query using Take : Unfortunately no. Expand will... http://www.ideablade.com/forum/forum_posts.asp?TID=3745&PID=14984#14984 Author: jtraband
Subject: 3745
Posted: 26-Oct-2012 at 5:41pm

Unfortunately no.  Expand will simply expand whatever the rest of the query returns

so

var query = new entityModel.EntityQuery()
                 .from("Customers")
                 .where("CustId", "==", "1")
                 .expand("Orders");

will give you cust: 1 and all of its orders; we do not yet have a good way to say "give me cust: 1 and just its first 500 orders.

What we have looked at, but is still in the research stage is the ability to do subqueries in projections, so that you could potentially, ( meaning not yet), do the following.

var query = new entityModel.EntityQuery()
                 .from("Customers")
                 .where("CustId", "==", "1")
                 .select("customerName, orders.take(500)");

Note that projections work today, but they cannot currently contain query clauses.

If this looks useful, please vote for this feature using the feedback mechanism on the web site. ( small icon on the right side of any Breeze website page labeled "Feedback").  This helps us decide which features to focus on next.

]]> Fri, 26 Oct 2012 17:41:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3745&PID=14984#14984 Query using Take : Hi there,Working my way through... http://www.ideablade.com/forum/forum_posts.asp?TID=3745&PID=14978#14978 Author: Orizz
Subject: 3745
Posted: 26-Oct-2012 at 4:28am

Hi there,

Working my way through Breeze and very impressed so far.

I was wondering if its possible to use a combination of Take / Expand in a query for example...

var query = new entityModel.EntityQuery()
                 .from("Customers").where("CustId", "==", "1").expand("Orders").take(500);

var query = new entityModel.EntityQuery()
                 .from("Customers").where("CustId", "==", "1").select().expand("Orders").take(500);

var query = new entityModel.EntityQuery()
                 .from("Customers").where("CustId", "==", "1").take(1).expand("Orders").take(500);

I've tried a combination of the above without any luck, I just want a top level Customer object and a list of limited Orders

Hope you can help!


]]> Fri, 26 Oct 2012 04:28:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3745&PID=14978#14978