Works in Oracle SQL*Plus, but No Results in Auto LiveReport

Mark Runyan

This query, returns 13 results exactly as written, but when run from a LiveReport (format: Auto LiveReport), I get no results found. What gives? Thanks! - Mark(Livelink 9.5, Oracle 9.2)select b.NAME, u.firstname||' '||u.lastname as user_name, u.title, a.auditstr, count(*) Count, max(a.auditdate)from livelink.dauditnew a, livelink.kuaf u, livelink.KUAFChildren c, (select dataid, REPLACE(SYS_CONNECT_BY_PATH(NAME,'|'),'|','/') NAME from livelink.dtree START WITH parentid = 13051974 CONNECT BY PRIOR dataid = parentid) b where a.dataid = b.dataid and a.performerid = u.id and c.childid = a.performerid and c.id in (select id from livelink.KUAF where name like '%External')group byb.name,a.dataid,a.performerid,auditstr,u.firstname,u.lastname,u.titleorder by max(auditdate) desc

Donna Nalls

Hi Mark,I haven't tested this, but at first glance, i would suggest:'%%External'Best,Donna