-
Type: Bug Report
-
Status: Closed
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 5.1.1
-
Fix Version/s: 5.1.2-B2
-
Component/s: Data Management
-
Labels:None
-
External issue URL:
-
Change Log Message:Fixed database query error during total value calculation on calculated field
-
External issue ID:972
-
Copy Issue Key:
-
Patch Instructions:
In-Portal uses kDBList class for database table data retrieval and display. It can display:
- database fields (fields from current table)
- calculated fields (field expressions, that even could data form JOINed tables)
For example based on this database query:
[b]SELECT main.FieldName, %1$s.FieldName AS OtherField, joined.FieldName2 AS FieldNameX
FROM table1 AS main
LEFT JOIN table2 AS joined ON joined.FieldA = main.FieldB[/b]
In example above FieldName is field from this table and FieldNameX is field name from joined table.
Wildcard "%1$s" can be used to reference main table (instead of specifying "main" each time). This works too.
- mentioned in
-
Wiki Page Loading...