Skip to main content
clarified my question
Source Link
ashleedawg
  • 256
  • 1
  • 11

I'm trying to figure out the best way to compile all "post threads" (a QuestionQuestions and all related Answers and Comments) where a specific user owns any of the Q, A or C{Question, Answer or [a comment on either the Q or A]}.

itIt seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
  - `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

Is there a better way to do this?

It doesn't help that I've also been intermittently fighting with the the with intermittent "missing comments"missing comments" problem.

Thanks!

I'm trying to figure out the best way to compile all "post threads" (a Question and all related Answers and Comments) where a specific user owns any of the Q, A or C.

it seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
  - `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

Is there a better way to do this?

I've also been fighting the with intermittent "missing comments problem.

Thanks!

I'm trying to figure out the best way to compile all "post threads" (Questions and all related Answers and Comments) where a specific user owns any of the {Question, Answer or [a comment on either the Q or A]}.

It seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
  - `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

Is there a better way to do this?

It doesn't help that I've been intermittently fighting with the "missing comments" problem.

Thanks!

added 3 characters in body
Source Link
Brock Adams
  • 13k
  • 5
  • 39
  • 64

I'm trying to figure out the best way to compile all "post threads" (a Question and all related Answers and Comments) where a specific user owns any of the Q, A or C.

it seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
  - `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

Is there a better way to do this?

I've also been fighting the with intermittent "missing comments problem]1the with intermittent "missing comments problem.

Thanks!

I'm trying to figure out the best way to compile all "post threads" (a Question and all related Answers and Comments) where a specific user owns any of the Q, A or C.

it seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
- `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

there a better way to do this?

I've also been fighting the with intermittent "missing comments problem]1.

Thanks!

I'm trying to figure out the best way to compile all "post threads" (a Question and all related Answers and Comments) where a specific user owns any of the Q, A or C.

it seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
  - `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

Is there a better way to do this?

I've also been fighting the with intermittent "missing comments problem.

Thanks!

Source Link
ashleedawg
  • 256
  • 1
  • 11

Get everything touched by a user?

I'm trying to figure out the best way to compile all "post threads" (a Question and all related Answers and Comments) where a specific user owns any of the Q, A or C.

it seems like there's probably a more efficient way than the combinations of methods I've been trying, for example:

 (1) get `question_id`'s from `users/xxx/questions`
 (2) get `question_id`'s from `users/xxx/answers`
 (3) get `combined list` of `post_id` + `post_type` from   
- `users/xxx/comments` and `users/xxx/mentioned`,
    - then split into 2 post-types:  
    - if post_type="question" then it's a question_id  
     - remaining `post_id`'s are `answer_id`'s: 
        (4) get `question_id`'s from `answer/{ids}`

Finally, combine all question_id's into unique list and query them again, for selected fields from questions/answers/comments. (body, dates, counts, userids, username, wrapper).

there a better way to do this?

I've also been fighting the with intermittent "missing comments problem]1.

Thanks!