Page 1 of 1
[custom field] >255 entries and from SQL SELECT [RESOLVED]
Posted: 29 Jul 2009, 13:53
by bmayer
Hello everybody
Apologize me for my (very) poor english
I use Mantis 1.0.1
I have custom fields "text" (type == 0) for person's name, with a lot of mistake by operator
1500 person's name are possible and defined
Can i populate an custom field "enumeration" (type == 3), by an SQL SELECT, with 1500 rows dataset ?
Thanks by advance
Re: [custom field] >255 entries and from SQL SELECT
Posted: 29 Jul 2009, 14:37
by deboutv
No not with the default Mantis. You have to change the PHP code.
I don't think that a select box with 1500 entries is a good idea (the page will be very long to download).
Re: [custom field] >255 entries and from SQL SELECT
Posted: 29 Jul 2009, 15:22
by bmayer
Thanks dear "deboutv @ La Ciotat"
I dont imagine other solution for supply a closed set of 1500 possibility ...
The custom field signification are the name of one person from corporate
Have you an idea ?
Cher "deboutv"
Je ne vois pas trop comment faire autrement, pour présenter un choix fermé de 1500 réponses
Le custom field correspond au nom de l'un des 1500 collaborateurs de l'entreprise.
aurais-tu une idée ?
For non-french readers, apologize me again for this bad english

Re: [custom field] >255 entries and from SQL SELECT
Posted: 30 Jul 2009, 06:39
by deboutv
- Is the SQL request related to Mantis tables (ie do you want to display the list of Mantis users)?
- To prevent long download time, you could write something in javascript that will display the possibilities after the user enters few letters (like in your email reader when you write the email address in the To field).
PS: I skip the french translation, you have my email if you need it (or in my forum there is a french section)

Re: [custom field] >255 entries and from SQL SELECT
Posted: 30 Jul 2009, 06:50
by bmayer
deboutv wrote:- Is the SQL request related to Mantis tables (ie do you want to display the list of Mantis users)?
Yes, by example. Or an other (custom) table
deboutv wrote:- To prevent long download time, you could write something in javascript that will display the possibilities after the user enters few letters (like in your email reader when you write the email address in the To field).
it's too difficult for me
Re: [custom field] >255 entries and from SQL SELECT
Posted: 03 Aug 2009, 13:49
by deboutv
If it is a mantis built'in table, my plugin LongCF can help you (but it will load the 1500 entries in the select box).
Re: [custom field] >255 entries and from SQL SELECT
Posted: 03 Aug 2009, 14:53
by bmayer
deboutv wrote:If it is a mantis built'in table, my plugin LongCF can help you (but it will load the 1500 entries in the select box).
YES ! it's run fine !
Just a suggestion, may be an "ORDER BY" ?
Re: [custom field] >255 entries and from SQL SELECT
Posted: 03 Aug 2009, 15:00
by bmayer
deboutv wrote:If it is a mantis built'in table, my plugin LongCF can help you (but it will load the 1500 entries in the select box).
YES ! it's run fine !
Just a suggestion, may be an "ORDER BY" ?