Atlassian JIRA   History | Log In     View a printable version of the current page. Get help!  
Issue Details [XML]

Key: XRP-17
Type: Bug Bug
Status: Closed Closed
Resolution: Applied
Priority: Major Major
Reporter: Jurgen De Moortel
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
xReporter

QBE-problem with columns with the same name

Created: 06/Aug/04 10:41 AM   Updated: 19/Feb/07 01:23 AM
Component/s: xReporter
Affects Version/s: SVN-HEAD
Fix Version/s: 1.2.1

File Attachments: 1. Text File qbefix.patch (4 kb)



 Description   
When the resultset contains columns with the same name, qbe will not
work on these columns. When you try to use qbe on such a column, the following error appears: "Ambiguous column".

 All   Comments   Change History      Sort Order:
Comment by Jurgen De Moortel [06/Aug/04 10:44 AM]
This patch creates an attribute canonical on the column.
In this attribute you can put the tablename and the columnname.
For example: president.Pres_Name. If the attribute canonical exists, qbe uses the value of canonical instead of the value of field.

Patch applied to xreporter 1.2.1 branch
http://cvs.cocoondev.org/cgi-bin/viewcvs.cgi/xreporter/status.xml.diff?r1=1.58&r2=1.59&cvsroot=xreporter

Thx for a very clean and complete patch.

Comment by Marc Portier [09/Nov/04 06:09 AM]
Administrative close (patch was applied some time ago)