0011634: using special characters on Custom Field name generates issue when trying to order by this CF

View Issue Details [ Jump to Notes ] [ Wiki ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0011634

mantisbt

administration

public

2010-03-09 03:21

2010-06-09 03:45

Reporter

fman

Assigned To

dhx

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

1.2.0

Target Version

Fixed in Version

Summary

0011634: using special characters on Custom Field name generates issue when trying to order by this CF

Description

Right now is possible to create a custom field which name contains blanks, and '-' (minus char).
If I add this CF on a personalized view, when I try to order I get an error seems due to '-', because some sort of 'virtual column' try to be created.
Surelly people like to see 'Development - ETA', more than 'Development_ETA', but this seems right now only solution.
Apologize in advance if I've some misunderstanding.
Possible solution:
manage a VERBOSE NAME for CF that CAN BE A VALID indetifier for later uses, and add a LABEL that can be localised

Tags

No tags attached.

Attached Files

Relationships

duplicate of	0010901	resolved	dhx	We can't use & in custom field value and it's impossible search the first and last value from custom list
related to	0011631	closed	dhx	Custom Fields with special characters in the name cause SQL errors on sort.

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2010-03-09 03:21	fman	New Issue
2010-03-09 04:29	atrol	Relationship added	related to 0011631
2010-03-12 08:35	dhx	Relationship added	duplicate of 0010901
2010-03-12 08:35	dhx	Status	new => resolved
2010-03-12 08:35	dhx	Resolution	open => duplicate
2010-03-12 08:35	dhx	Assigned To	=> dhx
2010-06-09 03:45	dhx	Status	resolved => closed

MantisBT 1.2.2 git master-1.2.x[^]

Time: 0.1880 seconds.
memory usage: 1,938 KB