SS_C_ConditionStatement TABLE

Hi Everyone
This is about SS_C_ConditionStatement table which is used by Product Ribbons .

There are different values in columns

CondtionType - Ex 0,2,4,5 etc
ConditionProperty - Ex- 0,1,2,4,5,8,9,11,18 etc
OperatorType - Ex - 0

Could anyone please explain what these values are ?

Thanks in advance

Hi nopmstr2014,

Is there a reason that you need this? It is a system information that our plugins use.

Here is how the enumerations looks like:

CondtionType:

public enum ConditionType
{
  Default = 0,
  Manufacturer = 1,
  Category = 2,
  Product = 3,
  Customer = 4,
  ProductSpecification = 5
}

OperatorType:

public enum OperatorType
{
  EqualTo = 0,
  NotEqualTo = 1,
  Contains = 2,
  DoesNotContain = 3,
  LessThan = 4,
  GreaterThan = 5,
  LessThanOrEqualTo = 6,
  GreaterThanOrEqualTo = 7
}

The ConditionProperty depends of what ConditionType you have selected.

Thanks for you reply
Would you able to provide default ConditionProperty for these  ConditionType

  Default
  Manufacturer
  Category
  Product
  Customer

We are trying to push text into ribbon table using stored procedures

Thanks

Manufacturer:

public enum ManufacturerConditionProperty
{
    Default = 0,
    Name = 1
}

Category:

public enum CategoryConditionProperty
{
    Default = 0,
    Name = 1
}

Product:

public enum ProductConditionProperty
{
    Default = 0,
    Category = 1,
    Manufacturer = 2,
    ProductAgeHours = 3,
    DiscountAmmount = 4,
    DiscountPercentage = 5,
    PriceDifferenceAmmount = 6,
    PriceDifferencePercentage = 7,
    MinPrice = 8,
    Quantity = 9,
    PreOrder = 10,
    FreeShipping = 11,
    HasSpecialPrice = 12
}

Customer:

public enum CustomerConditionProperty
{
    Default = 0,
    UserName = 1,
    Email = 2,
    IsLoggedIn = 3,
    IsInRole = 4,
    IsNotInRole = 5
}

I would suggest you to insert 1 test ribbon with a condition to see what are the necessary table records that needs to be inserted .

Hope this helps!

Thank you very much

ULTIMATE SUPPORT