Field for deleted pages? #2118

New Issue

OVERLORD · 2026-02-05T02:58:29+03:00

OVERLORD commented

2026-02-05 02:58:29 +03:00

Originally created by @techauthoruk on GitHub (Feb 24, 2021).

Hi

Hope someone can help. I currently have a query that I run weekly that returns all the new pages that have been added in the previous 7 days. The query works fine, BUT if I forget to empty the BookStack recycle bin, these documents are included in the query results.

Is there a field in the PAGES table that flags when a page is deleted? If there is I can just add that as a criteria in my query.

Many thanks for any assistance - it will be greatly appreciated!

Mark

Originally created by @techauthoruk on GitHub (Feb 24, 2021). Hi Hope someone can help. I currently have a query that I run weekly that returns all the new pages that have been added in the previous 7 days. The query works fine, BUT if I forget to empty the BookStack recycle bin, these documents are included in the query results. Is there a field in the PAGES table that flags when a page is deleted? If there is I can just add that as a criteria in my query. Many thanks for any assistance - it will be greatly appreciated! Mark

OVERLORD closed this issue

2026-02-05 02:58:34 +03:00

OVERLORD commented

2026-02-05 02:58:41 +03:00

@ssddanbrown commented on GitHub (Feb 25, 2021):

Hi @techauthoruk,
There should be a deleted_at timestamp field on the table. This will be null if the page is not deleted.

@ssddanbrown commented on GitHub (Feb 25, 2021): Hi @techauthoruk, There should be a `deleted_at` timestamp field on the table. This will be `null` if the page is not deleted.

OVERLORD commented

2026-02-05 02:58:45 +03:00

@techauthoruk commented on GitHub (Feb 25, 2021):

@ssddanbrown

Thanks Dan, that was most helpful

@techauthoruk commented on GitHub (Feb 25, 2021): @ssddanbrown Thanks Dan, that was most helpful

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#2118