# Limiting the Displayed Rows in Datview Table, is it possible?

**URL:** <https://forum.obsidian.md/t/limiting-the-displayed-rows-in-datview-table-is-it-possible/72094>\
**Category:** Help\
**Created:** [November 28, 2023, 9:38pm UTC](https://forum.obsidian.md/t/limiting-the-displayed-rows-in-datview-table-is-it-possible/72094 "2023-11-28T21:38:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![glvercellone](https://forum.obsidian.md/user_avatar/forum.obsidian.md/glvercellone/32/56148_2.png) [@glvercellone](https://forum.obsidian.md/u/glvercellone)\
**Post date:** [November 28, 2023, 9:38pm UTC](https://forum.obsidian.md/t/limiting-the-displayed-rows-in-datview-table-is-it-possible/72094/1 "2023-11-28T21:38:07Z")

</div>

Hello Obsidina makers,

I have a question regarding the possibility of limiting the number of lines displayed in a Datview table. To clarify, my query consists of 20 lines, and I would like to display only 10 lines, specifically from position 3 to 13. Is there a method to achieve this?

Best regards

---

<div class="post-metadata">

**Author:** ![holroy](https://forum.obsidian.md/user_avatar/forum.obsidian.md/holroy/32/77699_2.png) [@holroy](https://forum.obsidian.md/u/holroy)\
**Post date:** [November 28, 2023, 10:38pm UTC](https://forum.obsidian.md/t/limiting-the-displayed-rows-in-datview-table-is-it-possible/72094/2 "2023-11-28T22:38:18Z")

</div>

Pagination is not easy to do, but getting a subset is easier. Not nice, but easier…

Try something like the following:

````auto
```dataview 
LIST
SORT file.name asc
LIMIT 13
SORT file.name desc
LIMIT 11
SORT file.name asc
```

````

This will first get the 13 first files, then loose the two first (which now are at the end) and then display pos 3 to 13 in correct order… 🙂

---

<div class="post-metadata">

**Author:** ![system](https://forum.obsidian.md/uploads/default/original/3X/b/e/bec35fbd23ab28909bb6bfe62cb32eb82dd34019.png) [@system](https://forum.obsidian.md/u/system)\
**Post date:** [February 26, 2024, 10:39pm UTC](https://forum.obsidian.md/t/limiting-the-displayed-rows-in-datview-table-is-it-possible/72094/3 "2024-02-26T22:39:08Z")

</div>

Closed on February 26, 2024, 10:39pm UTC

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