The ##OB_OPTIONSELECT_NONE macro accepts two comma-separated arguments in this format:
##OB_OPTIONSELECT_NONE{(arg1,arg2)}
The arguments return an expression that always negates the current SQL expression if they are equivalent. The most obvious use of this macro is in creating a <NONE> option in a drop-down list runtime parameter.
For example, this expression is expanded using the following logic:
select * from some.dbtable
where scope = ##OB_OPTIONSELECT_NONE{(@{param}, 0)}
If @{param} = 0 then the query is expanded to:
select * from some.dbtable
where scope = @{param} AND 1=0
Else, if @{param} <> 0 then the query is expanded to:
select * from some.dbtable
where scope = @{param}
In the Insert Macro menu, this macro is listed as Option Select None.