Aggregate function

eloahsam

8 months ago

3

• 

  Jarrod

  7 months ago

  Sounds like exactly what @jesschow describes in this post about virtual fields:

  https://twitter.com/payloadcms/status/1645759920761962496?s=20
  
  

  Give that a watch. In your afterRead hook you can use the local api instead of REST because afterRead hooks only run on the server.

  
  
  

  Here is something I just threw together that I think is what you are looking for:

  
  
  

  {
    name: 'categoryCount',
    type: 'number',
    hooks: {
      beforeChange: [
        ({ siblingData }) => {
          siblingData.categoryCount = undefined;
        },
      ],
      afterRead: [
        async ({ req, originalDoc }) => {
          const docQuery = await req.payload.find({
            collection: 'places',
            where: {
              categories: {
                in: [originalDoc.id],
              },
            },
          });
  
          return docQuery.totalDocs;
        },
      ],
    },
  }

• 

  eloahsam

  7 months ago

  yeah im using that now but created a reusable function for future case if another table needs it

  
  

  
  

  export const queryRelations: any = async (data) => {
    const experiences = await payload.find({
      collection: "experiences",
      where: {
        // the 'in' operator is used when relations can be more than one
        category: { equals: data.id },
        // to add more query constraints use 'or', 'and' operator objects
      },
      depth: 0,
      limit: 0,
    });
  
    if (experiences?.docs) {
      return experiences?.totalDocs;
    }
  
    return 0;
  };