In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Dependency Graph View Issue ] Relation Graph ] Vertical ]
related to child of duplicate of

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

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker