Question

Hello, I searched this question amongst the question already asked, but I didn't find it.

The question is: we have created a custom field as a drop-down list, containing the name of our customers.

1) It's possible to add a new value (a new customer for us) during the insertion of a new case?

2) It's possible to batch populate this field? Maybe with a SQL statement that insert rows directly in the database table?

Best regards, Andrea

Answer 1

1. No, it is not possible to add a new value when inserting a new case. (Among other things, modifying the contents requires administrative privileges, which normal users don't have, but I suspect there are other technical reasons which make this difficult.)

2. It is possible to set this field on several cases at the same time through the FogBugz interface (providing that the field initially has the same value in all the cases, and that none of the cases have been Fixed). You could also do this with an SQL statement (after making a backup!) along the lines of

       UPDATE plugin_#_custombugdata
           SET custom_field_name="newCustomer"
           WHERE custom_field_name="oldCustomer"
   

where, of, the table name will depend on when you deployed the Custom Fields plugin relative to other plugins, and the custom_field_name will depend on the field names in plugin_#_custombugdata.

It is preferable to use FogBugz to do this rather than to manipulate the database directly.