|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
972 |
[In-Portal CMS] Data Management |
bug report |
always |
2011-01-25 03:52 |
2011-03-30 09:53 |
|
|
Reporter:
|
alex |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
5.1.1 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.1.2-B2 |
|
|
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 |
|
|
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:
|
|
| Relationships | |
|
Attached Files:
|
 %1$s_doesnt_work_in_calculated_field_total.patch (432) 2011-01-25 03:52
http://tracker.in-portal.org/file_download.php?file_id=915&type=bug |
|
|
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 |
|
|
Notes |
|
|
(0003208)
|
|
alex
|
|
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. |
|
|
|
(0003214)
|
|
Dmitry
|
|
2011-01-25 22:33
|
|
|
Tested good, please commit. |
|
|
|
(0003252)
|
|
Dmitry
|
|
2011-02-15 09:46
|
|
|
|
|
(0003259)
|
|
alex
|
|
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 |
|
|
|
(0003330)
|
|
Dmitry
|
|
2011-03-30 09:53
|
|
|
Closing, since 5.1.2 release has been released. |
|