From: TROSSET Jean-C. <jct...@sq...> - 2002-07-08 16:23:18
|
Hello, I'm currently implementing the Excel / Word export. And a options page to choose the fields to print would be helpful, for example like the one in which you choose your account prefs. To do so, I plan to add a printing_prefs field in the mantis_user_pref_table. This field will contain all the choosen preferences as booleans, so that all the preferences will be included on one field. The entry would be : ALTER TABLE mantis_user_pref_table ADD printing_prefs VARCHAR(100) DEFAULT '1110100011000000000010000' NOT NULL; Given Kenito said all databases modifications should have his/the devs' agreement, are you ok with these settings ? Any comment ? Regards, Jean-Charles TROSSET |
From: Sean C. <sea...@hi...> - 2002-07-08 16:33:04
|
Ew. I suggest you create two new tables: mantis_print_prefs_table ---------------------------------------- pref_id pref_description and mantis_user_print_prefs_table ---------------------------------------- user_id print_pref_id and link up the users that way. your way seems too messy. Other comments? S At 06:24 PM 7/8/2002 +0100, you wrote: >Hello, > >I'm currently implementing the Excel / Word export. And a options page to >choose the fields to print would be helpful, for example like the one in >which you choose your account prefs. >To do so, I plan to add a printing_prefs field in the >mantis_user_pref_table. This field will contain all the choosen preferences >as booleans, so that all the preferences will be included on one field. > >The entry would be : > ALTER TABLE mantis_user_pref_table ADD printing_prefs VARCHAR(100) DEFAULT >'1110100011000000000010000' NOT NULL; > >Given Kenito said all databases modifications should have his/the devs' >agreement, are you ok with these settings ? Any comment ? > >Regards, >Jean-Charles TROSSET > > > >------------------------------------------------------- >This sf.net email is sponsored by:ThinkGeek >Oh, it's good to be a geek. >http://thinkgeek.com/sf >_______________________________________________ >Mantisbt-dev mailing list >Man...@li... >https://lists.sourceforge.net/lists/listinfo/mantisbt-dev |
From: TROSSET Jean-C. <jct...@sq...> - 2002-07-09 09:14:47
|
Ehm, Sean, I don't really understand your proposition ? The aim is to choose the bug fields to display in the print page, such as category, severity, summary .. These fields already exist and have a name in the langage files, and don't need a "description", the goal isn't here to redefine the fields, my export is something rather simple. And the user only have to choose, in an options page like the current account_pref one, the bugs to display by ticking the appropriate checkboxes. This page will list all the bugs, the 25 already existing plus the 20 custom fields which are planned, for a "static" total of 45. This makes 45 "display or not" choices, and to my mind, the best solution is to store it as booleans. Which allows to have a "default" preference too. Always to my mind, the best way is to store these choices in a unique varchar(45) field, or in a table like print_status integer print_category integer print_resolution integer .... but with 45 fields it may be too heavy ? In all the cases, the table with these prefs won't be a lookup one, the users will *often* choose the fields to print or not and write these choices on the table. I agree with not putting these booleans in the mantis_user_pref_table, but are 2 tables necessary ? What did you mean exactly with the "description" field ? Thanks for your advice Jean-Charles TROSSET ----- Original Message ----- From: Sean Coates <sea...@hi...> To: <man...@li...> Sent: Monday, July 08, 2002 5:33 PM Subject: Re: [Mantisbt-dev] A database modification > Ew. > > I suggest you create two new tables: > > mantis_print_prefs_table > ---------------------------------------- > pref_id > pref_description > > and > > mantis_user_print_prefs_table > ---------------------------------------- > user_id > print_pref_id > > and link up the users that way. > your way seems too messy. Other comments? > > S > > At 06:24 PM 7/8/2002 +0100, you wrote: > >Hello, > > > >I'm currently implementing the Excel / Word export. And a options page to > >choose the fields to print would be helpful, for example like the one in > >which you choose your account prefs. > >To do so, I plan to add a printing_prefs field in the > >mantis_user_pref_table. This field will contain all the choosen preferences > >as booleans, so that all the preferences will be included on one field. > > > >The entry would be : > > ALTER TABLE mantis_user_pref_table ADD printing_prefs VARCHAR(100) DEFAULT > >'1110100011000000000010000' NOT NULL; > > > >Given Kenito said all databases modifications should have his/the devs' > >agreement, are you ok with these settings ? Any comment ? > > > >Regards, > >Jean-Charles TROSSET > > > > > > > >------------------------------------------------------- > >This sf.net email is sponsored by:ThinkGeek > >Oh, it's good to be a geek. > >http://thinkgeek.com/sf > >_______________________________________________ > >Mantisbt-dev mailing list > >Man...@li... > >https://lists.sourceforge.net/lists/listinfo/mantisbt-dev > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Oh, it's good to be a geek. > http://thinkgeek.com/sf > _______________________________________________ > Mantisbt-dev mailing list > Man...@li... > https://lists.sourceforge.net/lists/listinfo/mantisbt-dev |