LiveReport - cannot see Input type of Date

I am prompting the user to enter 2 Date types and one String type. When including the %1, %2, %3 parameters, the string shows up in the SQL but the dates are blank. Am I missing something? Has anyone seen this behavior? I know that the SQL is good because I substitute hard coded dates and it works fine. It just does not map the Dates that the user enters.

select * from
OTIC."RM_FileShare" T1
left outer join
OTIC."MIP_Act_Ctrl_Table_Files_SRV1" T2
ON T1."FSID" = T2."FileShareNum"
where T1."RM_Business" = %3
and T2."File_ModifDate" >= %1
and T2."File_ModifDate" =< %2

Find more posts tagged with

Comments

Bhupinder_Singh

Can you post a screenshot of the LiveReport's edit page so we can see how the report is set up? Thanks...

- Bhupinder

Colin_Schmidt

I've not seen this, but have you checked the lower portion to be: "User Input 1", "User Input 2", & "User Input 3"....an obvious thing done when writing one, but that's the 1st thing comes to my mind.

Colin J. Schmidt

Opentext Content Server Support Admin

colin.schmidt@mwv.com
+1 804.444 5012 (Direct)

MWV
501 South 5th Street
Richmond, VA 23219-0501
mwv.com

On Wed, Jul 24, 2013 at 4:57 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

LiveReport - cannot see Input type of Date Posted bynarendra.dyal@prudential.com (Dyal, Narendra)On 07-24-2013 16:54

I am prompting the user to enter 2 Date types and one String type. When including the %1, %2, %3 parameters, the string shows up in the SQL but the dates are blank. Am I missing something? Has anyone seen this behavior? I know that the SQL is good because I substitute hard coded dates and it works fine. It just does not map the Dates that the user enters. select * from
OTIC."RM_FileShare" T1
left outer join
OTIC."MIP_Act_Ctrl_Table_Files_SRV1" T2
ON T1."FSID" = T2."FileShareNum"
where T1."RM_Business" = %3
and T2."File_ModifDate" >= %1
and T2."File_ModifDate" =< %2
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Narendra_Dyal

For some reason I get an error when trying to attach a document with the screen print. Here are the Input and Parameter sections.

Inputs:

Any data to be submitted to this report is defined here. Normally any inputs defined will be displayed to the user using the specified Prompt. For more advanced users, any input defined here can be included in the report URL using the name specified under URL Parameter. To use one of these inputs in the SQL query, a Parameter must be defined in the parameter list below as User Input with a prompt number which matches each input number. Once a parameter has been created, this can be inserted in the SQL using the form: %1.
Whenever an input is set to the type InsertStr, an option appears on the title bar called Secure Mode which is checked by default. This mode provides some security checks on the final SQL after any user supplied inputs have been inserted. These security checks are provided to ensure that users are not able to insert any unfriendly SQL terms using the flexibility of the InsertStr input type. See the adminstrator guide for more information on this feature.

Type

Prompt

URL Parameter

Secure Mode

Container Date NodeId Number Object Project String User

Parameters:

Parameters allow information to be substituted into the SQL using the format: %1, %2, etc. This option allows different types of parameters to be selected.

To insert a user input from the Inputs section, select USERINPUT and then select the correct input number.
'Filter' options (such as Filter Document) can be used in the form: AND %1 as the filter will build the necessary logic clause automatically.
Other options will insert a data value which can be used in an appropriate part of the SQL query. For example, if parameter 3 was set to Today-Now the following clause could be used:
AND CREATEDATE < %3

Type

Options

