Jira DB: Stringvalue and Customfieldoption

[Cristian Iorio]

Good afternoon, Community.

I have to write a query for a customer and I'm facing some issues in relating fields from the custom field tables.

In particular, records exist in [customfieldvalue] with STRINGVALUE filled out. In order to 'decode' the string, I'm joining this table with [customfieldoption]. Unfortunately, I don't have any record matching with the customfield I'm looking for or matching with the STRINGVALUE. Now I suppose it's depending on the custom field type (Database Row Field).

In which tables are the options for Database Row Field cf stored?

[Nic Brough -Adaptavist-]

This is one of the reasons that you should stop reading the database - it is not designed or intended for reporting and is hence an utterly dreadful thing to do.

Use the REST API instead, it's faster, easier and will give you the results you need without having to mess with understanding the database.

If you insist on going down the worst possible reporting route, you'll find one of the data fields in the row for the custom field contains a number which is the key to the options table from which you can fetch the (untranslated) name (if it's a globally available select, if it's done with contexts, you may need to read for those too)