query products on custom property - uCommerce Support - our.umbraco.com

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib

Jan 18, 2013 @ 11:45
0

Query products on custom property?
Hey Guys,

Does anybody know a way to query products on a custom property?

I'm trying to do the following, but it says GetProperty is not supported:
```
Product.All().FirstOrDefault(x => x["Slug"] != null && x["Slug"].Value == parsedProductSlug)
```
If I change it to the following it works:
```
Product.All().ToList().FirstOrDefault(x => x["Slug"] != null && x["Slug"].Value == parsedProductSlug)
```
However, I'd rather not load all products in to memory to do this.

Any ideas?

Cheers

Matt
Copy Link
webmonger 130 posts 285 karma points

Jan 18, 2013 @ 11:48

100

I think Soren covers it here http://www.publicvoid.dk/QueryingProductsByCustomPropertiesInUCommerce.aspx

Jon

Copy Link
Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib

Jan 18, 2013 @ 12:01
0
Thanks Jon,

Managed to get it down to this:
```
Product.All().FirstOrDefault(x => x.ProductProperties.Any(y => y.ProductDefinitionField.Name == "Slug" && y.Value == parsedProductSlug));
```
Copy Link
Lee 1130 posts 3088 karma points

Sep 25, 2013 @ 12:13

0

Moved my reply to own thread

http://our.umbraco.org/projects/website-utilities/ucommerce/ucommerce-support/44998-Query-ProductsCategories-By-Custom-Properties-Efficiently

Copy Link
is working on a reply...

Please Sign in or register to post replies

Write your reply to:

Editor

Preview

Draft