apex-query-builder
apex-query-builder copied to clipboard
4an70m
Convenient query builder for dynamic SOQL queries
Current behaviour: ``` new QueryBuilder(Account.class) .addConditions() .add(new QueryBuilder.SimpleCondition('Name = \'Test\'') .add(new QueryBuilder.SimpleCondition('Field2 = \'Test\'') .endConditions() .toString(); // returns SELECT Id FROM Account WHERE Name = 'Test' ``` Expected behaviour: ```...
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...
create a simple query select id, name from account add a sub query to an object which also has Name as a field ( Id, Name from xxx__r ) expect...
testClone1() testToString() Personally, I wouldn't try to format (prettify) the query string because that will introduce a bunch of problems when trying to test the final query string.
The only `LIKE` and `NOT LIKE` conditions possible to be constructed with this framework are: ```sql Field__c LIKE '%x%' /* likeAnyBoth */ Field__c LIKE '%x' /* likeAnyLeft */ Field__c LIKE...
I see not way to introduce `NOT` operator (not to be confused with `NOT IN`) in the `WHERE` part, otherwise than rewriting the query. Example: ```sql WHERE NOT (Industry =...
The following query works as expected: ```apex new QueryBuilder(Account.class) .addField(Account.Name) .addConditions() .add(new QueryBuilder.SimpleCondition('Name = \'acc1\'')) .add(new QueryBuilder.SimpleCondition('Name = \'acc2\'')) .add(new QueryBuilder.SimpleCondition('Name = \'acc3\'')) .add(new QueryBuilder.SimpleCondition('Name = \'acc4\'')) (...) .add(new QueryBuilder.SimpleCondition('Name...
The operators [INCLUDES and EXCLUDES](https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_comparisonoperators.htm), essential for the mutipicklists, are not currently supported by this framework. Please add them, preferably as `extends FieldCondition`.
