apex-query-builder icon indicating copy to clipboard operation
apex-query-builder copied to clipboard

Datetime support

Open kratoon opened this issue 5 years ago • 0 comments

Currently no datetime is supported.

Something like this would be appreciated. Also date literals would be great.

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm

private static final String GMT_DATE_FORMAT = 'yyyy-MM-dd\'T\'HH:mm:ss\'Z\'';

public class CompareCondition extends FieldCondition {
        ....
        public Condition lt(Datetime fieldValue) {
            this.formedCondition = this.fieldName + ' < ' + fieldValue.formatGmt(GMT_DATE_FORMAT);
            return this;
        }

        public Condition gt(Datetime fieldValue) {
            this.formedCondition = this.fieldName + ' > ' + fieldValue.formatGmt(GMT_DATE_FORMAT);
            return this;
        }

        public Condition lte(Datetime fieldValue) {
            this.formedCondition = this.fieldName + ' <= ' + fieldValue.formatGmt(GMT_DATE_FORMAT);
            return this;
        }

        public Condition gte(Datetime fieldValue) {
            this.formedCondition = this.fieldName + ' >= ' + fieldValue.formatGmt(GMT_DATE_FORMAT);
            return this;
        }
}

kratoon avatar Nov 25 '20 15:11 kratoon