Edgewall Software
Modify ↓

Opened 5 years ago

Closed 5 years ago

#13174 closed defect (fixed)

Checkbox as a custom field renders "True"/"False" in results of query view

Reported by: Jun Omae Owned by: Jun Omae
Priority: normal Milestone: 1.0.18
Component: query system Version: 1.0-stable
Severity: normal Keywords:
Cc: Branch:
Release Notes:

Fix inconsistent behaivior of query view for checkbox fields.

API Changes:
Internal Changes:

Description

The checkbox as a custom field renders yes/no in ticket view, but True/False in results of query view.

They should be yes/no in both views.

Attachments (2)

query-view.png​ (14.5 KB ) - added by Jun Omae 5 years ago.
ticket-view.png​ (8.0 KB ) - added by Jun Omae 5 years ago.

Download all attachments as: .zip

Change History (6)

by Jun Omae, 5 years ago

Attachment: query-view.png​ added

by Jun Omae, 5 years ago

Attachment: ticket-view.png​ added

comment:1 by Jun Omae, 5 years ago

I noticed csv/tsv download of query page has a similar issue. csv download of ticket view renders 1/0 for checkbox fields, but csv download of query page renders True/False. Those should be 1/0. 

$ curl -s 'http://192.168.11.27:3000/1.0-sqlite/ticket/1024?format=csv'
id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,cb,added,changed,removed,info
1024,?,admin,,,defect,new,major,,component1,,,,,0,,,,
$ curl -s 'http://192.168.11.27:3000/1.0-sqlite/ticket/1023?format=csv'
id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,cb,added,changed,removed,info
1023,test,admin,,,defect,new,major,,component1,,,,,1,*,*,*,
$ curl -s 'http://192.168.11.27:3000/1.0-sqlite/query?id=1023-1024&col=cb&format=csv'
id,cb
1023,True
1024,False

comment:2 by Jun Omae, 5 years ago

Owner: set to Jun Omae
Status: new → assigned

Proposed changes in:

comment:3 by Ryan J Ollos, 5 years ago

The changes look good to me.

comment:4 by Jun Omae, 5 years ago

Release Notes: modified (diff)
Resolution: → fixed
Status: assigned → closed

Thanks for the reviewing! Committed in [16950] and merged in [16951,16952].

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jun Omae.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jun Omae to the specified user.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.