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