anmi
Adept
Joined 7 years ago
User Profile
User Widgets
Contributions
json query syntax matches AND OR
Hello, I cannot find the full json query syntax documentation here. Thats wha I'm asking in this post: How does a json based query look like for AND matches in body text. I want to query all posts containing term1 AND term2 in their body. My query currently is this. How do I add the term2? [ { "messages":{ "fields":[ "id", "subject", "search_snippet", "body", "cover_image.view_href", "teaser", "view_href", "author", "conversation.last_post_time", "replies.count(*)", "kudos.sum(weight)", "metrics.views", "labels" ], "constraints":[ { "category.id":"DE", "conversation.style":"tkb", "body":{ "matches":"term1" }, "depth":0 } ], "sorts": [ "post_time desc" ], "limit":10, "subQueries":{ "labels":{ "fields":[ "text", "id" ] } } } } ]1.4KViewsSign in to react to this post6CommentsRe: JSON subquery returns spontaneous errors
Can someone from the development team please advice, what to do?ViewsSign in to react to this postCommentsJSON subquery returns spontaneous errors
When doing a json query with a subquery for labels, I get an error from time to time. [ { "messages": { "fields": [ "id", "subject", "search_snippet", "body", "cover_image.view_href", "teaser", "view_href", "author", "conversation.last_post_time", "replies.count(*)", "kudos.sum(weight)", "metrics.views", "labels" ], "limit": 10, "subQueries": { "labels": { "fields": [ "text", "id" ] } } } } ] Some requests return the correct result, but some return this error: { "status": "error", "message": "An unexpected error occurred.", "data": { "type": "error_data", "code": 301, "developer_message": "", "more_info": "" }, "metadata": {} } The usage of the subquery is very valueable for us to avoid additional API requests for the labels in a loop. What can I do to avoid the error while still using the subquery?ViewsSign in to react to this postComments- ViewsSign in to react to this postComments
- ViewsSign in to react to this postComments
- ViewsSign in to react to this postComments
- ViewsSign in to react to this postComments
- ViewsSign in to react to this postComments
- ViewsSign in to react to this postComments
I found this:
IN() Operator Syntax
"fieldname": { "in": [ "value1", "value2", "value3" ] }Example:
"board.id":{ "in":[ "stereos", "televisions" ] }So I think yours would look like this:
"labels.text":{ "in":[ "Text1", "Text2" ] }
- ViewsSign in to react to this postComments
You want kudos.sum(weight) instead of kudos.count(*)
1.4KViews
6Comments
You’ve seen all recent content