Java Code Examples for com.ibm.icu.util.Calendar#set()

The following examples show how to use com.ibm.icu.util.Calendar#set() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: ServerHitBin.java From scipio-erp with Apache License 2.0

6 votes

private static long getEvenStartingTime(long binLength) {
    // binLengths should be a divisable evenly into 1 hour
    long curTime = System.currentTimeMillis();

    // find the first previous millis that are even on the hour
    Calendar cal = Calendar.getInstance();

    cal.setTime(new Date(curTime));
    cal.set(Calendar.MINUTE, 0);
    cal.set(Calendar.SECOND, 0);
    cal.set(Calendar.MILLISECOND, 0);

    while (cal.getTime().getTime() < (curTime - binLength)) {
        cal.add(Calendar.MILLISECOND, (int) binLength);
    }

    return cal.getTime().getTime();
}

Example 2

Source File: TimeMemberUtil.java From birt with Eclipse Public License 1.0

6 votes

/**
 * 
 * @param d
 * @return
 */
private static Calendar getCalendar( Date d )
{
	Calendar c = Calendar.getInstance( timeZone, defaultLocale );
	
	if ( d == null )
	{
		c.clear( );
		c.set( 1970, 0, 1 );
	}
	else
	{
		c.setTime( d );
	}
	return c;
}

Example 3

Source File: AxisMarkersSheet.java From birt with Eclipse Public License 1.0

6 votes

private DataElement createDefaultDataElement( )
{
	Axis axis = getAxisForProcessing( );

	if ( axis.isSetType( ) )
	{
		if ( axis.getType( ).equals( AxisType.DATE_TIME_LITERAL )
				&& !axis.isCategoryAxis( ) )
		{
			Calendar c = Calendar.getInstance( );
			c.set( 1970, 0, 1, 0, 0, 0 );
			return DateTimeDataElementImpl.create( c );
		}
		return NumberDataElementImpl.create( 0.0 );
	}
	return null;
}

Example 4

Source File: TemporalExpressions.java From scipio-erp with Apache License 2.0

6 votes

@Override
public boolean includesDate(Calendar cal) {
    int minute = cal.get(Calendar.MINUTE);
    if (minute == this.start || minute == this.end) {
        return true;
    }
    Calendar compareCal = (Calendar) cal.clone();
    compareCal.set(Calendar.MINUTE, this.start);
    while (compareCal.get(Calendar.MINUTE) != this.end) {
        if (compareCal.get(Calendar.MINUTE) == minute) {
            return true;
        }
        compareCal.add(Calendar.MINUTE, 1);
    }
    return false;
}

Example 5

Source File: FormatterImpl.java From org.openntf.domino with Apache License 2.0

6 votes

public String formatDateTimeWithFormat(final DateTime sdt, final String format) {
	Calendar cal = sdt.toJavaCal();
	if (sdt.isAnyDate() || sdt.isAnyTime()) {
		Calendar calCopy = (Calendar) cal.clone();
		if (sdt.isAnyDate()) {
			calCopy.set(YEAR, 1970);
			calCopy.set(MONTH, 0);
			calCopy.set(DAY_OF_MONTH, 1);
		}
		if (sdt.isAnyTime()) {
			calCopy.set(HOUR_OF_DAY, 0);
			calCopy.set(MINUTE, 0);
			calCopy.set(SECOND, 0);
		}
		cal = calCopy;
	}
	return formatCalWithFormat(cal, format);
}

Example 6

Source File: BirtDateTime.java From birt with Eclipse Public License 1.0

5 votes

private static Date getDate( int year, int month, int day, int hours,
		int minutes, int seconds )
{
	Date newDate = new Date( );
	Calendar calendar = getCalendar( newDate );
	calendar.set( year, month, day, hours, minutes, seconds );
	calendar.set( Calendar.MILLISECOND, 0 );
	return calendar.getTime( );
}

Example 7

Source File: UtilDateTime.java From scipio-erp with Apache License 2.0

5 votes

public static Date getEarliestDate() {
    Calendar cal = getCalendarInstance(TimeZone.getTimeZone("GMT"), Locale.getDefault());
    cal.set(Calendar.YEAR, cal.getActualMinimum(Calendar.YEAR));
    cal.set(Calendar.MONTH, cal.getActualMinimum(Calendar.MONTH));
    cal.set(Calendar.DAY_OF_MONTH, 1);
    cal.set(Calendar.HOUR_OF_DAY, 0);
    cal.set(Calendar.MINUTE, 0);
    cal.set(Calendar.SECOND, 0);
    cal.set(Calendar.MILLISECOND, 0);
    return cal.getTime();
}

Example 8

Source File: MonthDateFormatTest.java From birt with Eclipse Public License 1.0

5 votes

public void testFormat( )
{
	Calendar calendar = Calendar.getInstance( );
	calendar.set( Calendar.YEAR, 2013 );
	calendar.set( Calendar.MONTH, 5 );
	calendar.set( Calendar.DATE, 8 );
	Date date = calendar.getTime( );
	Hashtable<ULocale, String> locales = new Hashtable<ULocale, String>( );
	locales.put( ULocale.CANADA, "Jun 2013" ); //$NON-NLS-1$
	locales.put( ULocale.CHINA, "2013年6月" ); //$NON-NLS-1$
	locales.put( ULocale.ENGLISH, "Jun 2013" ); //$NON-NLS-1$
	locales.put( ULocale.FRANCE, "juin 2013" ); //$NON-NLS-1$
	locales.put( ULocale.GERMAN, "06.2013" ); //$NON-NLS-1$
	locales.put( ULocale.ITALY, "giu 2013" ); //$NON-NLS-1$
	locales.put( ULocale.JAPAN, "2013/06" ); //$NON-NLS-1$
	locales.put( ULocale.KOREA, "2013. 6" ); //$NON-NLS-1$
	locales.put( ULocale.SIMPLIFIED_CHINESE, "2013年6月" ); //$NON-NLS-1$
	locales.put( ULocale.TAIWAN, "2013年6月" ); //$NON-NLS-1$
	locales.put( ULocale.TRADITIONAL_CHINESE, "2013年6月" ); //$NON-NLS-1$
	locales.put( ULocale.UK, "Jun 2013" ); //$NON-NLS-1$

	for ( Iterator<ULocale> itr = locales.keySet( ).iterator( ); itr.hasNext( ); )
	{
		ULocale locale = itr.next( );
		IDateFormatWrapper formatter = DateFormatWrapperFactory.getPreferredDateFormat( Calendar.MONTH,
				locale,
				true );
		assertEquals( locales.get( locale ), formatter.format( date ) );
	}
}

Example 9

Source File: DataTypeUtil.java From birt with Eclipse Public License 1.0

5 votes

/**
   * 
   * @param date
   * @return
   */
  private static java.sql.Date toSqlDate( Date date )
  {
  	Calendar calendar = Calendar.getInstance( );
calendar.clear( );
calendar.setTimeInMillis( date.getTime( ) );
calendar.set( Calendar.HOUR_OF_DAY, 0 );
calendar.set( Calendar.MINUTE, 0 );
calendar.set( Calendar.SECOND, 0 );
calendar.set( Calendar.MILLISECOND, 0 );		
return new java.sql.Date( calendar.getTimeInMillis( ) );
  }

Example 10

Source File: UtilDateTime.java From scipio-erp with Apache License 2.0

5 votes

public static Timestamp getDayStart(Timestamp stamp, int daysLater, TimeZone timeZone, Locale locale) {
    Calendar tempCal = toCalendar(stamp, timeZone, locale);
    tempCal.set(tempCal.get(Calendar.YEAR), tempCal.get(Calendar.MONTH), tempCal.get(Calendar.DAY_OF_MONTH), 0, 0, 0);
    tempCal.add(Calendar.DAY_OF_MONTH, daysLater);
    Timestamp retStamp = new Timestamp(tempCal.getTimeInMillis());
    retStamp.setNanos(0);
    return retStamp;
}

Example 11

Source File: UtilDateTime.java From scipio-erp with Apache License 2.0

5 votes

public static Timestamp getHourEnd(Timestamp stamp, Long hoursLater, TimeZone timeZone, Locale locale) {
    Calendar tempCal = toCalendar(stamp, timeZone, locale);
    tempCal.set(tempCal.get(Calendar.YEAR), tempCal.get(Calendar.MONTH), tempCal.get(Calendar.DAY_OF_MONTH), tempCal.get(Calendar.HOUR_OF_DAY), 59, 59);
    tempCal.add(Calendar.HOUR_OF_DAY, hoursLater.intValue());
    Timestamp retStamp = new Timestamp(tempCal.getTimeInMillis());
    retStamp.setNanos(0);
    return retStamp;
}

Example 12

Source File: UtilDateTime.java From scipio-erp with Apache License 2.0

5 votes

/**
 * Makes a Date from separate ints for month, day, year, hour, minute, and second.
 *
 * @param month  The month int
 * @param day    The day int
 * @param year   The year int
 * @param hour   The hour int
 * @param minute The minute int
 * @param second The second int
 * @return A Date made from separate ints for month, day, year, hour, minute, and second.
 */
public static java.util.Date toDate(int month, int day, int year, int hour, int minute, int second) {
    Calendar calendar = Calendar.getInstance();

    try {
        calendar.set(year, month - 1, day, hour, minute, second);
        calendar.set(Calendar.MILLISECOND, 0);
    } catch (Exception e) {
        return null;
    }
    return new java.util.Date(calendar.getTime().getTime());
}

Example 13

Source File: BirtDateTime.java From birt with Eclipse Public License 1.0

5 votes

protected Object getValue( Object[] args ) throws BirtException
{
	if( existNullValue( args ) )
	{
		return null;
	}
	Date date = DataTypeUtil.toDate(args[0]);
	Calendar cal = getCalendar( date );
	int quarter = quarter( date );

	cal.set( Calendar.MONTH, ( quarter - 1 ) * 3 );
	cal.set( Calendar.DAY_OF_MONTH, 1 );
	return cal.getTime( );
}

Example 14

Source File: DateGroupCalculator.java From birt with Eclipse Public License 1.0

5 votes

public DateGroupCalculator( Object intervalStart, double intervalRange, ULocale locale, TimeZone timeZone ) throws BirtException
{
	super( intervalStart, intervalRange );
	ULocale aLocale = locale == null ? ULocale.getDefault( ):locale;
	TimeZone aZone = timeZone == null? TimeZone.getDefault( ):timeZone;
	
	Calendar c = Calendar.getInstance( aLocale );
	c.setTimeZone( aZone );
	c.clear( );
	c.set( 1970, 0, 1 );
	this.defaultStart = c.getTime( );
	this.dateTimeUtil = new DateTimeUtil( aLocale, aZone );
}

Example 15

Source File: AggregationTest.java From birt with Eclipse Public License 1.0

4 votes

@Test
   public void test1( ) throws Exception
{
	QueryDefinition query = newReportQuery( );
	
	Calendar c = Calendar.getInstance( );
	c.clear( );
	// 3 grouping levels: CITY, STORE, SALE_DATE(by month)
	GroupDefinition g1 = new GroupDefinition( "G1" );
	g1.setKeyExpression( "row.e1" );
	query.addGroup( g1 );

	GroupDefinition g2 = new GroupDefinition( "G2" );
	g2.setKeyExpression( "row.e2" );
	
	query.addGroup( g2 );

	GroupDefinition g3 = new GroupDefinition( "G3" );
	g3.setKeyExpression( "row.e3" );
	g3.setInterval( GroupDefinition.MONTH_INTERVAL );
	g3.setIntervalRange( 1 );
	
	c.set( 2004, 9, 1 );
	g3.setIntervalStart( c.getTime( ) );
	query.addGroup( g3 );
	
	SortDefinition sort = new SortDefinition( );
	sort.setExpression( "row.e3" );
	sort.setSortDirection( ISortDefinition.SORT_ASC );
	query.addSort( sort );
	
	query.addBinding( new Binding( "e1", new ScriptExpression( "dataSetRow.CITY" ) ) );
	query.addBinding( new Binding( "e2", new ScriptExpression( "dataSetRow.STORE" ) ) );
	query.addBinding( new Binding( "e3", new ScriptExpression( "dataSetRow.SALE_DATE" ) ) );
	query.addBinding( new Binding( "e4", new ScriptExpression( "dataSetRow.SKU" ) ) );
	query.addBinding( new Binding( "e10", new ScriptExpression( "dataSetRow.PRICE" ) ) );
	query.addBinding( new Binding( "e11", new ScriptExpression( "dataSetRow.QUANTITY" ) ) );
	
	// Aggregate: count at city level
	IBinding e5 = new Binding( "e5" );
	e5.setAggrFunction( "COUNT" );
	e5.addAggregateOn( "G1" );
	query.addBinding( e5 );

	// Aggregate: count at city level but added to Store group
	IBinding e6 = new Binding( "e6");
	e6.setAggrFunction( "COUNT" );
	e6.addAggregateOn( "G1" );
	query.addBinding( e6 );

	// Aggregate: day total sales
	IBinding e7 = new Binding( "e7", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e7.setAggrFunction( "SUM" );
	e7.addAggregateOn( "G3" );
	query.addBinding( e7 );
	
	IBinding e81 = new Binding( "e81", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e81.setAggrFunction( "SUM" );
	query.addBinding( e81 );
	
	// Aggregate: Percent of grand total
	IBinding e8 = new Binding( "e8", new ScriptExpression( "dataSetRow.PRICE * dataSetRow.QUANTITY / row.e81" ));
	query.addBinding( e8 );

	// Aggregate: a moving ave with a filtering condition
	IBinding e9 = new Binding( "e9", new ScriptExpression( "dataSetRow.PRICE"));
	e9.setAggrFunction( "MOVINGAVE" );
	e9.setFilter( new ScriptExpression ("dataSetRow.QUANTITY>1")  );
	e9.addArgument( new ScriptExpression( "3") );
	query.addBinding( e9 );
	String[] exprs = new String[]{
			"e1", "e2", "e3", "e4", "e10", "e11", "e5", "e6", "e7", "e8", "e9"
	};

	outputQueryResult( executeQuery( query ), exprs );
	checkOutputFile();
}

Example 16

Source File: AggregationTest.java From birt with Eclipse Public License 1.0

4 votes

@Test
   public void test8( ) throws Exception
{
	QueryDefinition query = newReportQuery( );
	
	Calendar c = Calendar.getInstance( );
	c.clear( );
	// 3 grouping levels: CITY, STORE, SALE_DATE(by month)
	GroupDefinition g1 = new GroupDefinition( "G1" );
	g1.setKeyExpression( "row.e1" );
	query.addGroup( g1 );

	GroupDefinition g2 = new GroupDefinition( "G2" );
	g2.setKeyExpression( "row.e2" );
	
	query.addGroup( g2 );

	GroupDefinition g3 = new GroupDefinition( "G3" );
	g3.setKeyExpression( "row.e3" );
	g3.setInterval( GroupDefinition.MONTH_INTERVAL );
	g3.setIntervalRange( 1 );
	
	c.set( 2004, 9, 1 );
	g3.setIntervalStart( c.getTime( ) );
	query.addGroup( g3 );
	
	SortDefinition sort = new SortDefinition( );
	sort.setExpression( "row.e3" );
	sort.setSortDirection( ISortDefinition.SORT_ASC );
	query.addSort( sort );
	
	query.addBinding( new Binding( "e1", new ScriptExpression( "dataSetRow.CITY" ) ) );
	query.addBinding( new Binding( "e2", new ScriptExpression( "dataSetRow.STORE" ) ) );
	query.addBinding( new Binding( "e3", new ScriptExpression( "dataSetRow.SALE_DATE" ) ) );
	query.addBinding( new Binding( "e4", new ScriptExpression( "dataSetRow.SKU" ) ) );
	query.addBinding( new Binding( "e10", new ScriptExpression( "dataSetRow.PRICE" ) ) );
	query.addBinding( new Binding( "e11", new ScriptExpression( "dataSetRow.QUANTITY" ) ) );
	
	// Aggregate: count at city level
	IBinding e5 = new Binding( "e5" );
	e5.setAggrFunction( "COUNT" );
	e5.addAggregateOn( "G1" );
	query.addBinding( e5 );

	// Aggregate: count at city level but added to Store group
	IBinding e6 = new Binding( "e6");
	e6.setAggrFunction( "COUNT" );
	e6.addAggregateOn( "G1" );
	query.addBinding( e6 );

	// Aggregate: day total sales
	IBinding e7 = new Binding( "e7", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e7.setAggrFunction( "SUM" );
	e7.addAggregateOn( "G3" );
	query.addBinding( e7 );
	
	IBinding e81 = new Binding( "e81", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e81.setAggrFunction( "SUM" );
	query.addBinding( e81 );
	
	// Aggregate: Percent of grand total
	IBinding e8 = new Binding( "e8", new ScriptExpression( "row.e7 / row.e81" ));
	query.addBinding( e8 );

	// Aggregate: day total sales
			IBinding e9 = new Binding( "e9", new ScriptExpression("row.e8"));
			e9.setAggrFunction( "SUM" );
			query.addBinding( e9 );
	
	String[] exprs = new String[]{
			"e1", "e2", "e3", "e4", "e10", "e11", "e5", "e6", "e7", "e8", "e9"
	};

	outputQueryResult( executeQuery( query ), exprs );
	checkOutputFile();
}

Example 17

Source File: Session.java From org.openntf.domino with Apache License 2.0

4 votes

@Override
public DateTime createDateTime(final int y, final int m, final int d, final int h, final int i, final int s) {
	Calendar cal = Calendar.getInstance();
	cal.set(y, m - 1, d, h, i, s);
	return createDateTime(cal);
}

Example 18

Source File: AggregationTest.java From birt with Eclipse Public License 1.0

4 votes

@Test
   public void test11( ) throws Exception
{
	QueryDefinition query = newReportQuery( );
	
	Calendar c = Calendar.getInstance( );
	c.clear( );
	// 3 grouping levels: CITY, STORE, SALE_DATE(by month)
	GroupDefinition g1 = new GroupDefinition( "G1" );
	g1.setKeyExpression( "row.e1" );
	
	SortDefinition sortDefn = new SortDefinition();
	sortDefn.setExpression( "row.e5" );
	sortDefn.setSortDirection( ISortDefinition.SORT_DESC );
	g1.addSort( sortDefn );
	FilterDefinition filter = new FilterDefinition( new ScriptExpression( "row.e7 > 100" ) );
	g1.addFilter( filter );
	
	query.addGroup( g1 );

	GroupDefinition g2 = new GroupDefinition( "G2" );
	g2.setKeyExpression( "row.e2" );
	
	query.addGroup( g2 );

	GroupDefinition g3 = new GroupDefinition( "G3" );
	g3.setKeyExpression( "row.e3" );
	g3.setInterval( GroupDefinition.MONTH_INTERVAL );
	g3.setIntervalRange( 1 );
	
	c.set( 2004, 9, 1 );
	g3.setIntervalStart( c.getTime( ) );
	query.addGroup( g3 );
	
	SortDefinition sort = new SortDefinition( );
	sort.setExpression( "row.e3" );
	sort.setSortDirection( ISortDefinition.SORT_ASC );
	query.addSort( sort );
	
	query.addBinding( new Binding( "e1", new ScriptExpression( "dataSetRow.CITY" ) ) );
	query.addBinding( new Binding( "e2", new ScriptExpression( "dataSetRow.STORE" ) ) );
	query.addBinding( new Binding( "e3", new ScriptExpression( "dataSetRow.SALE_DATE" ) ) );
	query.addBinding( new Binding( "e4", new ScriptExpression( "dataSetRow.SKU" ) ) );
	query.addBinding( new Binding( "e10", new ScriptExpression( "dataSetRow.PRICE" ) ) );
	query.addBinding( new Binding( "e11", new ScriptExpression( "dataSetRow.QUANTITY" ) ) );
	
	// Aggregate: count at city level
	IBinding e5 = new Binding( "e5" );
	e5.setAggrFunction( "COUNT" );
	e5.addAggregateOn( "G1" );
	query.addBinding( e5 );

	// Aggregate: count at city level but added to Store group
	IBinding e6 = new Binding( "e6");
	e6.setAggrFunction( "COUNT" );
	e6.addAggregateOn( "G1" );
	query.addBinding( e6 );

	// Aggregate: day total sales
	IBinding e7 = new Binding( "e7", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e7.setAggrFunction( "SUM" );
	e7.addAggregateOn( "G3" );
	query.addBinding( e7 );
	
	IBinding e81 = new Binding( "e81", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e81.setAggrFunction( "SUM" );
	query.addBinding( e81 );
	
	// Aggregate: Percent of grand total
	IBinding e8 = new Binding( "e8", new ScriptExpression( "dataSetRow.PRICE * dataSetRow.QUANTITY / row.e81" ));
	query.addBinding( e8 );

	// Aggregate: a moving ave with a filtering condition
	IBinding e9 = new Binding( "e9", new ScriptExpression( "dataSetRow.PRICE"));
	e9.setAggrFunction( "MOVINGAVE" );
	e9.setFilter( new ScriptExpression ("dataSetRow.QUANTITY>1")  );
	e9.addArgument( new ScriptExpression( "3") );
	query.addBinding( e9 );
	String[] exprs = new String[]{
			"e1", "e2", "e3", "e4", "e10", "e11", "e5", "e6", "e7", "e8", "e9"
	};

	outputQueryResult( executeQuery( query ), exprs );
	checkOutputFile();
}

Example 19

Source File: TrailingFunction.java From birt with Eclipse Public License 1.0

4 votes

private void setToWeekEnd( Calendar cal)
{
	cal.set( Calendar.DAY_OF_WEEK, 7 );
}

Example 20

Source File: AggregationTest.java From birt with Eclipse Public License 1.0

4 votes

@Test
   public void test2( ) throws Exception
{
	QueryDefinition query = newReportQuery( );
	
	Calendar c = Calendar.getInstance( );
	c.clear( );
	// 3 grouping levels: CITY, STORE, SALE_DATE(by month)
	GroupDefinition g1 = new GroupDefinition( "G1" );
	g1.setKeyExpression( "row.e1" );
	query.addGroup( g1 );

	GroupDefinition g2 = new GroupDefinition( "G2" );
	g2.setKeyExpression( "row.e2" );
	
	query.addGroup( g2 );

	GroupDefinition g3 = new GroupDefinition( "G3" );
	g3.setKeyExpression( "row.e3" );
	g3.setInterval( GroupDefinition.MONTH_INTERVAL );
	g3.setIntervalRange( 1 );
	
	c.set( 2004, 9, 1 );
	g3.setIntervalStart( c.getTime( ) );
	query.addGroup( g3 );
	
	SortDefinition sort = new SortDefinition( );
	sort.setExpression( "row.e3" );
	sort.setSortDirection( ISortDefinition.SORT_ASC );
	query.addSort( sort );
	
	query.addBinding( new Binding( "e1", new ScriptExpression( "dataSetRow.CITY" ) ) );
	query.addBinding( new Binding( "e2", new ScriptExpression( "dataSetRow.STORE" ) ) );
	query.addBinding( new Binding( "e3", new ScriptExpression( "dataSetRow.SALE_DATE" ) ) );
	query.addBinding( new Binding( "e4", new ScriptExpression( "dataSetRow.SKU" ) ) );
	query.addBinding( new Binding( "e10", new ScriptExpression( "dataSetRow.PRICE" ) ) );
	query.addBinding( new Binding( "e11", new ScriptExpression( "dataSetRow.QUANTITY" ) ) );
	
	// Aggregate: count at city level
	IBinding e5 = new Binding( "e5" );
	e5.setAggrFunction( "COUNT" );
	e5.addAggregateOn( "G1" );
	query.addBinding( e5 );

	// Aggregate: count at city level but added to Store group
	IBinding e6 = new Binding( "e6");
	e6.setAggrFunction( "COUNT" );
	e6.addAggregateOn( "G1" );
	query.addBinding( e6 );

	// Aggregate: day total sales
	IBinding e7 = new Binding( "e7", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e7.setAggrFunction( "SUM" );
	e7.addAggregateOn( "G3" );
	query.addBinding( e7 );
	
	FilterDefinition f1 = new FilterDefinition( new ConditionalExpression( "row[\"e7\"]" , IConditionalExpression.OP_TOP_N, "2" ) );
	query.addFilter( f1 );
	
	
	
	IBinding e81 = new Binding( "e81", new ScriptExpression("dataSetRow.PRICE*dataSetRow.QUANTITY"));
	e81.setAggrFunction( "SUM" );
	query.addBinding( e81 );
	
	// Aggregate: Percent of grand total
	IBinding e8 = new Binding( "e8", new ScriptExpression( "dataSetRow.PRICE * dataSetRow.QUANTITY / row.e81" ));
	query.addBinding( e8 );

	// Aggregate: a moving ave with a filtering condition
	IBinding e9 = new Binding( "e9", new ScriptExpression( "dataSetRow.PRICE"));
	e9.setAggrFunction( "MOVINGAVE" );
	e9.setFilter( new ScriptExpression ("dataSetRow.QUANTITY>1")  );
	e9.addArgument( new ScriptExpression( "3") );
	query.addBinding( e9 );
	String[] exprs = new String[]{
			"e1", "e2", "e3", "e4", "e10", "e11", "e5", "e6", "e7", "e8", "e9"
	};

	outputQueryResult( executeQuery( query ), exprs );
	checkOutputFile();
}