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!

Viewing Issue Advanced Details Jump to Notes ] Wiki ] View Simple ] 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 Platform
Status closed   OS
  OS Version
ETA none Fixed in Version 5.1.2-B2 Product Version 5.1.1
  Target Version 5.1.2 Product Build
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.
Steps To Reproduce
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



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

Powered by Mantis Bugtracker