What does the 0 mean in this query?

[Jared]

Hi everyone,

I'm working on a report in structure, I'm working off a template which has the following query:

if(issuetype = "feature" and status != "done"; 1; 0)

I'm comfortable with everything up until the 0, unsure what it's looking to do, would anyone be able to advise what it would be used for or point me in the direction of some relevant documentation please?

[Alex Koxaras -Relational- · Accepted solution]

Hi @Jared 

Isn't it a if/then/else clause? I mean I would assume that is:

• If i(issuetype = "feature" and status != "done")
• Then return 1 (the above statement is true)
• Else return 0 (the statement on the parenthesis of the if clause is false)

[Jared]

Hi @Alex Koxaras -Relational-

Yep that makes sense, thank you! I shouldn't try and figure these things out late in the day! :) 

[Alex Koxaras -Relational-]

I know what you mean :)