Welcome to the FogBugz Knowledge Exchange

Question

1

Hi there,

I am trying to determine the relationship between the BUG table and the Plugin_6_CustomField table - I assume there is a one to many relationship between the latter and the former but I cannot seem to identify either a linking table or a key constraint between the two. We have 2 custome fields and I need to prepare a script showing the values of these custom fields for a subset of bugs in our database. Thanks for any help you can offer

flag	asked Sep 9 2010 at 9:35 Simon 11●1

Roman · Answer 1 · 2010-09-09 12:06:19Z UTC

1

I believe the table you're looking for is CustomBugData (in your case this should be named "Plugin_6_CustomBugData"). This has an ixBug column and a column for each custom field that exists in your installation.

answered Sep 9 2010 at 12:06

Roman
1,211●3●16

That's right. The Plugin_X_CustomField table describes what the custom field is, it's data type, etc. The Plugin_X_CustomBugData table contains the link between a Bug and it's custom field data. – Rob Sobers Sep 9 2010 at 13:10

db · Answer 2 · 2010-09-09 13:49:51Z UTC

Another option, rather than trying to extract the data directly from the database, might be to use the Filter Export plugin, create a filter for the cases you're interested in, and then add the columns for the custom fields to that filter. Then you could just select More -> Export Cases to Excel to obtain the data for those custom fields.

Simon · Answer 3 · 2010-09-13 07:41:27Z UTC

0

Hey , thaks for the help guys, managed to pull the data directly from CustomBugData. Thanks again

answered Sep 13 2010 at 7:41

Simon
11●1

SQL relationship for custom fields

3 Answers