StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17677576
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-16T13:16:08.057
FavoriteCount
0
LastActivityDate
2013-07-16T13:16:08.057
LastEditDate
LastEditorUserId
0
OwnerUserId
2452461
ParentId
17587749
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>Firstly I'd like to say that there are many ways of customising the scoring in elasticsearch and it seems like you may have accidentally picked the wrong one. I will just summarize two and you will see what the problem is:</p> <h2>Custom Filters Score</h2> <p>If you <a href="http://www.elasticsearch.org/guide/reference/query-dsl/custom-filters-score-query/" rel="nofollow">read the docs</a> (carefully) on <code>custom_filters_score</code> then you will see that it there for performance reasons, to be able to use for scoring the the faster filter machinery of elasticsearch. (Filters are faster as scoring is not calculated when computing the hit set, and they are cached between requests.)</p> <p>At the end of the docs; it mentions <code>custom_filters_score</code> can take a <code>"script"</code> parameter to use instead of a <code>"boost"</code> parameter per <code>filter</code>. Best way to think of this is to calculate a number, which will be passed up to the parent query to be combined with the other sibling queries to calculate the total score for the document.</p> <h2>Custom Score Query</h2> <p><a href="http://www.elasticsearch.org/guide/reference/query-dsl/custom-score-query/" rel="nofollow">Reading the docs</a> this is used when you want to customise the score from the query and change it how you wish. There is a <code>_score</code> variable available to you to use in your <code>"script"</code> which is the score of the query inside the <code>custom_score</code> query.</p> <p>Try this:</p> <pre><code>"query": { "filtered": { "query": { "custom_score": { "query": { "match_all": {} }, "script": "doc['subject_score'].value" //*see note below } }, "filter": { "and": [ { "term": { "subject": "math" } }, { "term": { "name": "user1234" } } ] } } } </code></pre> <p>*NOTE: If you wanted to you could use <code>_score</code> here. Also, I moved both your <code>"term"</code> parts to filters as any match of a term would get the same score and filters are faster.</p> <p>Good luck!</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhy script in custom_filters_score behaves as boost?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USramseykhalaf
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.