4

I can't find posts from the new opinion-based questions experiment in SEDE. I've tried it with a slightly older one where I know the Id (79805930) and it is not in the Posts nor the PostsWithDeleted table in SEDE. If I increment or decrement the Id by 1 I do find a post with my query.

Am I doing something wrong here and are they stored somewhere else? Which would seem a bit weird to me as they're sharing the same Id space with regular posts. Or are these posts intentionally or accidentally omitted from SEDE?

A related question would be whether the posts that are part of this experiment are counted in the questions/day metric on the stackexchange.com homepage?

Improve this question

1 Answer 1

Reset to default
9

We've created a new table called OpinionBasedContent; the IDs of any posts (questions & answers) related to the experiment (along with the type originally selected by the user when asking) are added there on creation.

SELECT *
FROM Posts
WHERE Id in (
  SELECT PostId
  FROM OpinionBasedContent
)

As opinion-based questions are technically the same Post Type as 'traditional Q&A' questions, they will be included in any counts or metrics that we don't explicitly exclude them from (which I don't believe we've done for the one you reference).

As a side-note; I do get a post back when querying for that Id; are you definitely looking at SO?

Facepalm update: 1000 apologies, I was under the impression we’d exposed that table in public SEDE, which is incorrect. We’ll kick off the processes required for that to happen asap.

Improve this answer
7
  • 5
    Are you looking at the internal SEDE? data.stackexchange.com doesn't have the post mentioned by Mad Scientist, nor does it have a table/view named OpinionBasedContent. Commented Nov 18 at 15:47
  • 2
    @Glorfindel The questions are exposed in SEDE, however, the OpinionBasedContent table that cart is mentioning is not exposed. Commented Nov 18 at 17:11
  • 3
    @Hoid I'm not seeing anything here, not am I able to find Mad Scientist's comment on that question in SEDE. Commented Nov 18 at 17:21
  • This is the query I'm using on public SEDE, and the results are emtpy: data.stackexchange.com/stackoverflow/query/1922477 Commented Nov 18 at 19:23
  • 1
    @cart: Thanks for the update! (For others' reference, see the edit: "Facepalm update: 1000 apologies, I was under the impression we’d exposed that table in public SEDE, which is incorrect. We’ll kick off the processes required for that to happen asap.") Commented Nov 18 at 21:36
  • 3
    @V2Blast just to make sure, the fix will be adding the OpinionBasedContent table as well as adding the rows corresponding to these opinion-based posts to the Posts and the PostsWithDeleted table? Commented Nov 18 at 21:38
  • what about Votes, PostFeedback, and PostHistory? Commented Nov 19 at 21:05

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.