Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Discrepancy while using WAS and ON operator

Rohan Monteiro
November 21, 2014

Hi all

Is there a difference between
status = "Needs More Info" 
status WAS "Needs More Info" ON now()

I was under the assumption both should return the same results (current bugs with that particular status) However I noticed they dont in few cases.(when the status are customized) 

Is my assumption incorrect. I also tried using during with future dates. It returned the same discrepancy. 

Rohan 

2 answers

0 votes
Rohan Monteiro
November 21, 2014

I wanted to have a query which gives status at any particular day. So I was running WAS "Needs More Info" ON "date" . Where date was being replaced by a script with an appropriate date value. However the result does not match status = Needs More Info which does not make sense. 
It works for some status not for few customized status onle 

0 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
November 21, 2014
status = "Needs More Info"

is what will get you the issues with the given status now. I don't know how WAS and ON works but seems that is not doing the job for you wink

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events