How to find custom field value IDs from Database

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

2 answers

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thanks Sreenivasaraju, it gave me what I need.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

Edit: I didn't read your question thoroughly.

Sreenivasaraju P is right. :)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.