Author: jleroux
Date: Thu Nov 22 13:03:57 2007
New Revision: 597488
URL:
http://svn.apache.org/viewvc?rev=597488&view=revLog:
Slightly modified annotation/documentation for complex-alias from Skip Dever proposition in "Additional documentation for View entities"
https://issues.apache.org/jira/browse/OFBIZ-1419Modified:
ofbiz/trunk/framework/entity/dtd/entitymodel.xsd
Modified: ofbiz/trunk/framework/entity/dtd/entitymodel.xsd
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/dtd/entitymodel.xsd?rev=597488&r1=597487&r2=597488&view=diff==============================================================================
--- ofbiz/trunk/framework/entity/dtd/entitymodel.xsd (original)
+++ ofbiz/trunk/framework/entity/dtd/entitymodel.xsd Thu Nov 22 13:03:57 2007
@@ -340,6 +340,19 @@
</xs:attribute>
</xs:attributeGroup>
<xs:element name="complex-alias">
+ <xs:annotation>
+ <xs:documentation>
+ In every SELECT statement, the fields that are normally used are really defined to be expressions.
+ This means for example that you can supply an expression like (discountPercent * 100) in place of just a field name.
+ The complex-alias tag is the Ofbiz way to do this.
+
+ The argument to the right of operator = can be any operator valid for that data type on the database system you are using.
+ For example, *, +, -, and / are commonly available mathematical operators (min, max, sum, avg, count, count-distinct, upper, lower)
+ You can also use any operator on any data type supported on the underlying database system including string and date operators.
+ complex-alias can be as complex as you need by adding nested complex-alias statements and complex-alias-field
+ can use the same functions (min, max, count, count-distinct, sum, avg, upper, and lower) as the alias tag.
+ </xs:documentation>
+ </xs:annotation>
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element ref="complex-alias"/>