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?
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)
No, i think this is just a function of basic search. I get the same message anytime i try to use a multi select checkbox in basic search.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think your latest comment answers it - while you might have a valid field option, that option is not valid in the Shipping project...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is really strange, when i do a basic search, select the Project Name, and then try to select "Delivery Method" it is grayed out with the message "Delivery Method is not applicable for the current Project / and or Issue type".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Actually this appears to be the case for all of my multi select checkbox fields. Maybe basic search does not accommodate this type of field.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you add your custom field configuration screenshot to the question?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The values I used are different from the examples in my question, just because they are somewhat proprietary.
I've confirmed though that the values that are throwing the error definitely exist within the custom field configuration.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
Good luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.