Expression Recordset Example
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The following examples shows two Recordset objects containing expressions. The first is for an expression (ID = 7) dependent on one profile (User) and no expressions. The second is for an expression (ID = 24) dependent on one other expression (ID=7) and two hypothetical profiles (Product and User). The DateCreated, DateModified, rsExprDeps, and rsProfDeps fields are not shown.
Parent Recordset for Expression7
ExprID |
ExprName |
Category |
ExprDesc |
ExprBody |
|---|---|---|---|---|
7 |
"Expression7" |
"Hair" |
"Brown" |
String7 |
Profile Dependencies Child Recordset for Expression7
ExprID |
ProfDep |
|---|---|
7 |
"User" |
String7 = "<CLAUSE OPER="is-true">
<PROPERTY ID="User.GeneralInfo.hair" TYPE="string"/>
<IMMED-VAL TYPE="string">Brown</IMMED-VAL>
</CLAUSE>"
Parent Recordset for Expression24
ExprID |
ExprName |
Category |
ExprDesc |
ExprBody |
|---|---|---|---|---|
24 |
"Expression24" |
"Octogenarians" |
"Brown_haired_users_over_80" |
String24 |
Expression Dependencies Child Recordset for Expression24
ExprID |
ExprDep |
|---|---|
24 |
7 |
Profile Dependencies Child Recordset for Expression24
ExprID |
ProfDep |
|---|---|
24 |
"Product" |
24 |
"User" |
String24 = "<TERM TYPE="and">
<CLAUSE OPER="is-true">
<EXPR-REF ID=7/>
</CLAUSE>
<CLAUSE OPER="equal">
<PROPERTY ID="Product.name" TYPE="string"/>
<IMMED-VAL TYPE="string">hair dye</IMMED-VAL>
</CLAUSE>
<CLAUSE OPER="at-least">
<PROPERTY ID="User.GeneralInfo.age" TYPE="number"/>
<IMMED-VAL TYPE="number">80</IMMED-VAL>
</CLAUSE>
</TERM>"