Limit and LimitValue

Multiple variable limits can be passed using the Limit and LimitValue parameters when ShowForm equals false. Each Limit can have multiple LimitValues.

Limit and LimitValue syntax:

http://hostname:portNumber/workspace/browse/run/folderPath?bqtype=ihtml&ShowForm=false&Limit1=q1\state&LimitValue1=CA&LimitValue1=MI&Limit2=q2\Product&LimitValue2=A001

To pass date limits you must define the day, month, year, time, and time zone as this syntax shows:

http://hostname:portNumber/workspace/browse/run/folderPath?bqtype=ihtml&jobOutput=true&ShowForm=false&Limit1=q1/SaleDate&LimitValue1=dd=12,mm=12,yyyy=2004,time=13:30:00,tz=America/Los_Angeles

Date Syntax	Description
dd	day
mm	month
yyyy	year
hh	hour
mm	minute
ss	second
tz	time zone

The default hour, minute, second is midnight. The default time zone is the time zone of the server’s location. This field uses recognized Java time zones.

You can use constants for dates:

Name	Value
First of Month	FirstOfMonth
First of Previous Month	FirstOfPreviousMonth
First of Quarter	FirstOfQuarter
First of Week	FirstOfWeek
First of Year	FirstOfYear
Friday	Friday
Last of Month	LastOfMonth
Last of Previous Month	LastOfPreviousMonth
Last of Quarter	LastOfQuarter
Last of Week	LastOfWeek
Last of Year	LastOfYear
Monday	Monday
Previous Business Day	PreviousBusinessDay
Today	Today
Yesterday	Yesterday

The syntax when using a date constant is:

http://hostname:portNumber/workspace/browse/run/folderPath?bqtype=ihtml&ShowForm=false&Limit1=q1\SaleDate&LimitValue1=FirstOfMonth,tz=America/Los_Angeles

Note:

The Ignore and Don’t Prompt flag defaults apply when a job is run. When limit values are passed using a SmartCut and the Ignore flag is set to true, the new values are ignored. To change these flags, modify the properties of the job through Explore before running the job.