Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

DB Query: field STRINGVALUE of table customfieldvalue

Oleksandr Muliar June 1, 2020

Hi!

Please help me finding the relation in DB.

 

My jira version is 7.5.0.

Whilst querying data from column stringvalue of table customfieldvalue I have some sting data (text) which I take directly, as well I have some numbers which are IDs of table customfieldoption that is clear for me.

 But in same field stringvalue I have other data, like ‘FUUL-2343’, etc, please see the attachment.  I have masked data so not to publish it, though they are test data.  From which tables this combination (‘FUUL-2343’)  is made? Left part “FULL’ is looks like pkey from table project, thought mine project is FULL-2, on top of that there are both projects in table project: FULL, FULL2.

 

Thank you!

Regards Alexander.stringvalue.png

1 answer

0 votes
Oleksandr Muliar June 2, 2020

Excuse me. No one knows?

Suggest an answer

Log in or Sign up to answer