Anonymous | Login | Signup for a new account | 2024-04-23 15:33 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Relationship Graph | [ View Issue ] [ Dependency Graph ] | |||
|
||||
|
Viewing Issue Simple Details | |||||
ID | Category | Type | Reproducibility | Date Submitted | Last Update |
0000972 | [In-Portal CMS] Data Management | bug report | always | 2011-01-25 03:52 | 2011-03-30 09:53 |
Reporter | alex | View Status | public | ||
Assigned To | alex | ||||
Priority | normal | Resolution | fixed | ||
Status | closed | ||||
Summary | 0000972: Wildcard "%1$s" isn't processed during total calculation in calculated fields | ||||
Description |
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: 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 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. |
||||
Additional Information |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |