You need to sign in to do that
Don't have an account?
![mobile1.3955696025783267E12 mobile1.3955696025783267E12](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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.