apex-query-builder
apex-query-builder copied to clipboard
Datetime support
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;
}
}