- commit
- b7e5168
- parent
- c6594eb
- author
- Eric Bower
- date
- 2024-09-08 02:49:26 +0000 UTC
fix(pgs): rss feed
1 files changed,
+1,
-1
+1,
-1
1@@ -1742,7 +1742,7 @@ func (me *PsqlDB) FindProjectsByUser(userID string) ([]*db.Project, error) {
2 func (me *PsqlDB) FindAllProjects(page *db.Pager, by string) (*db.Paginate[*db.Project], error) {
3 var projects []*db.Project
4 sqlFindAllProjects := fmt.Sprintf(`
5- SELECT projects.id, user_id, app_users.name as username, projects.name, project_dir, projects.acl, projects.created_at, projects.updated_at
6+ SELECT projects.id, user_id, app_users.name as username, projects.name, project_dir, projects.acl, projects.blocked, projects.created_at, projects.updated_at
7 FROM projects
8 LEFT JOIN app_users ON app_users.id = projects.user_id
9 ORDER BY %s DESC