57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
postLength: {
_lt: 100000
},
},
// Ordered by author's name + createdAt
orderBy: [["name", "ASC"], ["createdAt", "DESC"]],
// Only takes these fields (the rest aren't queried)
select: ["id", "author", "age"],
// Takes the total count of posts (useful when paginating because only 25 are returned by default)
takeCount: true,
});
// Views can be queried directly for faster access (without having to create a loader, yet getting access to all the filters)
const specificPosts = postsView.load({
select: sql.fragment`SELECT posts.title, posts.text`,
where: {
id: [123]
},
});
1
Installing dependencies...