Hello,
I am a new Content Server user and would appreciate any assistance with this development effort. I am attempting to create a LiveReport including Templates, so a user can enter any or all of a "Create Date from", "Create Date to" or "Parent ID" parameters. Currently the LiveReport only works when:
1) all parameters are entered (you can see the SQL Source generated below)
2) both "Create Date from" and "Create Date to" are entered
It doesn't work when only 1 Date parameter is entered, or only the ParentID parameter is entered, or 1 Date + ParentID is entered. When I use "save and view source", I can't even generate the SQL query itself. I'm expecting the templates (and SQL source) to only be inserted if there are parameters entered. The screen just shows "No results found'" at the bottom of the page. The SQL itself does work & returns rows when I hard-code the values in Oracle SQL developer.
Here are my LiveReport settings:
Here is the full SQL as it appears in the LiveReport details screen:
select a.parentid, a.dataid, a.name, e.rimsRSI, a.CreateDate, a.ModifyDate, a.CreatedBy, a.ownerID, a.DComment, c.BoxID,
c.ChargeDate, c.ChargedTo, c.UniqueID, d.toDate, d.PhysItemKeyWords, d.DefaultLocation, e.rimsSubject, f.VALSTR "Client ID", g.valstr "First Name", h.valstr "Last Name"
from OPENTEXT_DBA.DTREE a
left join OPENTEXT_DBA.PhysItemCo c ON a.dataid = c.nodeID
left join OPENTEXT_DBA.PhysItemData d ON a.dataid = d.nodeID
left join OPENTEXT_DBA.rimsNodeClassification e ON a.dataid = e.nodeID
left join opentext_dba.llattrdata f ON
( a.dataid = f.id
and a.versionnum = f.vernum
and f.defid = 133033
and f.attrid = 2 )
left join opentext_dba.llattrdata g ON
( a.dataid = g.id
and a.versionnum = g.vernum
and g.defid = 133033
and g.attrid = 4 )
left join opentext_dba.llattrdata h ON
( a.dataid = h.id
and a.versionnum = h.vernum
and h.defid = 133033
and h.attrid = 3 )
~1 ~2 ~3
order by 1
