Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
REST API: SELECT * FROM Answer WHERE keyword LIKE — Cloud Customer Connect
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
14
Views
7
Comments
edited Jun 13, 2022 4:09AM in General Technical Discussions 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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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