LiveReport - URGENT

Craig_Laird

Firstly, sorry if I am posting in the wrong area but I'm in dire need of some help!?!I am currently writing a LiveReport, the SQL of which I have completed (I think). I am trying to get a list of results back by 'Modified' or 'Created' Date as Date is not good enough. Some of the documentation was scanned on back in 1999 but want the date it was modified or created on Livelink. Is this possible using the User Input Data Type and if so, how? If not, how would I go about it?Thanks very much in advance,Craig.PS - My current code:-select dtree.dataid as "Unique ID",k.valstr as "Sort Code", c.valstr as "Account Number", f.valstr as "Customer Number", h.valstr as "Document Type", l.valstr as "Transaction Type", b.valstr as "Date Scanned", e.valstr as "Date Account Closed", a.valstr as "Batch ID", i.valstr as "FileNet ID" from dtree, llattrdata a, llattrdata b, llattrdata c, llattrdata d, llattrdata e, llattrdata f, llattrdata g, llattrdata h, llattrdata i, llattrdata j, llattrdata k, llattrdata l, llattrdata m where ((dtree.dataid = a.id and dtree.versionnum = a.vernum and a.defid = 342711 and a.attrid = 10) and (b.valdate = %1 and b.id = dtree.dataid and b.defid = 342711 and dtree.versionnum = b.vernum and b.attrid = 9) and (dtree.dataid = c.id and dtree.versionnum = c.vernum and c.defid = 342711 and c.attrid = 3) and (dtree.dataid = d.id and dtree.versionnum = d.vernum and d.defid = 342711 and d.attrid = 13) and (dtree.dataid = e.id and dtree.versionnum = e.vernum and e.defid = 342711 and e.attrid = 14) and (dtree.dataid = f.id and dtree.versionnum = f.vernum and f.defid = 342711 and f.attrid = 8) and (dtree.dataid = g.id and dtree.versionnum = g.vernum and g.defid = 342711 and g.attrid = 12) and (dtree.dataid = h.id and dtree.versionnum = h.vernum and h.defid = 342711 and h.attrid = 4 and h.valstr like 'BFM%%') and (dtree.dataid = i.id and dtree.versionnum = i.vernum and i.defid = 342711 and i.attrid = 11) and (dtree.dataid = j.id and dtree.versionnum = j.vernum and j.defid = 342711 and j.attrid = 7) and (dtree.dataid = k.id and dtree.versionnum = k.vernum and k.defid = 342711 and k.attrid = 2) and (dtree.dataid = l.id and dtree.versionnum = l.vernum and l.defid = 342711 and l.attrid = 5) and (dtree.dataid = m.id and dtree.versionnum = m.vernum and m.defid = 342711 and m.attrid = 6))

Tim_Hunter

Craig I think I am confused, you want the documents Modified or Created date?The documents created date is dtree.createdate and the modified date is dtree.modifydate.If you want a query to get all documents created or modified on a specific date (from inputted date) you want something like this.select * from dtree where (trunc(%1) = trunc(createdate) or trunc(%1) = trunc(modifydate))Add in your joins to your llattrdata tables if you need those as well