In factiiis.controller.ts the`getFactiiiPosts` function has an if statement. The factiiiId===refFactiiiId is s

Question

In factiiis.controller.ts the`getFactiiiPosts` function has an if statement. The factiiiId===refFactiiiId is supposed to fetch posts where the ONLY factiii is the refFactiiiId. This feeds the top Post.tsx for the f/ page in client. The else statement catches the posts that have both factiiis. Once we figure out how to do the first part we can make this into 1 query with the ,,,(factiiiId===refFactiiiId) &&(), but for now we don’t have a way to perform this query without manual filtering which prevents us from paginating the query properly. Most likely we will have to get this query working with a queryRaw into postgres because I don’t think prisma can handle this yet, I referenced a stackedoverflow in the comments from me a long time ago. I changed factiii to tag in the stackedoverflow question.

shyam · Accepted Answer

In factiiis.controller.ts the`getFactiiiPosts` function has an if statement. The factiiiId===refFactiiiId is supposed to fetch posts where the ONLY factiii is the refFactiiiId. This feeds the top Post.tsx for the f/ page in client. The else statement catches the posts that have both factiiis. Once we figure out how to do the first part we can make this into 1 query with the ,,,(factiiiId===refFactiiiId) &&(), but for now we don’t have a way to perform this query without manual filtering which prevents us from paginating the query properly. Most likely we will have to get this query working with a queryRaw into postgres because I don’t think prisma can handle this yet, I referenced a stackedoverflow in the comments from me a long time ago. I changed factiii to tag in the stackedoverflow question.

‌

- indivudal factii
  - The factiiiId===refFactiiiId query
- vs multi factiii
  - the else side

Update post fetching logic for /f/[factiiiSlug]

Activity