DevForce Community Forum : More querying questions! http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : Community Forum : More querying questions! Fri, 10 Apr 2026 20:19:57 -700 Mon, 29 Oct 2012 14:27:56 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3747 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ More querying questions! : That's correct,I think the... http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14997#14997 Author: Orizz
Subject: 3747
Posted: 29-Oct-2012 at 2:27pm

That's correct, 

I think the subqueries in projections would be a great addition for Breeze, I've come up a few situations where this would have aided the solution gracefully, I understand it's about prioritising features and producing this functionality in the right way though - so look forward to it!

Many thanks
]]> Mon, 29 Oct 2012 14:27:56 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14997#14997 More querying questions! : Ok, I think I understand. Do you... http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14995#14995 Author: jtraband
Subject: 3747
Posted: 29-Oct-2012 at 2:18pm

Ok, I think I understand.  Do you mean that the problem is that this query
   from("Orders").where("Completed", "eq", true).expand("Customer");
does not return any "customer" entities when there are no "completed" orders? and presumably you want these customers as well.

If so, then I agree the only current approach is to perform the two queries.
   from("Customers")
followed by
   from("Orders").where("Completed", "eq", true);

The second query will automatically link the "orders" returned with the appropriate customers.

We have discussed, meaning this does not yet work, expressing this with a subquery within a projection query that might look something like this:
  from("Customers").select('this, orders.where("Completed", "eq", true)'
but we do not yet support subqueries in projections.

]]> Mon, 29 Oct 2012 14:18:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14995#14995 More querying questions! : If it is not possible, is there... http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14990#14990 Author: Orizz
Subject: 3747
Posted: 29-Oct-2012 at 9:46am

If it is not possible, is there a recommended workaround?

If I select completed orders and expand customers (so the inverse) The json is parsed in such a way that it doesn't really increase the payload too much (using $ref), but obviously if there are no completed orders, the customer can't be returned!

The only way I can see around it is to do 2 calls to the web api, one to get the customer object and one to get the completed orders for that customer, I guess this all relates to sub queries in some way

Anyway a recommended workaround solution would be a great help!

Thanks


]]> Mon, 29 Oct 2012 09:46:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14990#14990 More querying questions! : Hi there,Is the following possible?I... http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14988#14988 Author: Orizz
Subject: 3747
Posted: 29-Oct-2012 at 5:59am

Hi there,

Is the following possible?

I have a Customer object which is queried and includes an expand to get all the orders too. 

.from("Customer").expand("Orders");

I want to be able to only bring back orders which has been completed. 

So select the top level customer expand the orders so I get an Customer object with a List of orders and finally a list of orders which have been completed.

How do I get to the Completed property of the navigation object?

Many thanks!
]]> Mon, 29 Oct 2012 05:59:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3747&PID=14988#14988