I'm a novice when it comes to advance search syntax and this one is really throwing me. I have a Checkboxes custom field named Delivery Method with options: USMail, UPS, FedEx, OnTrac, etc.. Trying to do a simple search for issues where certain Delivery Methods have been checked.
So... Project = "Shipping" AND "Delivery Method" = "USMail" Works fine, but when I try Project = "Shipping" AND "Delivery Method" = FedEx" It errors out with "The Option 'FedEx' for 'Delivery Method' does not exist.
So again i'm kind of stumped, that value deffinitly exists within the checkbox custom field "Delivery Method". But for some reason the search is not recognizing it. Now there's a chance that the value "FedEx" was added at a later point in time, could it be the some re-indexing is needed or something like that?
Could it be the extra " on the end of the FedEx query?
Can you try something with the advanced search too - copy and paste in the Project = "Shipping" AND "Delivery Method" part of the query, then add the = sign and start typing FedEx - does it auto-suggest FedEx?
Since this is not a advanced query yet you could do this with Basic search. Try to do that and see what options are available. When you got the search you want click on advanced to get the JQL.
What Nic suggested in his comment is the same but global for context.
Without more details I don't think we will be able to assist. I tried few fields of checkbox type with multiple values and get no problem searching for them with JQL.
Something is not standard with your field type or configuration. That is the only reason I ask so we maybe can point you in the right direction!
Sorry, that was just a typo in my question. There is in extra " in my actual query. To the second part of your question, it does Autocomplete the custom field name "Delivery Method" but it does not auto complete any of the checkbox options that exist within that field.
Ok, I'm really stuck now. I don't have this problem when I use the search, basic or advanced. I think we need more information, including the context definition for the field, and what the symptoms are when you try the basic search (screenshots, sorry)
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs