Announcement

**Isomorphic** · 10 Nov 2014, 17:46

The actual error is coming from a string formatted as "MM/DD/YYYY" being passed to the DateTimeFormat.parse method, when it's specified format is actually "MM/dd/yyyy HH:mm"
This is specifically happening when the default formatted value is passed to the parser you specified via DateUtil.setDateParser(parser);

From a quick look, you've got a couple of usage issues here:
- The DateUtil.setDateInputFormat(...) method doesn't take a full format string like the one in your sample - just a 3 character value like "MDY"
- You're calling setShortDatetimeDisplayFormatter(...) and setNormalDateDisplayFormatter(...). These apply to different data types ("date" vs "datetime"). The DataSource field in question is of type "date" btw.

Having said that, we're investigating this report as it seems like even with these corrected, we may be failing to call the custom parser in all cases.
We'll follow up with more information when we have it.

Regards
Isomorphic Software

**Isomorphic** · 11 Nov 2014, 02:02

We've had a quick look into this - we're unclear as to whether you left all the original builtinds code in your test-case on purpose, but below is a minimal version of your test-case that works as expected.

There are some inline comments that explain the changes.

Let us know if this doesn't fully cover your circumstances.

Code:

public class BuiltInDS implements EntryPoint {

	// NOTE: millisecond precision is *not* enabled for DataSources by default - if you need it, please read the doc 
	// for DataSource.setTrimMilliseconds(), in particular the bit that starts "The SQLDataSource was 
	// designed for accuracy to the nearest second, and making it support millisecond accuracy requires 
	// a couple of steps"
	final static String DATE_FORMAT = "MM/dd/yyyy HH:mm:ss.SSS";
    public static final DateTimeFormat formatter = DateTimeFormat
                    .getFormat(DATE_FORMAT);

    /**
     * This is the entry point method.
     */
    public void onModuleLoad() {

    	// *** calls to set DateUtil globals must be made before any widgets are created 
        DateDisplayFormatter dateFormatter = new DateDisplayFormatter() {
            @Override
            public String format(Date date) {
                    return formatter.format(date);
            }
	    };
	    DateUtil.setShortDatetimeDisplayFormatter(dateFormatter);
	    DateUtil.setNormalDateDisplayFormatter(dateFormatter);
	    // inputFormat is a 3-char string
	    DateUtil.setDateInputFormat("MDY");

	    DateParser parser = new DateParser() {
	            @Override
	            public Date parse(String dateString) {
	                    Date date = new Date();
	
	                    if (dateString != null) {
	                            date = formatter.parse(dateString);
	                    }
	                    return date;
	            }
	    };
	    DateUtil.setDateParser(parser);

	    // DS
        DataSource dataSource = new DataSource();
        dataSource.setID("testDS");
        dataSource.setClientOnly(true);

        // fields
        DataSourceSequenceField pkField = new DataSourceSequenceField("pkField");
        pkField.setPrimaryKey(true);
        pkField.setHidden(true);
        // if you want to maintain time-elements, you need a "datetime" field, because "date" type 
        // fields are enforced as logicalDates, which discard all time-elements
        DataSourceDateTimeField dateTimeField = new DataSourceDateTimeField("dateTimeField", "DateTime");

        dataSource.setFields(pkField, dateTimeField);

        final FilterBuilder filterBuilder = new FilterBuilder();
        filterBuilder.setDataSource(dataSource);

        Date filterTime = new Date(System.currentTimeMillis() - (1 * 3600 * 1000));
        Criterion[] criteriaList = new Criterion[] { new Criterion("dateTimeField", OperatorId.GREATER_THAN, filterTime) };
        AdvancedCriteria defaultCriteria = new AdvancedCriteria(OperatorId.AND, criteriaList);
        filterBuilder.setCriteria(defaultCriteria);

        filterBuilder.show();
    }
}

**caleb.mayer** · 11 Nov 2014, 05:22

That fixed it, thanks!

Announcement

Problem with FilterBuilder DatePicker

Comment

Comment

Comment