Versions Compared

Version Old Version 2 New Version 3
Changes made by

Amy Biasella

Amy Biasella

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
SELECT a.id, a.filtername, dbms_lob.substr(a.reqcontent, 4000, 1 ) as JQL, a.authorname
  FROM searchrequest a
 
WHERE dbms_lob.substr(a.reqcontent, 4000, 1 ) like '%In Post LC%'

...