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
[custom field] >255 entries and from SQL SELECT [RESOLVED]
Moderators: Developer, Contributor
[custom field] >255 entries and from SQL SELECT [RESOLVED]
Last edited by bmayer on 03 Aug 2009, 15:10, edited 1 time in total.
Re: [custom field] >255 entries and from SQL SELECT
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).
I don't think that a select box with 1500 entries is a good idea (the page will be very long to download).
Want more plugins to customize Mantis?
=> http://deboutv.free.fr/mantis/
Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
=> http://deboutv.free.fr/mantis/
Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
Re: [custom field] >255 entries and from SQL SELECT
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
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
- 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).
Want more plugins to customize Mantis?
=> http://deboutv.free.fr/mantis/
Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
=> http://deboutv.free.fr/mantis/
Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
Re: [custom field] >255 entries and from SQL SELECT
Yes, by example. Or an other (custom) tabledeboutv wrote:
- Is the SQL request related to Mantis tables (ie do you want to display the list of Mantis users)?
it's too difficult for medeboutv 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).
Re: [custom field] >255 entries and from SQL SELECT
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).
Want more plugins to customize Mantis?
=> http://deboutv.free.fr/mantis/
Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
=> http://deboutv.free.fr/mantis/
Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
Re: [custom field] >255 entries and from SQL SELECT
YES ! it's run fine !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).
Just a suggestion, may be an "ORDER BY" ?
Re: [custom field] >255 entries and from SQL SELECT
YES ! it's run fine !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).
Just a suggestion, may be an "ORDER BY" ?