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!
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ] [ View Advanced ] [ Issue History ] [ Print ]
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 Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.1.2-B2
Status closed Product Version 5.1.1 Target Version 5.1.2
Time EstimateNo estimate
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
Tags No tags attached.
Reference https://groups.google.com/d/topic/in-portal-bugs/54GypdhOyoo/discussion
Change Log Message Fixed database query error during total value calculation on calculated field
Estimate Points 0
Attached Files patch file icon %1$s_doesnt_work_in_calculated_field_total.patch [^] (432 bytes) 2011-01-25 03:52 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
User avatar (0003208)
alex (manager)
2011-01-25 03:56

 To test:
1. create calculated field references other field from same main table using %1$s wildcard;
2. add 'totals' => 'SUM' to field option definition
3. add totals_render_as="totals_row" in TPL file, where "grid" block is rendered.

You will get %1$s not replaced in database query resulting an error.
User avatar (0003214)
Dmitry (manager)
2011-01-25 22:33

 Tested good, please commit.
User avatar (0003252)
Dmitry (manager)
2011-02-15 09:46

 Moved to 5.1.2.
User avatar (0003259)
alex (manager)
2011-02-15 10:55

 Fix committed to 5.1.x branch. Commit Message:

Fixes 0000972: Wildcard "%1$s" isn't processed during total calculation in calculated fields
User avatar (0003330)
Dmitry (manager)
2011-03-30 09:53

 Closing, since 5.1.2 release has been released.

- Related Changesets
In-Portal CMS: 5.1.x r14199
Timestamp: 2011-02-15 10:55:53
Author: alex
[ Details ] [ Diff ] 		Fixes 0000972: Wildcard "%1$s" isn't processed during total calculation in calculated fields
mod - /in-portal/branches/5.1.x/core/kernel/db/dblist.php [ Diff ] [ File ]

- Issue History
Date Modified Username Field Change
2011-03-30 09:53 Dmitry Note Added: 0003330
2011-03-30 09:53 Dmitry Status resolved => closed
2011-02-15 10:55 alex Changeset attached 5.1.x r14199
2011-02-15 10:55 alex Note Added: 0003259
2011-02-15 10:55 alex Status reviewed and tested => resolved
2011-02-15 10:55 alex Fixed in Version => 5.1.2-B2
2011-02-15 10:55 alex Resolution open => fixed
2011-02-15 10:55 alex Assigned To !COMMUNITY => alex
2011-02-15 09:46 Dmitry Note Added: 0003252
2011-02-15 09:46 Dmitry Target Version Icebox => 5.1.2
2011-01-25 22:33 Dmitry Note Added: 0003214
2011-01-25 22:33 Dmitry Status needs testing => reviewed and tested
2011-01-25 03:56 alex Note Added: 0003208
2011-01-25 03:56 alex Assigned To => !COMMUNITY
2011-01-25 03:56 alex Developer => alex
2011-01-25 03:56 alex Status active => needs testing
2011-01-25 03:53 alex Reference => https://groups.google.com/d/topic/in-portal-bugs/54GypdhOyoo/discussion
2011-01-25 03:53 alex Change Log Message => Fixed database query error during total value calculation on calculated field
2011-01-25 03:52 alex New Issue
2011-01-25 03:52 alex File Added: %1$s_doesnt_work_in_calculated_field_total.patch

Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

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

Powered by Mantis Bugtracker