29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
`;
export const postsLoader = makeQueryLoader({
query: {
select: postsQuery,
view: postsView,
},
defaults: {
orderBy: [["id", "ASC"]],
take: 25,
},
options: {
orFilterEnabled: true,
},
sortableColumns: {
id: ["posts", "id"],
name: sql.fragment`users."firstName" || users."lastName"`,
// Can reference FROM tables when using raw sql fragments
createdAt: ["posts", "created_at"],
},
});
postsLoader.loadPagination({
where: {
createdDate: {
_gte: "2023-01-01"
},
// Only gets posts after 2023-01-01, shorter than 100k characters
postLength: {
_lt: 100000
1
Booting up webcontainer...