MS SQL Query to show data in database

Question

Hi,

I have a custom field that imports data from another database. I need to find out what the data looks like in JIRA. Are 0 stored as Null or 0?

I have tried with out success to get the information out of JIRA which is on a MySQL DB.

Can someone share the query to achieve this?

Many Thanks

Kevin

Ignacio Pulgar · Answer

That said, NULL values simply do not have a row in the CUSTOMFIELDVALUE table.

Ignacio Pulgar · Answer

Every issue has an entry in the JIRAISSUE table with its own numeric id.

Likewise, every custom field is represented as a row in the CUSTOMFIELD table with its id.

There's an intermediate table between both of those tables named CUSTOMFIELDVALUE, each of which rows contains one issue id, one custom field id, and the stored value:

Nic Brough -Adaptavist- · Answer

Yup.  If a custom field does not have a value, there is no row in customfieldvalue at all.

It would be a very good idea to forget about using the database - the API will give you better answers, more easily.