S
Santosh Patel
Guest
Query Limitations Only data fields with stored input values (text, decimal, etc.) can be used in a SELECT expression. Dependent fields, such as formulas, cannot be used in query methods. A relationship (i.e. Lookup) field can be used, but will only take the ID of the first related record--not an array of all related records. Related fields can be used if they point to a data field. The limitation preventing formulas from being used in the Query API can be easily bypassed in simple cases. Consider this Formula: {!amount} * {!price} Though you cannot use this Formula in a query directly, you can create a query such as: SELECT SUM(amount*price) FROM order WHERE ... Refer to documentation.progress.com/.../index.html If your formula is complex, use expression field type. Fields of type expression are stored in database and hence can be used in query api group functions. Formula fields are only stored in memory.
Continue reading...
Continue reading...