Forums

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

"SQL/script" layout of advanced queries

Anders Bern June 18, 2020

Advanced oneliner queries becomes a mess rapidly.
Even something simple as (it is a "inbound catcher", never mind about it) :

IT BECOMES UNREADABLE in a one-line format.
Can the advanced function keep the formatting?

//

 

(
type in ("Problem Report", Defect, "Change Request")
AND status != closed
AND summary !~ blablabla
AND (component not in (x, y, z) OR component is EMPTY)
AND (text ~ a OR text ~ b OR text ~ c OR text ~ d OR text ~ e OR text ~ f OR text ~ g OR text ~ h)
AND (
ECU = empty
or
ECU not in (bla,bla2)
or
ECU in (bla3,bla4,bla5)
)
)
AND created > -7d
ORDER BY key DESC, createdDate DESC 

 

0 answers

Suggest an answer

Log in or Sign up to answer