Computed Field
Computed field is a special type of Query filed.
Its purpose is to add computed fields to the query.
Computed field added two additional properties.
Computed Query Field Additional properties
Section |
Name |
Description |
Basic |
Path |
Path is always empty for computed field. |
Basic |
Expression Type |
Formula type. Could be Plain or String Concatenation. |
Basic |
Expression |
If Type is String Concatenation then template syntax should be used: {path to field 1}[any symbols][{path to field 2}] String Concatenation type converts each field to string. For example: The price is {Order.Price}$ If Type is Plain then Expression should be in c#.NET LINQ format (LINQ to SQL friendly, no pure LINQ allowed). Hint: Write plain expression in Visual Studio then copy it to CC Designer. |
Basic |
Type |
Result type could be selected if Expression Type is Plain. |
See Query Field for full property list.
(!) In case if data can't be calculated using LINQ to SQL there is a workaround. Just create an SQL view with two fields entity id and data (data needed to be calculated), then link entity and view with one-to-one relation. Data would be accessible in query.
Created with the Personal Edition of HelpNDoc: Free help authoring environment