You need to sign in to do that
Don't have an account?
mobile1.3955696025783267E12
smartSQL with more than a parameter
Hi, I am trying to use the following smartSQL in the local smartstore:
SELECT {Product2:_soup} FROM {Product2} WHERE (({Product2:Name} LIKE '%%') AND ( {Product2:Family} == 'Bags' )) ORDER BY LOWER({Product2:Name}))
and I get error.
I was looking to some examples on how to sue the 'AND' in smartSql in order to query an object on more than one field.
Additionally the Product2:Family is a pick list field, and may be this creates issues too.
Thanks a lot for the help
Maurizio.
SELECT {Product2:_soup} FROM {Product2} WHERE (({Product2:Name} LIKE '%%') AND ( {Product2:Family} == 'Bags' )) ORDER BY LOWER({Product2:Name}))
and I get error.
I was looking to some examples on how to sue the 'AND' in smartSql in order to query an object on more than one field.
Additionally the Product2:Family is a pick list field, and may be this creates issues too.
Thanks a lot for the help
Maurizio.