django_tickets: tickets: 5 rows where "created" is on date 2005-07-13 and owner = "nobody" sorted by changetime

5 rows where "created" is on date 2005-07-13 and owner = "nobody" sorted by changetime

descending

id	created	changetime ▼	last_pulled_from_trac	stage	status	component	type	severity	version	resolution	summary	description	owner	reporter	keywords	has_patch	needs_better_patch	ui_ux
24	2005-07-13 19:35:15	2008-08-21 16:09:48	2022-03-06 03:19:30.618279	Design decision needed	closed	Metasystem	defect	normal		wontfix	edit_inline support for OneToOne relationships	An object should be able to edit a OneToOne related object inline on the original object's page. For example, users should be able to edit lawrence.com Restaurants on the Place admin screen. (Restaurants are a one-to-one extension of Places.)	nobody	adrian	subclassing	0	0	0
26	2005-07-13 19:36:46	2012-01-19 12:53:15	2022-03-06 03:19:30.935713	Design decision needed	closed	contrib.admin	Uncategorized	minor	newforms-admin	wontfix	Admin validation errors cause FileUploadFields to be reset	Phil said: {{{ <pcauthon> if, say, the turnpike episode, event, etc admin kicks back with an error, you have to rebrowse to upload the pics. only really aggravating on turnpike episodes where there are 6 pics to browse for }}} JavaScript form validation could be a clean fix for this.	nobody	adrian	nfa-someday	0	0	0
25	2005-07-13 19:35:54	2013-06-02 18:10:34	2022-03-06 03:19:30.770423	Accepted	closed	contrib.admin	Bug	Normal	dev	fixed	Filtering interface on ForeignKey <select> boxes	Select boxes are a pain, and slow, to deal with when there are a lot of values to select from. (Example: datelines on news stories). There should be a generator option, use_filter_interface, available on select boxes. It would add an <input type="text"> next to the select box and allow users to filter the select box that way. This would make data entry quicker, because folks could just paste in the dateline they want, and it'd be selected for them (assuming it's been entered as a dateline in the system).	nobody	adrian	feature	1	1	1
27	2005-07-13 19:40:29	2014-06-08 07:20:52	2022-03-06 03:19:31.121463	Someday/Maybe	closed	Forms	New feature	Normal		worksforme	Single form field for multiple database fields	Some admin interfaces would benefit from being able to have multiple fields' worth of data entered in a single field. For example, a field for a sports stat could be entered into a single field as "XX-YY-ZZ", whereas the three values are actually three separate fields in the DB. Relevant conversation: {{{ <jacobkm> Well, I'm using those aggregate fields for stats where you type something like "3-17" and it gets split into multiple fields. I see there's a CommaSeperatedIntegerField in formfields which would work for this, but there needs to be a way in the datadescriptions to say "this group of fields should be presented as a single field" <django34> The DD will have to provide a format string of some sort <jacobkm> Easy enough <jacobkm> are you thinking of a % format string or a regex? <django34> Not sure... <django34> Probably just % <django34> fields_together = '%(last_name)s, %(first_name)s' }}}	nobody	adrian		0	0	0
29	2005-07-13 19:43:02	2015-11-07 09:54:25	2022-03-06 03:19:31.418555	Someday/Maybe	closed	contrib.admin	Bug	Normal	dev	wontfix	Fix usability issue with limit_choices_to and "Add another" in admin	{{{ django34: We have the ability to put a customized limit/filter on which related objects get displayed in select boxes. For instance, the "photographer" field on the "Add photo" form only displays the "Staff members" that have shoots_photos=True. django34: This results in some usability problems, though, because if a producer doesn't see a person's name in the list, he might click "Add another..." instead of checking to make sure the person isn't in "Staff members" and doesn't have "shoots_photos" checked. django34: Does this make sense? wilson: kind of wilson: what page would that case appear on django34: Here's an example... django34: The "Photographer" select box includes only the staff members that have shoots_photos=True. django34: So if a producer doesn't see a photographer in there, he might click "Add another...", which would create an entirely new staff member. But it might be the case that the staff member DOES exist, just doesn't have shoots_photos=True checked. wilson: if the staff member did exist, would it let them add them again? django34: Yes, as long as the slug was different. django34: The only way I can think of to fix this would be to have some sort of "Showing only photographers [Show all staff members]" link. Or to eliminate the filtering altogether. wilson: i was going to suggest a "show all staff" link wilson: yes, that is my suggestion wilson: "show all staff" link next to the select wilson: then "show photographers only" when the filter is off django34: All right. }}}	nobody	adrian		0	0	1

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE tickets (
        id int primary key,
        created datetime,
        changetime datetime,
        last_pulled_from_trac datetime,
        stage text,
        status text,
        component text,
        type text,
        severity text,
        version text,
        resolution text,
        summary text,
        description text,
        owner text,
        reporter text,
        keywords text,
        easy boolean,
        has_patch boolean,
        needs_better_patch boolean,
        needs_tests boolean,
        needs_docs boolean,
        ui_ux boolean
    );