User Input Filter Filter "Classified Items" Filter .config Filter Accession Search Filter Appearance Filter Appearance Folder Filter Appearance Workspace Folder Filter Archive Job Filter Archived Document Filter Backup Manager Filter Backup Process Filter Batch Labels Filter Best Bets Filter Categories Volume Filter Category Filter Category Folder Filter Channel Filter Channel Volume Filter Circulation Filter Classification Filter Classification Shortcut Filter Classification Tree Filter Classification Volume Filter Collection Filter Column Filter Compound Document Filter Compound E-mail Filter Content Move Job Filter Content Move Job Folder Filter Content Move Volume Filter Content Server Appearances Filter Content Server Search Federator Filter Custom View Filter Custom View Template Filter Data Flow Manager Filter Data Source Folder Filter Day Recycle Folder Filter Directory Walker Filter Discussion Filter Discussion Volume Filter Disposition Group Filter Disposition Search Filter Dispositions Filter Document Filter Document Conversion Filter Domain Workspace Filter Dynamic View Filter E-mail Filter E-mail Folder Filter E-mail Volume Filter EL Temporary Volume Filter Enterprise Extractor Filter Enterprise Library Compound Filter Enterprise Library Extractor Filter Enterprise Library Folder Filter Enterprise Library Item Filter Enterprise Library Object Type Definition Filter Enterprise Library Search Federator Filter Enterprise Library Types Volume Filter Enterprise Library Variant Filter Enterprise Library Volume Filter Enterprise Search Federator Filter Enterprise Workspace Filter Facet Filter Facet Folder Filter Facet Tree Filter Facets Volume Filter File Share Filter Fixed System Column Filter Folder Filter Form Filter Form Template Filter FSA Pipeline Server Filter FSA Volume Filter Generation Filter Global Appearance Filter Hold Group Filter Hold Maintenance Filter HTML View Filter Importer Filter Index Engine Filter LiveReport Filter Locators Filter Memcached Folder Filter Memcached Process Filter Merge Filter MicroPost Filter Milestone Filter Month Recycle Folder Filter My Personal Staging Folders Filter My Reserved Items Filter My Workspace Filter News Filter Partition Filter Partition Map Filter Permissions Filter Personal Staging Folder Filter Physical Item Filter Physical Item Box Filter Physical Item Container Filter Physical Item Copy Filter Physical Item Type Filter Physical Item Types Filter Physical Objects Administration Filter Physical Objects Workspace Filter Poll Filter Process Filter Profile Filter Project Filter Project Template Filter Project Workspace Filter Prospector Filter Prospector Queries Filter Prospector Snapshot Filter Provenance Filter Proxy Filter Pulse Filter Query File Filter Record Type Filter Record Types Filter Records Management Administration Filter Records Management Workspace Filter Recycle Bin Filter Release Filter Release Volume Filter Remote Content Server Filter Reply Filter Report Job Filter Reports Filter Reports Volume Filter Restore Job Filter Revision Filter RM Classification Filter RM Classification Terms Filter RM Folder Filter RM Part Filter RSI's Filter Search Enabled Hold Filter Search Engine Filter Search Form Filter Search Manager Filter Search Query Filter Search Result Snapshot Filter Search Results Template Filter Shortcut Filter Slice Folder Filter Social Object Volume Filter SocialObject Filter Spider Filter Storage Management Filter Submit Version Filter Synchronization Job Filter System Volume Filter Task Filter Task Group Filter Task List Filter Task List Volume Filter Template Folder Filter Templates Volume Filter Temporary Volume Filter Text Document Filter Topic Filter Transfers Filter Two Way Tee Filter Update Distributor Filter URL Filter Virtual Folder Filter Volumes Filter Web Forms Connections Filter Web Forms Database Connection Filter Web Forms Database Lookup Filter Web Forms Lookups Filter WebReport Filter Workflow Attachments Filter Workflow Map Filter Workflow Status Filter Workflow Volume Filter Workflows Edit Volume Filter XML Activator Consumer Filter XML Activator Producer Filter XML DTD Filter XML DTD Volume Filter Year Recycle Folder Last Month-End Last Month-Start Last Week-End Last Week-Start Next Month-End Next Month-Start Next Week-End Next Week-Start Object Type Report Fields Status Code Task Status Cancelled Task Status Completed Task Status In Process Task Status Issue Task Status On Hold Task Status Pending This Month-End This Month-Start This Week-End This Week-Start Today-End Today-Now Today-Start Tomorrow-End Tomorrow-Start UserID Yesterday-End Yesterday-Start

Input # 1 2 3

Narendra_Dyal

It might have to do with this being an external database. I tried using a Date input type using a current livelink instance, and it substitutes the user entry for the date field.