Raw Function limited to 100

I want to get all comments via raw function under my post

I use the raw link
https://theantsforum.allstarunion.com/raw/2018

the last comment of raw link is “Irbef | 2022-07-16 11:45:50 UTC | #101”, but that is not the correct one, the last should be on July 21, but not July 16, please help me

Hi,
the raw route seems to be paginated:
https://theantsforum.allstarunion.com/raw/2018?page=2
https://theantsforum.allstarunion.com/raw/2018?page=3
https://theantsforum.allstarunion.com/raw/2018?page=4

3 Likes

You can also use the data explorer too if you there are a lot of pages. I think something like this would work:

-- [params]
-- int :topic_id

SELECT p.topic_id,
       p.post_number, 
       p.raw,
       p.cooked
FROM posts p
WHERE p.topic_id = :topic_id
ORDER BY p.post_number ASC

(Though that would only be useful to admins, or the groups the admin allowed to access the query, so may not be applicable in this case)

3 Likes