NebulaQueryAndSearch
NebulaQueryAndSearch copied to clipboard
jongpie
Apex library that dynamically generates SOQL & SOSL queries
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 =...
```apex System.debug( new Query(Task.SObjectType) .addPolymorphicFields( Task.WhoId, new Map{ Contact.SObjectType => new List{} } ) .getQuery() ); ``` When `addPolymorphicFields(SObjectField, Map)` or `addPolymorphicFields(SObjectField, Map)` is used with a non-empty map, but...
```apex System.debug( new Query(Case.SObjectType) .addPolymorphicFields(Case.OwnerId) .getQuery() ); ``` result: ```sql SELECT CaseNumber, Id, Who.Alias, Who.Email, Who.FirstName, (a lot of Who.X fields) FROM Case ``` Obviously, such a query will fail....