[custom field] >255 entries and from SQL SELECT [RESOLVED]

[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

[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).

[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

[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)

[bmayer]

• 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

• 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

[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).

[bmayer]

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" ?

[bmayer]

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" ?