Can we please extend out the query condition options for the Salesforce node to cover all the logical SOQL queries.
At the moment we have
- ‘<’
- ‘<=’
- ‘=’
- ‘>’
- ‘>=’
On the custom object we have the ability to run an expression on the Operator but if you run a query against one of the preconfigured objects such as Accounts, you lose the ability to use expressions on the operator to modify the operator with more complex queries.
There appears to be a lack of standardisation between the Node Resources.
I realise we can handle alot of this via a Custom API Call but this isnt client friendly and we lose the ability to say n8n is a low/no code solution as they require a dev.
Common query operator conditions that we need at
- LIKE
- ‘!=’ (Not equals)
- IN
- NOT IN
- INCLUDES
- EXCLUDES
If we have the ability to then set local operators
- AND
- OR
- NOT
And the ability to turn off string ‘’ so we can handle Date Literals or null values
such as
SELECT Id FROM Account WHERE CreatedDate = YESTERDAY
or
SELECT AccountId FROM Event WHERE ActivityDate != null