# Raw Function limited to 100

**URL:** https://meta.discourse.org/t/raw-function-limited-to-100/233626
**Category:** Support
**Created:** [July 22, 2022, 8:23am UTC](https://meta.discourse.org/t/raw-function-limited-to-100/233626 "2022-07-22T08:23:11Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Lord\_Praise](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lord_praise/32/245925_2.png) [@Lord\_Praise](https://meta.discourse.org/u/Lord_Praise)
#### Post date: [July 22, 2022, 8:23am UTC](https://meta.discourse.org/t/raw-function-limited-to-100/233626/1 "2022-07-22T08:23:11Z")

</div>

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

> **[New Lost Island Breaking News (Ep.1): Confidential Document](https://theantsforum.allstarunion.com/t/new-lost-island-breaking-news-ep-1-confidential-document/2018)**
>
> New Lost Island Breaking News (Ep.1): Confidential Document Breaking news! After more than a month of silence, Jerry received a confidential document of several pages, which is closely related to everyone. The document does not mention the...

I use the raw link  
[https://theantsforum.allstarunion.com/raw/2018](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

---

<div class="post-metadata">

### Author: ![Benjamin\_D](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/benjamin_d/32/277831_2.png) [@Benjamin\_D](https://meta.discourse.org/u/Benjamin_D)
#### Post date: [July 22, 2022, 9:32am UTC](https://meta.discourse.org/t/raw-function-limited-to-100/233626/2 "2022-07-22T09:32:19Z")

</div>

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`

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [July 22, 2022, 10:27am UTC](https://meta.discourse.org/t/raw-function-limited-to-100/233626/3 "2022-07-22T10:27:49Z")

</div>

You can also use the [data explorer](https://meta.discourse.org/t/discourse-data-explorer/32566) too if you there are a lot of pages. I think something like this would work:

```plaintext
-- [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)

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [August 25, 2022, 8:18am UTC](https://meta.discourse.org/t/raw-function-limited-to-100/233626/5 "2022-08-25T08:18:02Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.