Select version
v7.18 v7.16 v7.13 v7.12 v7.11 v7.9 v7.8 v7.7 v7.6 v7.5 v7.3 v7.1 v7.0 v6.8 v6.7 v6.6 v6 v5 v4 v3 v2

Querying Products by Custom Properties in Ucommerce

One of the questions I’ve come across a couple of times with Ucommerce is using the LINQ API to query products by custom properties added to a product definition.

Here’s how:

    
    
    var q = from product in Product.All()
      where product.ProductProperties.Where(property => 
        (property.ProductDefinitionField.Name == "MyProperty" && property.Value == "MyPropertyValue") 
        || (property.ProductDefinitionField.Name == "MyOtherProperty" && property.Value == "MyotherPropertyValue")).Count() == 2
        && product.ParentProductId == null
      select product;
    
    
Ucommerce Aps - Vestergade 58N, 4th. floor - 8000 Aarhus C - Denmark
Phone +45 61 799 997 - Email [email protected] Ucommerce logo