nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find custom field value IDs from Database

Pavan_fnakdz

Hi Team,

I have a custom field (Single Select) with 160 values in it.

I need a database query to find all the values with their ID

Please help

Thanks,

Pavan

Accepted answers

Sreenivasaraju P

Hi @Pavan

select ID,customvalue from customfieldoption where CUSTOMFIELD="your custom field id";

All comments

Kevin Mowrey

Edit: I didn't read your question thoroughly.

Sreenivasaraju P is right.

Sreenivasaraju P

Hi @Pavan

select ID,customvalue from customfieldoption where CUSTOMFIELD="your custom field id";

Pavan_fnakdz

Thanks Sreenivasaraju, it gave me what I need.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira