sorry for the bad English. So i'm using SharePoint 2010 server Enterprise Search and I'm building a custom search webpart and result page. Using the SQL syntax: Select (whatever i need) from scope() where "myScope" = 'MyDeviceScope' AND Camera != '' So Camera is a single line text managed property i want to find where this property has any text in it. The wildcard operator doesn't help me much cause I don't know what will be entered in this single line of text the client enters it from a custom layout i've made.

Thank You.

  • SQL Syntax is deprecated in SharePoint 2010 and removed in 2013. Have you tried using Keyword Query Syntax? It does not appear that you query is overly complicated. KQL supports AND and NOT operators. – Matthew McDermott Feb 15 '14 at 13:50
  • If run a bit of testing and search and found that if I use Camera <> '""' it works but if i add CONTAINS(someField, '"FieldValue"') it trows exception – user20681 Mar 2 '14 at 23:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.