You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

REST API: SELECT * FROM Answer WHERE keyword LIKE

Accepted answer
11
Views
7
Comments
edited Jan 3, 2018 9:26AM in UI Extensibility 7 comments

Content

Is there a reason why I can't use a WHERE clause on the "Keywords" column in the Answer table? I've tried this using the Connect Object Explorer and directly using the RestAPI.

Also I've noticed the LIKE is very hit and miss. For example, there are answers with the words 'wifi' and 'add' in the Summary column but if I do 'SELECT * FROM Answer WHERE summary LIKE '%add%', I get no results - even though I KNOW there should be.

When I do 'SELECT * FROM Answer WHERE summary LIKE '%wifi%', it finds the correct amount of results.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!