You need to sign in to do that
Don't have an account?
Jolanda Verhoef
Using Boolean Field in SmartSQL Statement
How do I test if a boolean value is true in a smartsql statement in the smartstore?
I have an SObject Response with one field: Boolean__c. Whether or not I include it in the indexSpecs doesn't seem to matter.
The following queries all return an empty list:
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'true'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'false'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'True'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'False'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = true
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = false
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = True
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = False
The following query returns all records:
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = '%'
I have an SObject Response with one field: Boolean__c. Whether or not I include it in the indexSpecs doesn't seem to matter.
The following queries all return an empty list:
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'true'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'false'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'True'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = 'False'
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = true
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = false
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = True
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = False
The following query returns all records:
SELECT {responses:_soup} FROM {responses} WHERE {responses:Boolean__c} = '%'
akhilesh_sfdc
Unfortunately you can only provide filters for fields that are indexed and boolean type is not supported for indexes. Try marking this indexed field as type "string" in your smartstore soup.