Using LiveReport Extensions (v3.x) you canuse the Template capability which will only include pieces of your WHERE clausewhen it is required. For example, if the field for document title is blank,then the LiveReport would exclude the SQL that tests for the document name (theclause AND DTREE.NAMELIKE '%<user input>%' would be excluded).
LiveReport Extensions comes with the WebReportsmodule, but is not dependent upon WebReports (in other words you can install anduse LR Extensions without installing WebReports). I am not sure if LRExtensions is available as a general download. If you do not have WebReports(HIGHLY RECOMMENDED!) or LiveReports Extensions, contact your Sales rep.
From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, July 18, 20071:23 PMTo: eLink RecipientSubject: Can a Livereport inputvariable be interogated in a SQL statement?
Can a Livereport input variable be interogated in a SQL statement?
Posted by bparise (Pariseau, Brian) on 07/18/2007 04:21 PM
I am trying to create some SQL to provide a live report for searching a portion of a file name and/or user name to findthe location of a document in the external file store. Sometimes both the file name and user will be entered, but sometimes only one of them. I am trying to create one report instead of three, but am getting a Livelink processing error when running the following SQL. Can a Livereport input variable be used like I have below in a MS SQL statement? SELECT DTree.DataId "NodeID", KUAF.Name "Username", DTree.Name, DversData.Version "Version", ProviderData.ProviderData "Path" FROM DTree, DversData, KUAF, ProviderData WHERE DTree.DataId = DversData.DocId AND DVersData.ProviderId = ProviderData.providerID AND DTree.Createdby = KUAF.ID AND (((%1 <> " " and %2 <> " ") and (dtree.name LIKE '%%'+%1+'%%' AND KUAF.Name LIKE '%%'+%2+'%%')) or ((%1 <> " " and %2 = " ") and (dtree.name LIKE '%%'+%1+'%%')) or ((%1 = " " and %2 <> " ") and (KUAF.Name LIKE '%%'+%2+'%%')))
