Query Custom Fields syntax

[danielm]

how do I get a custom field to show it's values
for instance.

I have a multi select drop down first field value is called category and the second is sub category each have items in the drop down , so how do I get the values to show up.

project = "Member Inquiry" and "Service Area" = "Refund (Forfeitures)" and mycsutomfield = category

I am not sure ?

[Jobin Kuruvilla [Adaptavist]]

Use the custom field name in the query.

project = "Member Inquiry" and "Service Area" = "Refund (Forfeitures)" and category = ....

[danielm]

project = "Member Inquiry" and "Service Area" = "Refund (Forfeitures)" and category = RF-QDRO I did this earlier something it does not like it comes back with

The value 'RF-QDRO' does not exist for the field 'category'. but that value does exsist

[Jobin Kuruvilla [Adaptavist]]

Is it configured as an option in the custom field?

[danielm]

yep and enabled

[Jobin Kuruvilla [Adaptavist]]

I am not sure because the error normally comes when the option is not configured.